Set Entity Framework Connection String at Runtime in C#

c# entity-framework

Question

I need to set my Entity Framework connection string at runtime. Right now, I have the following:

string connectionString = "metadata=res://*/DataModels.CustomerDataModel.csdl|res://*/DataModels.CustomerDataModel.ssdl|res://*/DataModels.CustomerDataModel.msl;provider=System.Data.SqlClient;provider connection string="data source=tcp:{serverName},{portNumber};initial catalog={databaseName};user id={username};multipleactiveresultsets=True;application name=EntityFramework"";
using (CustomerEntities entities = new CustomerEntities(connectionString))
{
  CustomerEntity entity = new CustomerEntity();
  // do more
  entities.CustomerEntities.Add(entity);
  entities.SaveChanges();
}

When I execute the code above (with the {parameter} values replaced), I get the following error:

Keyword not supported: 'data source'.

What am I doing wrong?

1
20
2/3/2013 4:33:51 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Change this.

string connectionString = "metadata=res://*/DataModels.CustomerDataModel.csdl|res://*/DataModels.CustomerDataModel.ssdl|res://*/DataModels.CustomerDataModel.msl;provider=System.Data.SqlClient;provider connection string="data source=tcp:{serverName},{portNumber};initial catalog={databaseName};user id={username};multipleactiveresultsets=True;application name=EntityFramework"";

To this (note how i escaped the " character as "" )

string connectionString = @"metadata=res://*/DataModels.CustomerDataModel.csdl|res://*/DataModels.CustomerDataModel.ssdl|res://*/DataModels.CustomerDataModel.msl;provider=System.Data.SqlClient;provider connection string= ""data source=tcp:{serverName},{portNumber};initial catalog={databaseName};user id={username};multipleactiveresultsets=True;application name=EntityFramework""";
21
2/3/2013 2:36:05 PM

Popular Answer

I know this was asked 10 months ago, but I found an easier way to specify the connectionString:

If your config file has it as:

<connectionStrings>
<add name="CustomerDataModel" connectionString="metadata=res://*/EntityFramework.CustomerDataModel.csdl|res://*/EntityFramework.CustomerDataModel.ssdl|res://*/EntityFramework.CustomerDataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.\CustomerDataModel;initial catalog=CustomerDB;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

You can specify it as -

public const string ConnectionString = @"name=CustomerDataModel";
..
CustomerDBContext context = new CustomerDBContext(ConnectionString );

No need to worry about quotes. Lot cleaner.

Mukus

Related Questions

Change the database name in the connection string in Entity Framework during runtime.

When you create the ObjectContext, you will need to use the constructor overload that takes a ConnectionString as a parameter....You can build this ConnectionString using an ...EntityConnectionStringBuilder.... More specifically, assuming your underlying database is SQL Server, you can use a ...SqlConnectionStringBuilder... to build up the value fo...
.net entity-framework runtime
asked by Mark Seemann

How can I set the connection string for Entity-Framework Code-First programmatically?

you should use the ...EntityConnectionStringBuilder... class...string providerName = "System.Data.SqlClient"; string serverName = "."; string databaseName = "AdventureWorks"; // Initialize the connection string builder for the // underlying provider. SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(); // Set the properties f...
asp.net-mvc ef-code-first entity-framework sql-server
asked by Ghyath Serhal

Entity Framework runtime connection string

edmx file based EF require the "Provider" and "Metadata" content. Code-first based EF doesn't require this, requiring only the regular connection string. You could use a ...SqlConnectionBuilder... (instead of ...EntityConnectionStringBuilder...) to build this normal connection string if you'd like. But as you've seen, you need only specify the a...
asp.net-mvc-3 c# entity-framework
asked by robrich

Dynamically Set Connection String in Entity Data Model in C#

Here's a good way approach....public static class ConnectionManager { public static string GetSqlConnectionString() { var serverName = @"" + ConfigurationManager.AppSettings["ServerName"]; var databaseName = ConfigurationManager.AppSettings["DatabaseName"]; var username = ConfigurationManager...
c# entity-framework
asked by spajce

Entity Framework: Setting correct connection string to SQL Server Compact in ASP.NET MVC 4

|DataDirectory|\App_Data... yields ...App_Data\App_Data..., if I am not incorrect. Try Data Source=|DataDirectory|\MyDatabaseSQLCe.sdf. ...You can test this by dumping ...AppDomain.CurrentDomain.GetData("DataDirectory").ToString()... on your webpage....You should grab the toolkit for visual studio when dealing with Sql Server Compact....http://visu...
asp.net-mvc-4 embedded-database entity-framework sql-server-ce
asked by user1228

SQLite EF6 programmatically set connection string at runtime

I was having the same problem. I found a workaround by using a different constructor from the base DbContext class:...public DbContext(DbConnection existingConnection, bool contextOwnsConnection); ...Using this override you can pass an SQLiteConnection instead which you set the connection string on. So for example you can add a new constructor to y...
.net connection-string entity-framework-6 runtime sqlite
asked by kjbartel

Entity Framework : Change connection string at runtime

In my experience, I used the ...Database First... mode in EF 6. The ...DbContext... would be generated like below when I add ...Entity Data Model.......public TestEntities() : base("name=TestEntities") { } ...The ...TestEntities... represent the ...ConnectionString... element in the App.Config...<connectionStrings> <a...
asp.net-mvc c# dependency-injection entity-framework structuremap
asked by Joe.wang

Entity Framework 6 set connection string runtime

You are getting the Code First mode exception because you are passing a ...DbConnection... built with the ADO.NET connection string. This connection string does not include references to metadata files, so EntityFramework does not know where to find them....To create a ...DbContext... with an appropriate programmatically set connection string, use ...
.net entity-framework entity-framework-6
asked by Nick Patsaris

Entity Framework 6 set connection string in code

How about:...public partial class MyDatabaseEntities : DbContext { public MyDatabaseEntities(string connectionString) : base(connectionString) { } protected override void OnModelCreating(DbModelBuilder modelBuilder) { throw new UnintentionalCodeFirstException(); } public virtual DbSet<MyTable> MyTable { get; set; } ...}...Then initialize ...
.net c# dll entity-framework
asked by Alexander Derck

Entity Framework webapi c# connection string change

Add web.config file transforms. ...When you deploy a Web site/Web API, you often want some settings in the deployed application's Web.config file to be different from the development Web.config file. For example, you might want to change connection strings so that they point to different databases....If you want to create a transform file for a cus...
.net asp.net-web-api c# entity-framework-6
asked by bleepzter

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