SQL Azure EF Database First Connection String in Azure Management Portal
I have a site running n Azure, which uses EF Database First model.
If I embed the connection string in the web.config and deploy all is rosy.
<add name="MyEntities" connectionString="metadata=res://*/App_Code.Model.csdl|res://*/App_Code.Model.ssdl|res://*/App_Code.Model.msl;provider=System.Data.SqlClient;provider connection string='Data Source=my.database.windows.net;Initial Catalog=myTest_DB;User ID=***;Password=***; MultipleActiveResultSets=False'" providerName="System.Data.EntityClient"/>
But, I don't want the connection string in the web.config because it contains credentials.
So I moved it to the connection string area in Azure Properties.
First issue I hit is getting metadata invalid keyword error.
I solved that by changing the type from SQL Database to Custom.
However, I now get this error:
The connection string 'MyEntities' in the application's configuration file does not contain the required providerName attribute."
I've trawled the web and tried many variations of the connection string but not yet found the correct one.
Note: I guess I could make this an app setting and move the initialisation of the string to code, but even if only for curiosity sake I would like to know how to do it via the portal.
The problem is not the connection string, but the inability to specify the providerName from the portal.
Try publishing with a local or dummy connection string in place, and overwriting it as you have in the Azure Application Settings. See this answer: https://stackoverflow.com/a/18964294/94853
- Cannot connect .NET app with MongoDB (System.MissingMethodException: Method not found:)
- Entity Framework Fluid Query Start and End Dates When Start is Nullable
- Newest version of npgsql with Entity Framework casting enum type error
- Unable to create an object of type 'MyContext'. For the different patterns supported at design time
- How do I control parameter sniffing and/or query hints in entity framework?
- How to add OPTION RECOMPILE into Entity Framework
- How do I view the SQL generated by the Entity Framework?
- Log Queries executed by Entity Framework DbContext
- Use int Id for a bigint column in EF6
- Entity Framework not loading related objects
- What does the DBContext.Entry do?
- "where" clause: entity id is in a potentially null array
- Entity Framework query slow, but same SQL in SqlQuery is fast
- What is the right way to get data from related tables using an entity and business models separately in ASP.NET Core Web API?
- How to add a model in asp.net mvc project
- Entity Framework - Check for pending migrations
- Check for pending migrations in Entity Framework?
- How to use query with quotes inside a parent query
- Constructor injection into IDesignTimeDbContextFactory
- An error occurred while accessing the Microsoft.Extensions.Hosting services when do first migrations
- Can I create an app with swift to controle a go pro camera from the phone?
- EF Core navigation properties to both a collection and a specific item in the collection
- Assign Credentials (user name/password) to EF in Code
- How to get next value of SQL Server sequence in Entity Framework?
- How to set a default value on a Boolean in a Code First model?
- Catch SqlException at the controller level?
- BeginTransaction with IsolationLevel in EF Core
- in entity framework code first, how to use KeyAttribute on multiple columns
- Cannot access a disposed context instance EF core
- Multiple includes using Entity Framework and Repository Pattern