Click here to Skip to main content
Click here to Skip to main content

On Premises Entity Framework and SQL Azure

, 11 Jun 2013
Rate this:
Please Sign up or sign in to vote.
Code Project Virtual Tech Summit Session: 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 s

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.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Julie Lerman

United States United States
No Biography provided

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web04 | 2.8.140826.1 | Last Updated 11 Jun 2013
Article Copyright 2011 by Julie Lerman
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid