ASP.NET News from Blogger: DataWorks WebLog   Get the feed of: DataWorks WebLog

Total News: 53

Quick update re: Data Access blog.

We're putting this blog (Data Access blog) into suspended animation. That doesn't mean we will stop blogging about ADO.NET and data access stuff, or that we'll take down published posts or comments he...

ADO.NET and SQL Server Everywhere

Steve Lasker has posted a screencast / video over on Channel 9 providing an overview on the various ADO.NET programming options available for SQL Server Everywhere, including an updateable r...

What I Wish Developers Knew About 'x' in / for SQL Server 2005 (webcasts)

Database Journal has a good list of some upcoming SQL Server related live webcasts scheduled for July (on MSDN and TechNet): Some that should be of interest for developers using ADO.NET: What I Wish ...

ADO.NET vNext - feedback so far

Since announcing our ADO.NET vNext plans at TechEd last week, the team has been on the lookout for your feedback on where we heading with the next release. This post is a round up of some of the comme...

ADO.NET vNext screencast

Hi - I'm Shyam Pather, Development Lead on the ADO.NET vNext team. Im incredibly excited to share some demos of ADO.NET vNext in action. By now, many of you may have read the whitepapers and blog...

ADO.NET vNext: The Entity Framework, LINQ and more

Once you are done with shipping large products such as SQL Server 2005 and Visual Studio 2005 youd expect to have a quiet time for a while, slow down a bit, that kind of stuff Turns out that it wasnt ...

On Future Versions of ADO.NET

Once you are done with shipping large products such as SQL Server 2005 and Visual Studio 2005 youd expect to have a quiet time for a while, slow down a bit, that kind of stuff Turns out that it wasnt ...

ADO.NET mapping screencast

So, Now that we are talking about the upcoming ADO.NET Entity Framework, I thought it would be interesting to do a screencast on our mapping infrastructure. If you have seen our ADO.NET architecture d...

Lightweight Promotable Transactions, SqlDataReader and Commitment.

Here's a small issue you may need to watch out for when using a System.Transactions transaction with SqlClient v2.0 and Sql Server 2005.  This combination is required to get LWPTs. The basics of ...

Data Access with Visual Basic 2005 (Webcast)

Register to watch this: MSDN Webcast: Data Access with Visual Basic 2005 (Level 200) Start Time:   Wednesday, April 12, 2006 9:00 AM (GMT-08:00) Pacific Time (US & Canada)  End Ti...

We love customers like David Hayden!

We love customers like David Hayden! David has been spending time at the MSDN Forums (in particular the .NET Framework Data Access forum) helping out those who've got stuck and blogging a bunch of ADO...

Adding nesting options to DbConnectionScope.

I managed to squeeze in enough time to implement nesting options for the DbConnectionScope class.  My approach was to follow the nesting option pattern given by TransactionScope, so I added a DbC...

ADO.NET Versions and Indexing

Julia Lerman over at DevSource posted this quick article: "Someone asked me about ADO.NET indexing which encouraged me to write about some of the amazing performance tests I have done comparing VS20...

Fun Hash Joins with VB9 LINQ

Brian Beckman is a Software Architect in the Data Programmability team here at Microsoft. His latest post should give you a good idea of the kind if stuff he's working on - Fun Hash Joins with VB9 LIN...

Developers! - Express contest - win $10K

A new worldwide contest for developers has been launched by the folks at Visual Studio Express and SQL Server Express. Here's how it goes: you think of something cool using Visual Studio E...

An Introduction to Data Structures

In November 2003 MSDN Online published a popular six-part series on using data structures in the .NET Framework. In 2005, the first part was updated to take advantage of the new data structu...

Conversation with scientist, engineer and database legend Jim Gray

Channel 9 has posted great video interview with Jim Gray, a researcher and manager of Microsoft Research's eScience Group. "This episode features Jim Gray. He is a "Technical Fellow" in the Scalea...

Data Binding in ASP.NET 2.0

Jesse Liberty has written up a good article showing how bind data into ASP.NET control over at O'Reilly's brand new ASP.NET 2.0 Training Center site: "...in the next version of the .NET Framework a ...

.NET Rocks! - LINQ with Barry Gervin

Over at .Net Rocks!, Regional Director Barry Gervin introduces LINQ, a nascent set of language extentions providing query services for list-based objects. - Alex Barnett,Community Program Manager...

A ConnectionScope class. [Alazel Acheson]

Ive heard a few comments from people who would like an easier way to manage connection lifetime & use across multiple methods. Most often, the problem is due to using a TransactionScope at an high...

Getting Schema in ADO.Net 2.0

Carl Perry, a Program Manager from our ADO.Net team has blogged about how to use and extend the new MetaData Schema functionality in ADO.Net 2.0. The blog is here: http://blogs.msdn.com/cperry/archiv...

Shawn Wildermuth on Decomposing ADO.NET

The .NET Rocks! Show had Shawn Wilderman as their guest last week. Shawn is the Microsoft C# MVP who runs ADO.NET Guy: "Carl and Richard interview Shawn Wildermuth about ADO.NET. He's down on dataso...

WinFS and peer-to-peer

Mark Scurrell, Program Manager on the WinFS Sync team has provided an overview on the WinFS blog of the functionality provided to allow applications to synchronize data between WinFS stores: "F...

Impersonation inside SQLCLR Stored Procedure [Jian Zeng]

In SQL Server 2005, we now have the ability to write managed (or CLR) code inside a Stored Procedure. This implies that you now have the capability to connect to a remote or the local  ...

Microsoft SQL Server 2005 JDBC Driver -- RTW [Shelby Goerlitz]

After two betas and 6 months of customer feedback the SQL Server 2005 JDBC Driver is generally available for download here http://msdn.microsoft.com/data/jdbc.   Our core goal with this new driv...

PDC 05 demos - Query Processing over DataSet, Fast Uploads, Caching

First of all Ill have to apologize because it took me several months to put this code out here. Right after PDC we were so busy that I didnt have the chance before to sit down, clean-up the code a lit...

Our team at Launch 2005

If you havent seen it yet, SQL Server 2005 and Visual Studio 2005 products have been released to manufacturing. It really feels good to call the product done and have it shipped to our customers. An o...

ADO.Net 2.0: Relative paths in ConnectionString [Sushil Chordia]

In SqlClient Managed Provider, there has always existed (right from ADO.Net 1.0 days) a keyword in the connection string called AttachDbFileName. The user could have the location of the database file ...

JDBC 2005 Beta 2 Data Coercion [Angel-Saenz Badillos]

We wanted to be very explicit with our data coercion story for the JDBC 2005 driver, as far as we have been able to we are not going to allow getting a type from the server that would require a downca...

Microsoft SQL Server 2005 JDBC Driver -- Beta 2 [Shelby Goerlitz]

After a summer of hard work the Beta 2 of the JDBC driver is now available -- you can download it here.  The big changes from Beta 1 are largely under the hood, and we had two main goals in...

SqlDependency changes for RTM [Sushil Chordia]

As mentioned in my previous blog, SqlDependency is a new feature in .Net framework 2.0, which provide a mechanism to notify an app when a cache is invalidated. We got enough feedback from customers in...

PDC05 is next week!

The Microsoft Professional Developers Conference will happen next week in Los Angeles. Were all really exited about this and weve been working on content and demos for our talks, as well as cleaning u...

PDC is next week!

The Microsoft Professional Developers Conference will happen next week in Los Angeles. Were all really exited about this and weve been working on content and demos for our talks, as well as cleaning u...

Introduction to SQL 2005 Native XML Web Services (SOAP)

The Native XML Web Services (SOAP) being a new feature in SQL 2005, I like to provide a brief overview of what it is and possible scenarios where it may be more useful then using normal SQL connection...

Getting the MARS Sample working in the June CTP

Multiple Active Result Sets (MARS) is a cool new feature in SQL Server 2005 which allows you to start and begin processing another query while you are in the middle of processing a different query on ...

SSL in SQL Server 2005 [Il-Sung Lee]

I often receive questions inquiring about the (channel) encryption capabilities in SQL Server 2005. Like SQL Server 2000, 2005 can use SSL (Secure Socket Layer) to secure transmissions over ...

Using MARS with SQL Native Client [Chris Lee]

As stated in my previous post, the majority of new features available through SQL Native Client are accessed by connection or statement properties. MARS is about the simplest new feature to use in SQL...

Getting started with SQL Native Client [Chris Lee]

As Acey Bunch explained in April, SQL Native Client meets the needs of developers wanting to take advantage of new features in SQL Server 2005 from ADO, ODBC and OLE DB applications. For those of you ...

Samples for MSDN Webcast: Using Web Services To Connect to SQL Server 2005

Srik Raghavan, Lead Program Manager from the Dataworks team presented a MSDN WebCast on 4/7/2005 titled: "MSDN Webcast: Using Web Services To Connect to SQL Server 2005 from Your Smart Client Applica...

Win the Ultimate Chopper!

Share your story of migrating from Oracle to SQL Server, and the ultimate chopper might just migrate its way into your garage!  For more details visit: http://www.sqlserverchopper.com/  ...

Microsoft SQL Server 2005 JDBC Driver

As re-enforcement of Microsofts continued commitment to interoperability, the SQL Server team will release a new & fully supported JDBC driver for SQL Server 2000 & SQL Server 2005 known as th...

Exceptions in ADO.Net 2.0 [Siraj Lala]

Id like to briefly talk about some of the work we have done in ADO.NET 2.0, for improvement of Errors and Exception usage. In ADO.NET 1.1, several error messages were generic and didnt have enough det...

Dataworks team at TechEd 2005

How many of you are coming to TechEd 2005 in Orlando  A show of hands, please.  Excellent! The DataWorks team will be at TechEd, delivering sessions, chatting in the cabana and in the booth,...

The end of the MDAC Redistributable [Brad Rhodes]

Microsoft Data Access Components version 2.8 sp1 is the last stand alone redistributable of MDAC that Microsoft will ship. MDAC is a windows component: Upon shipping Windows 2000, Microsoft included ...

Does ADO.NET update batching really do something

Ive gotten this same question several times in the last few weeks, so I thought it would be a good idea to put together some details on the topic. Update batching is a new ADO.NET 2.0 feature that, wh...

Announcing the MDAC 2.8 sp1 Redistributable [Brad Rhodes]

We have shipped MDAC 2.8 sp1.  This is the version of MDAC that originally shipped with Windows XP sp2.  It is also the version of MDAC that is included in SQL Server 2000 sp4.  This v...

Introducing SQL Native Client

By now you may have heard of a new data access technology called SQL Native Client that will ship with SQL Server 2005. But before we go much further in discussing it, lets be clear about what we mea...

.Net Framework 2005 (aka Whidbey) Beta2 Shipped! [Carl Perry]

At long last weve completed and signed-off on Whidbey Beta 2!!!!!  Its been quite a long time since we started working on Beta 2; once this hits the web it will have been almost 9 months of bug f...

Using ADO.NET inside SQL Server 2005 with SQLCLR

SQL Server 2005 enables the creation of procedures, functions, etc. using managed code. Since you can use managed code, sooner or later youll want to access some data in the same or a different server...

API Changes between CTP [Pablo Castro]

Weve been seeing several comments on email and blogs lately about changes in the APIs between CTP (Community Tech Preview) releases. I understand the frustration that these changes could cause, so I w...

View Other bloggers