DBcontext, dynamically specify connection string

Question

I'm dealing with a C# application using EntityFramework and an object derived from DbContext. I need to set programmatically the connection string when a new instance of MyDbContext object is created. In order to do so I use the following code:

public MyDbContext(string myString)
{
    this.Database.Connection.ConnectionString = myString
}

myString =  "Server=MYSERVER\\SQLEXPRESS; Database=MyDB; User ID=user; Password=pass;";
or
myString =  "Data Source=|DataDirectory|\\AirecCalcDatabase.sdf";

The database providers are different for the two strings. SQLExpress for the first one, SQLCompact for the second one. If I try to run this code with the first string, I get ArgumentException coming from the connection string. For example "Keyword not valid: server" but also "Keyword not valid: database". The connection string works when using the DbContext with no arguments, which is, reading the string from app.config

Mark Oreta · Accepted Answer · 2012-09-24 16:07:13Z

2

When you're wanting to use CE, you may need to change the DefaultConnectionFactory to point to SQL CE:

Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0");

See this blog post for more information

answered Sep 24, 2012 at 16:07

Mark Oreta

10.4k1 gold badge35 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Francesco Over a year ago

To what should I set the Database.DefaultConnectionFactory if I want to use an SQLexpress server?

Mark Oreta Over a year ago

You can use new SqlConnectionFactory, with a connection string. See this post on msdn for more info.

Collectives™ on Stack Overflow

DBcontext, dynamically specify connection string

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related