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

MVC + Code-First + Azure Part 2: Deployment

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 the previous article, you learned how to create a basic MVC application using Code First. In the second and final section you will learn how to prepare and deploy your application to… Read more

MVC + Code-First + Azure Part 1: Local Development

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. This entry will guide you through the process of creating a simple workout tracker application using ASP.NET MVC and the Code First development approach.  MVC stands for Model View Controller you can find… Read more

Managing Connections with SQL Azure and Entity Framework

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. For using EF with SQL Azure see http://msdn.com/data/jj556244 The Windows Server AppFabric Customer Advisory Team recently put together some great guidance on managing connections with SQL Azure and EF.  They outline common connection… Read more

Connecting to SQL Azure using Entity Framework

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. For using EF with SQL Azure see http://msdn.com/data/jj556244 The Entity Framework provides a very powerful way to access data stored in the cloud, particularly in SQL Azure.  Over the past month the SQL… 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

Remember to re-enable MARS in your SQL Azure based EF apps

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. For using EF with SQL Azure see http://msdn.com/data/jj556244 MARS (Multiple Active Result Sets) is a feature in SQL Server / ADO.NET that allows for multiple results-sets to be streamed over a single connection;… Read more