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 here - it's just means we'll carry on blogging about...

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 resultset (SqlCeResultSet). While on the subject, check out...

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 Developers Knew About Writing Queries in SQL...

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 comments / feedback we've heard. It's certainly not all...

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

Once you are done with shipping large products such as SQL Server 2005 and Visual Studio 2005 you’d expect to have a quiet time for a while, slow down a bit, that kind of stuff… Turns out that it wasn’t the case this time. Right after SQL Server 2005...

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 Time: Wednesday, April 12, 2006 10:00 AM (GMT-08:00) Pacific...

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.NET 2.0 stuff. Here's a list of David's helpful...

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 VS2003 and VS2005's DataTable indexing."

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 Express and SQL Server Express . It could be desktop app...

A new article published at Developer.com is worth checking out: Ten of the Biggest Mistakes Developers Make With Databases .

Jesse Liberty has written up a good article showing how to 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 great deal of the ADO.NET object model has been...

I’ve 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 higher level, but opening and closing connections inside...

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/archive/2006/02/06/526323.aspx This is one blog that...

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 datasources as a one-size-fits-all solution to data...

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 SQL Server with ADO.NET via the System.Data assembly. When doing so...

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 assigned to this keyword in the connection string and...

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 Beta 2 with regards ease of deployment (some issues...

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 the same connection. Unfortunately the MARS sample...

I’d 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 didn’t have enough detail to make them actionable. An example of this is...

I’ve 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, when enabled, introduces an optimization to the process...

At long last we’ve completed and signed-off on Whidbey Beta 2!!!!! It’s 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 fixing, security reviews, feature completion, and scrambling...

We had got good amount of feedback from developers in 1.0 and 1.1 versions for need to have a Connection-String Builder. Consider that you want to develop an application that needs to dynamically build a connection string depending on the Data Source...

Many of us would like to have a space to write about the stuff we do, publish open issues for debate, and in general have a handy, informal point of contact with our developer community. Most of us don’t have the time to actually sign up for a blog and...