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 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...

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 LWPTs have been pretty widely discussed (here's an example...

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...

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 DbConnectionScopeOptions enum with Required, RequiresNew and...

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."

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 LINQ .

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...

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 structures and features available with the .NET Framework version 2...

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 Scaleable Servers Research Group (Sky Server, Terra Server...

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...

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

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...

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: "For Beta 2 we have decided to focus on providing the...

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...

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 driver is to demonstrate our long-term commitment to providing...

First of all I’ll have to apologize because it took me several months to put this code out here. Right after PDC we were so busy that I didn’t have the chance before to sit down, clean-up the code a little bit, add a bunch of comments and write a README...