Entity Framework With Microsoft Azure SQL

To use SQL Azure with your Entity Framework, first create an SQL database first in your Azure account. If you want learn more about SQL Azure then follow the following links:

So, let’s make an SQL database. Here are the steps,

Go to your Azure account find New, Data + Storage, then click SQL Databases.

Fill the details and proceed to next.

After creating SQL Azure database successfully, then just go to Visual Studio and open Server Explorer. Just login with Azure Account and find the database created in Azure.

Right click on it and open it with SQL server Object Explorer so that we can create table and manage my database from wizard.

Just enter your database authentication details which were entered by you on the Azure portal to create a database and make sure that a client IP address has been added in to server configurations.

After connection with SQL Azure database into Server Explorer, you can see the database and all its tables and other things but I am not having any table yet, so make a table first. For that, right click on tables section and add a new table.

Just write your create table script on the script section and at last just click on update button.

Now, you’ll get dialog where you have to click on “Update Database” button.

Now it’s creating a table you see your query updates in Data tools options.

Just go to back on SQL Server object explorer and refresh tables. You’ll get the new table created by your query.

Now just add an ASP.NET or any other application where you want to use this database. I am going to use an ASP.NET project to use this database with entity framework.