数据库很多,webconfig里这样写不行吗?具体连哪个,指定DbConnection的ConnectionString属性不就行了?<configuration>
  <connectionStrings>
    <add name="ApplicationServices"
 connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
 providerName="System.Data.SqlClient" />
    <add name="DB1"
       connectionString="Data Source=xxx\xxxx;Initial Catalog=xxx;Integrated Security=False;User ID=xxx;Password=xxx;MultipleActiveResultSets=True"
       providerName="System.Data.SqlClient" />
    <add name="DB2"
       connectionString="Data Source=xxx;Initial Catalog=xxx;Integrated Security=False;User ID=xxx;Password=xxx;MultipleActiveResultSets=True"
       providerName="System.Data.SqlClient" />
</connectionStrings>

解决方案 »

  1.   

    实在不行多建几个edmx文件,每一个对应不同的数据库连接。打开edmx文件,在空白处右击,选择属性就可以看到每个edmx文件对应的数据库连接了。
      

  2.   


    <configuration>
      <connectionStrings>
        <add name="HonorEntities" connectionString="metadata=res://*/HonorData.csdl|res://*/HonorData.ssdl|res://*/HonorData.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.;Initial Catalog=Honor;Persist Security Info=True;User ID=sa;Password=sa;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
      </connectionStrings>
    </configuration>