Data Access blog

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

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, let’s be clear about what we mean by “new”. It is new in that this data access library...

Using MARS with SQL Native Client - By Chris Lee...

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

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 the wire independent of the network protocol used. However, unlike...

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

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

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 who haven’t looked at SQL Native Client yet we now...

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

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

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

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 version of MDAC fixes a number of important security bugs. The download...

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

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

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

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

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

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

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

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

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 .

The Microsoft Professional Developers Conference will happen next week in Los Angeles. We’re all really exited about this and we’ve been working on content and demos for our talks, as well as cleaning up some of our prototypes for the future generation...

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 connections. SOAP as many of you know stands for Simple Object...