SQL Connectivity Annual Survey

Greetings to the SQL Server community :   Last year in October 2009, we introduced  the process of interacting on a regular basis with the developers and users in the form of surveys.  During the last 12 months, we completed surveys that focused on the broad SQL Connectivity components, including ODBC, ADO.NET, JDBC and PHP. … Read more

Microsoft SQL Server has a new connectivity portal page!

The Microsoft SQL Server team is working on a portal page that brings together common resources and community links for all data access providers to Microsoft SQL Server.  We’d like your feedback on how useful you will find it and what else you’d like to see included.  Although, at this time we’re concentrating on bringing… Read more

Exception Handling in the .NET Framework Data Provider for ODBC, OLE DB, and for SQL Server

Developers using the .NET Framework Data Provider for ODBC, the .NET Framework Data Provider for OLE DB, or the NET Framework Data Provider for SQL Server often send feedback to Microsoft, asking for a complete list of the exceptions that a given method can throw.   Until such time as the documentation team updates the… Read more

Extending Lightweight Transactions in SqlClient

We’ve done some work with SqlClient’s System.Transaction support for Sql Server 2008. To explain what we did, and why, I’m going setup some background first, which may also be useful for understanding the existing behavior. System.Transactions offers a simple, intuitive model for controlling transactions in your .Net code, right? I generally agree with that statement,… Read more

ADO.NET at the Advisor Summit

  Last week at the Advisor Summit conference I gave a talk introducing new LINQ functionality being introduced in the Orcas timeframe (and beyond).    As you probably know if you’ve been reading this blog regularly, LINQ functionality will begin to ship as part of Visual Studio Codename “Orcas” and the .NET Framework. The Orcas… Read more

ADO.NET Entity Framework Update

Microsoft is deepening its investment in the ADO.NET Entity Framework as a critical piece of Microsoft’s Data Platform vision. Based on the need to align with requirements from key internal partners that are building on the Entity Framework, along with the need for a better tool experience, we have decided to ship the ADO.NET Entity… Read more

Entity Framework Orcas Beta 1 – EDM Wizard Fixed

Late last week, after bits had been finalized, we found a bug in the ADO.NET Entity Data Model Wizard that shipped with Visual Studio “Orcas” beta 1. The problem has now been corrected.   Please download and install the patch available at: http://www.microsoft.com/downloads/details.aspx?FamilyID=f69e9eb8-0ebd-4fba-a4cc-2050297ba75b&displaylang=en to fix the problem.   Thank you, Sanjay Nagamangalam Program Manager, ADO.NET… Read more

ADO.NET Entity Framework – Orcas Beta 1

  What else do you need to know about the Entity Framework?  We’ve documented basic syntax and provided a few samples.  How can we improve the documentation?  Send us scenarios you want to implement.   Orcas Beta 1 contains the ADO.NET Entity Framework.  This technology requires new ways of thinking about data applications.  The documentation… Read more

.NET Rocks with the ADO.NET Team!

Daniel Simmons, ADO.NET Dev Lead, recently sat down with Carl Franklin and Richard Campbell of .NET Rocks to talk in depth about the new ADO.NET Entity Framework. Check out Show #226 and learn more about Microsoft’s vision for the Entity Framework long-term and how it is being realized in current development efforts, as well as in releases such as the… Read more