Entity Framework Code First and Connection String Issue

Question

I am getting this error when using Entity Framework 4.1 code first. I can not find any sources of what exactly to use.

Unable to load the specified metadata resource.

<add name="DataContext" connectionString="metadata=res://*/GrassrootsHoopsDataContext.csdl|res://*/GrassrootsHoopsDataContext.ssdl|res://*/GrassrootsHoopsDataContext.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=myserver.com;Initial Catalog=MyDataBase;Persist Security Info=True;User ID=username;Password=password&quot;" providerName="System.Data.EntityClient" />

Btw I think this type of connectionstrings with "metadata.." is only for model first and database first — Prokurors
– Prokurors, Commented Apr 9, 2014 at 13:24

Eranga · Accepted Answer · 2011-08-21 00:44:09Z

69

For EF Code First you can use ordinary connection string if you are using SQL Server.

<add name="DataContext" connectionString="Data Source=myserver.com;Initial Catalog=MyDataBase;Persist Security Info=True;User ID=username;Password=password"  providerName="System.Data.SqlClient" />

answered Aug 21, 2011 at 0:44

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

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

2 Comments

cdonner Over a year ago

Thanks, finally a correct answer. I only wasted the better part of the day trying the find or generate the metadata files ...

L_7337 Over a year ago

Thank you. I had the same issue, but I also had to correct the ConnectionString I was dynamically building and passing into the DbContext via the controller's constructor.

Dilip Langhanoja · Accepted Answer · 2015-07-20 08:31:55Z

1

If you are creating dynamic connection string for Code First Entity Framework than you can do using only Sql Connection String Builder as given below.

 public static string  DynamicConnectionString(SqlConnectionStringBuilder builder)
 {
    SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
    builder.DataSource = "ServerName";
    builder.InitialCatalog = "DatabaseName";
    builder.UserID = "UserId";
    builder.Password = "Password";
    builder.MultipleActiveResultSets = true;
    builder.PersistSecurityInfo = true;    
    return builder.ConnectionString.ToString();
}

answered Jul 20, 2015 at 8:31

Dilip Langhanoja

4,5354 gold badges30 silver badges37 bronze badges

Collectives™ on Stack Overflow

Entity Framework Code First and Connection String Issue

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related