Code Project Virtual Tech Summit Session

If you missed the premiere of one of our virtual tech summits you'll still be able to view these sessions. This video originally premiered in our Cloud Development Summit December 2, 2010.

Abstract

Visual Studio 2010 makes it very easy to use the Entity Framework with a cloud based SQL Azure database. You can build models against an existing Azure database, use the model-first approach to create an Azure database or model against a local database and then switch your connection string to point to SQL Azure. But when your application is hosted on-premises and going a great distance to the SQL Azure database you will be paying a big cost for latency that will impact the performance of your application. Although latency is a fact of life, there are actually things you can do to reduce that latency when writing your Entity Framework queries. In this session, we’ll first look at different ways to build models that will work with a SQl Azure database and then I will provide guidance for avoiding unnecessary latency costs and performance tuning your queries to get the most out of your distributed system.