Data Access blog

(this blog is now in suspended animation - please update your bookmarks!)

  • Data Access blog

    Unification of System.Data.SqlClient and System.Data.SqlServer [Pablo Castro]

    • 33 Comments
    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...
  • Data Access blog

    SqlDependency changes for RTM [Sushil Chordia]

    • 32 Comments
    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...
  • Data Access blog

    ADO.NET vNext screencast

    • 28 Comments
    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...
  • Data Access blog

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

    • 24 Comments
    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...
  • Data Access blog

    Does ADO.NET update batching really do something?

    • 23 Comments
    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...
  • Data Access blog

    Introducing SQL Native Client

    • 20 Comments
    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...
  • Data Access blog

    Impersonation inside SQLCLR Stored Procedure [Jian Zeng]

    • 20 Comments
    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...
  • Data Access blog

    A ConnectionScope class. [Alazel Acheson]

    • 20 Comments
    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...
  • Data Access blog

    Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

    • 19 Comments
    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...
  • Data Access blog

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

    • 16 Comments
    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...
  • Data Access blog

    SSL in SQL Server 2005 [Il-Sung Lee]

    • 13 Comments
    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...
  • Data Access blog

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

    • 13 Comments
    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...
  • Data Access blog

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

    • 12 Comments
    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...
  • Data Access blog

    PDC05 is next week!

    • 11 Comments
    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...
  • Data Access blog

    Using MARS with SQL Native Client [Chris Lee]

    • 10 Comments
    Using MARS with SQL Native Client - By Chris Lee...
  • Data Access blog

    Exceptions in ADO.Net 2.0 [Siraj Lala]

    • 10 Comments
    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...
  • Data Access blog

    ADO.NET vNext - feedback so far

    • 9 Comments
    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...
  • Data Access blog

    ADO.NET and SQL Server Everywhere

    • 6 Comments
    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...
  • Data Access blog

    Welcome!

    • 6 Comments
    Welcome to the DataWorks team blog. If you’re a regular on our MSDN site http://msdn.microsoft.com/data , the public newsgroups or follow Angel’s or Sushil’s blogs you’ve already run across some of the folks from this team. We wanted to create this team...
  • Data Access blog

    Getting started with SQL Native Client [Chris Lee]

    • 6 Comments
    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...
  • Data Access blog

    API Changes between CTP [Pablo Castro]

    • 4 Comments
    We’ve 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 wanted to jump in and comment on the topic. As part...
  • Data Access blog

    We love customers like David Hayden!

    • 4 Comments
    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...
  • Data Access blog

    Data Access with Visual Basic 2005 (Webcast)

    • 3 Comments
    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...
  • Data Access blog

    Introduction to SQL 2005 Native XML Web Services (SOAP)

    • 3 Comments
    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...
  • Data Access blog

    Adding nesting options to DbConnectionScope.

    • 3 Comments
    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...
Page 1 of 2 (44 items) 12