<connectionStrings>
<add name="pubs2Entities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="Data Source=(local);Initial Catalog=pubs2;User ID=sa;pwd=123456;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />
</connectionStrings>上面的provider connection string="是什么意思?
还有,要是几种不同的类型数据库(mysql、oracle)生成.edmx的文件(数据库名、表名,存储过程名都一样),生成的.edmx文件是否都一样??
EntityConnectionStringBuilder 创建连接
EntityConnectionStringBuilder esb = new EntityConnectionStringBuilder();
esb.Provider = "System.Data.SqlClient";
esb.Metadata = @"res://*/CSharpTestEF.csdl|res://*/CSharpTestEF.ssdl|res://*/CSharpTestEF.msl";
esb.ProviderConnectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=CSharpTest;Integrated Security=True;MultipleActiveResultSets=True";
EntityConnection econn = new EntityConnection(esb.ConnectionString);
type是不一样的