Connecting to Azure DB from Cloud Service utilizing Entity Framework

azure azure-cloud-services azure-sql-database entity-framework-6

Question

I am trying to connect to an Azure SQL Server database from an Azure Cloud Services project through entity framework, but am getting an error of "The underlying provider failed on Open."

I repeated the same process of adding entity framework which I took to create my cloud service on a console based application and the console application was able to successfully connect to the Azure database. For some reason this is not the case with my Cloud Services project. After a few hours of trouble shooting, I think that the problem could lie with my connection string. Can somebody with experience on these technologies please help out? I would really appreciate it. I am new to Azure and so far I think it's great but this is my obstacle right now.

<add name="myProjectDBEntities" connectionString="metadata=res://*/myProject1myProjectModel.csdl|res://*/myProject1myProjectModel.ssdl|res://*/myProject1myProjectModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=f55bjjg4wt.database.windows.net;initial catalog=myProjectDB;user id={loginID};password={password};MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient"/>
1
1
10/4/2014 8:34:53 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You can set your connectionstring in Azure Cloud Service, and it will work.

Same as this in cloud service:

https://docs.google.com/file/d/0B8TtY9U9VCvqeXRMbkFWM000ZnM/edit

Also, you can find "show connectionstring" on your Azure SQL Server database Dashboard.

Copy and paste to your connectionString part. And remember to set your password.

Hope it will help you.

1
10/5/2014 3:32:45 AM

Related Questions

Using Entity Framework, call another WCF Data Service from a WCF RIA Service.

I think your confusion may be that the Visual Studio wizard for adding a RIA service assumes you will use the EntityFramework for your data. I don't think you want to create an EF model out of the data from a second WCF service. Instead, create your RIA service to derive directly from DomainService and override the methods that you need. In each...
c# entity-framework silverlight wcf-data-services wcf-ria-services
asked by Mark Ewer

Handshake exception occurring when connecting to SQL Server Azure with .NET 4.5

The key to understand the problem here is the provider and in your case it is "SSL Provider" and the main problem is that connection time out. If problem was related with "TCP Provider" there could be several reasons related with network etc however in your case it is a security related issue within the connection framework. ...Next step to investi...
.net azure azure-sql-database entity-framework sql-server
asked by AvkashChauhan

How to make Entity Framework Code First use the SQL Azure DB?

You should pass the connection string name to the base constructor of your ...BlogContext... like this...public BlogContext() : base("TestDBContext") { } ...http://msdn.microsoft.com/en-us/library/gg679467(v=vs.103).aspx
azure azure-sql-database c# ef-code-first entity-framework
asked by Pascal

Entity Framework 6.0 Code First Migrations to Azure SQL DB not working.

This guide looks comprehensive: ...http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/migrations-and-deployment-with-the-entity-framework-in-an-asp-net-mvc-application...The key part being "Execute Code First Migrations (runs on application start)"...I hope that helps.
asp.net-mvc azure ef-migrations entity-framework
asked by user2000095-tim

WCF OData Service and EF 6 issue - Can't expose entities using Odata Service

To use WCF DataService with EF6, there're some extra work to do. Please check the following two blog posts for detail:...Using WCF Data Services 5.6.0 with Entity Framework 6+...WCF Data Services Entity Framework Provider is updated with WCF Data Service 5.6.2...In general, you'll need the following two steps:...Install the latest Nuget package ...
entity-framework odata wcf
asked by Karata

Entity Framework's Entity Data Wizard Crashes When Connecting to MySQL Database

It is caused by version mismatch....On my system, I had MySQL Connector 6.9.6. Issuing the command in NuGet Package Manger Console:...Install-Package MySql.Data.Entity installs version 6.9.8 by default. Your connector must match the actual version of the NuGet Package. You can download an updated version of the connector from: ...https://www.mysql....
c# entity-framework-6 mysql visual-studio-2015
asked by Lars Meldgård

How to connect to Oracle DB using TNS alias with Entity Framework 6?

I assume ODP.NET Managed Driverdoes not find your ...tnsnames.ora... file. ODP.NET Managed Driver uses this order to resolve the alias:...data source alias in the ...dataSources... section under ...<oracle.manageddataaccess.client>... section in the .NET config file....data source alias in the ...tnsnames.ora... file at the location specified by ..
.net entity-framework-6 oracle oracle-manageddataaccess visual-studio-2015
asked by Wernfried Domscheit

Connect to Azure SQL using Azure Active Directory from an Azure Website?

There are three ways connecting to SQL database by using Azure Active Directory authentication....Connecting using integrated (Windows) authentication...Connecting with an Azure AD principal name and a password...Connecting with an Azure AD token...More detail about the Azure AD authentication for the Azure SQL database, you can refer ...here......
adal azure-active-directory azure-sql-database azure-web-sites entity-framework-6
asked by Fei Xue - MSFT

Entity Framework - Validation error on entity read at Azure

According to your codes, I have developed a test demo on my computer, it works well....I suggest you could create a new azure sql database and use its connection string directly in the local to test again....More details about my test demo, you could refer to below codes:...IdentityModels.cs:...public class ApplicationUser : IdentityUser { publ...
asp.net-mvc azure c# entity-framework-6
asked by Brando Zhang

Entity Framework DB updating but DB context not showing updates

Thanks to both Eric J and DevilSuichiro for helping me resolve my issue. The problem was that I should not have been trying to use the same DB context. By retrieving a new DB context instead of trying to reuse the same DB context I was able to verify my test results....Many thanks again.
c# entity-framework entity-framework-6 identityserver4 unit-testing
asked by CLSavill

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow