Using SqlDataReader’s new async methods in .Net 4.5

With .Net 4.5, ADO.NET introduced two asynchronous methods to the SqlDataReader class: ReadAsync and NextResultAsync. These two methods allow you to move to the next row or result set asynchronously and represent a much more fine-grained level of asynchronous access to data compared to .Net 4.0 (which only had asynchronous command execution). However, for the… Read more

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

Data Access Guidance

When considering how your application will connect to a data source, there’s a variety of technologies, patterns, and architectures to consider.  Recently we published a “Summary of Data Access Guidance” on the MSDN Data Developer Center.  If you want to drill deeper into the material, please check out Shyam Pather’s TechEd talk: Data Development GPS:… 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

ADO.NET Survey Results

A while ago, we, the core ADO.NET team, sent out a survey in order to gather your feedback about some suggestions and future ideas for our products. Now, it’s more than time to share the results with you. We had a total of 559 respondents, most from Europe and USA, representing mostly software manufacturers, financial… Read more

Improvements to Generated SQL in .NET 4.0

The information in this post is out of date. Visit msdn.com/data/ef for the latest information on current and past releases of EF. In a previous post (http://blogs.msdn.com/adonet/archive/2009/08/05/improvements-to-the-generated-sql-in-net-4-0-beta1.aspx), we talked about the improvements to the quality and the readability of the SQL generated when querying using the Entity Framework that we made in .NET 4.0 Beta… Read more

There is still time to make yourself heard

The ADO.NET Providers team still needs your input.  This is the last week to answer our ADO.NET Managed Providers Planning survey.   Help us to make the decisions that will benefit our database community.   The survey can be found at http://blogs.msdn.com/adonet/archive/2009/11/01/the-ado-net-providers-team-wants-to-hear-your-opinion.aspx.   ThanksLuiz Fernando SantosProgram Manager, SQLClient… Read more