动态生成 EntityConnection

/// <summary>  
/// 取得 EntityConnection  
/// </summary>  
/// <param name="connectionString">连接字符串</param>  
/// <returns>EntityConnection</returns>  
public static EntityConnection GetEntityConnection(string connectionString)
{
    var ecsb = new EntityConnectionStringBuilder
                   {
                       Metadata =string.Format(@"res://*/{0}.csdl|res://*/{0}.ssdl|res://*/{0}.msl", "Models.Model"),
                       Provider = "System.Data.SqlClient",
                       ProviderConnectionString = connectionString
                   };
    var ec = new EntityConnection(ecsb.ToString());

    return ec;
} 

 

另外一种从已經存在的SqlConnection 动态生成

1. 已經存在的SqlConnection
2. SqlConnection sc;  
4. 建立WorkSpace
5. MetadataWorkspace workspace = new MetadataWorkspace();  
6. EdmItemCollection edmCollection = new EdmItemCollection("res://*/TestModel.csdl");  
7. workspace.RegisterItemCollection(edmCollection);  
8. StoreItemCollection storeCollection = new StoreItemCollection("res://*/TestModel.ssdl");  
9. workspace.RegisterItemCollection(storeCollection);  
10. StorageMappingItemCollection storageMappingItemCollection = new StorageMappingItemCollection(edmCollection, storeCollection, "res://*/TestModel.msl");  
11. workspace.RegisterItemCollection(storageMappingItemCollection);  
13. 利用剛剛建立的WorkSpace搭配SqlConnection來建立EntityConnection物件
14. using (TestEntities te = new TestEntities(new EntityConnection(workspace, sc)))  
15. {  
16.     var users = te.user.Execute(System.Data.Objects.MergeOption.NoTracking).Select(a => a).ToList();  
17. }