Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Connection String Template for EF Model-First Database Connection

branch: master

Fetching latest commit…

Octocat-spinner-32-eaf2f5

Cannot retrieve the latest commit at this time

Octocat-spinner-32 README.md
README.md

Connection String Template

for Windows Azure/EF Model-First Database

Sometimes we need to develop using Entity Framework in a Model First or Database-First context. If we deploy a website using EF Model First to Windows Azure Websites, the connection string and configuration can be finicky, and it can be difficult to tell what we are doing wrong.

The connection string pattern below can be used directly in the Azure Website Connection String Configuration settings, after replacing the <angle bracketed> items with your own values (replace the angle brackets too - they are not part of the connection string).

Name the connection string in the configuration panel to match the Model-First Connection string in your Web Application.

The Azure Connection String for Model-First Connection:
    metadata=res://*/Models.<EFModel>.csdl|res://*/Models.<EFModel>.ssdl|res://*/Models.<EFModel>.msl;provider=System.Data.SqlClient;provider connection string="data source=tcp:<AzureServer>.database.windows.net;initial catalog=<AzureDatabaseName>;Persist Security Info=True;User ID=<UserLogIn>@<AzureServer>;Password=<UserPassword>"

For more information, see the related post:

ASP.NET MVC–Azure Websites and EF Model First Connection Strings when Deploying from Github

Something went wrong with that request. Please try again.