Connection String Error

Question

User-1177023326 posted

Hello

Am using Entity Framework for application. the problem is that I am using Entity Framework to perform action with my database , which is working fine. but for some other reason i  need to perform other purpose using Sql Connection to Store and Retrieve  data from database. but getting error keyword not supported 'metadata'

My connection string is

  <add name="AutoDBEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=LAPTOPxxxxxx;initial catalog=AutoDB;user id=sa;password=xccccc;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Please i will appreciate if this could be solved out.
Thank you

Answer 1

User-691209617 posted

add your connection string like this

  <connectionStrings>
    <add name="myconnectionstring"  connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=LAPTOPxxxxxx;initial catalog=AutoDB;user id=sa;password=xccccc;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

and in Context use it like this

        public YourEntityName()
            : base("name=myconnectionstring")
        {
        }
    

Answer 2

User-1177023326 posted

 public YourEntityName()
            : base("name=myconnectionstring")
        {
        }

Please can you give better explanation and sample on this.

Answer 3

User753101303 posted

Hi,

My understanding is that you are trying to use an EF connexion string with SqlClient. If yes, for SQL Client only the part that starts at "Data Source=" is relevant. What is shown before is for EF connection strings (which is basically EF info + a SQL Server connection string added as a "provider connection string")

Another option is to use the Database property that exposes the underlying connection so that you can fall back to plain SQL even when using primilarly an EF context.

Answer 4

User-1177023326 posted

Thank You Patric  

Can you help to check this if its a perfect method to use

private static string RemoveEntityFrameworkMetadata(string efConnection)
      {
         
 
 
          string entityConnectionString = efConnection; //System.Configuration.ConfigurationManager.ConnectionStrings["EFcONNECTIONSTRING"].ConnectionString;
 
          var builder = new EntityConnectionStringBuilder(entityConnectionString);
          string providerConnectionString = builder.ProviderConnectionString;
          return providerConnectionString;

}