Entity framework Deployment : Keyword not supported: 'provider connection string'

on
Error: Entity framework Keyword not supported: 'provider connection string'.

http://msdn.microsoft.com/en-us/library/cc716709%28v=vs.90%29.aspx

To copy model and mapping files to the output directory

  1. Double-click the .edmx file in Solution Explorer.
    The file opens in the Entity Designer.
  2. Right-click an empty section of the design surface and select Properties.
    The Visual Studio Properties window appears.
  3. Set the value of the Metadata Artifact Processing property to Copy to Output Directory.



    And the other issue could be the Connection Strings: 
    There are two of them. 
    ADO connection string:
    <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
    Entity Frame Work Connection Context. (This contains of the above) 
    (***************deploy connection string looks like this.)
    <!--<add name="MyEntitiesContext" connectionString="metadata=~/bin/Models\MyEntities.csdl|~/bin/Models\MyEntities.ssdl|~/bin/Models\MyEntities.msl;provider=System.Data.SqlClient;
               provider connection string=&quot;Data Source=MyEntities-server;Initial Catalog=MyEntitiesDB;User Id=MyEntitiesUN;Password=MyEntitiesPWD;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

    Check the connection Strings. 
    Also there are some issues replacing  - &quot with " ' " (single quot in the connection string)


     

Comments

Post a Comment