Share via

Connecting to SQL Azure using Entity Framework

  • Article

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 https://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 Azure team has been posting some great info on how to use Entity Framework:

Using EF’s Model First capability with SQL Azure

This walkthrough shows how you can use EF to actually build your tables in SQL Azure directly from the EF designer.

Demo: Using Entity Framework to Create and Query a SQL Azure Database In Less Than 10 Minutes

In this article you’ll see two great videos – in the first, Faisal Mohamood explains what EF is and some of the benefits it offers .NET developers. In the second, you’ll see how EF can be used to create a SQL Azure database from scratch, populate it with data, and query it – all in less than 10 minutes!

Porting the MVC Music Store to SQL Azure

In this article you’ll see how to take the MVC Music Store tutorial application (which uses EF) and port it to SQL Azure.

Finally, check out this month’s issue of MSDN Magazine where Julie Lerman talks about some of the performance considerations when using EF with SQL Azure.

Comments

  • Anonymous
    November 16, 2010
    The most helpful piece of guidance would be how to reliably connect EF to SQL Azure. Given the connection behavior by design of SQL Azure, robust connection failure retry logic is critical for ALL real world usage. Can the product team provide this as definitive guidance? Thanks, Andy Milligan

  • Anonymous
    November 24, 2010
    The team must be dismissed! Nothing gain for a long time!

  • Anonymous
    December 06, 2010
    Sorry for the rather long wait on this - rest assured that we are working on publishing a recommendation. The reason for the delay is that the guidance is something that will get utilized by many applications out there and we want to make sure that we've ironed out any potential issues before posting a solution. Stay tuned for something this week. If it takes much longer, we'll let you know. Thanks. Faisal Mohamood | Program Manager | Entity Framework

  • Anonymous
    December 11, 2010
    Any updates/pointers/guidance on implementation of the retry logic in EF?