如何：生成 EntityConnection 连接字符串（实体框架）

            dysoft.Data.CAccessDataClass ooo = new dysoft.Data.CAccessDataClass();
            string providerName = "System.Data.SqlClient";//Provider=SQLOLEDB;Data Source=172.17.60.4\sql2008;Persist Security Info=True;User ID=enspm;Initial Catalog=HW_MangerData
            // Build the SqlConnection connection string.
            string providerString = ooo.sqlConn.ConnectionString;

            // Initialize the EntityConnectionStringBuilder.
            System.Data.EntityClient.EntityConnectionStringBuilder entityBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();

            //Set the provider name.
            entityBuilder.Provider = providerName;

            // Set the provider-specific connection string.
            entityBuilder.ProviderConnectionString = providerString;

            // Set the Metadata location.
            entityBuilder.Metadata = @"res://*/CustomerPlatform.csdl|res://*/CustomerPlatform.ssdl|res://*/CustomerPlatform.msl";
            Console.WriteLine(entityBuilder.ToString());
            HW_MangerDataEntities data = new HW_MangerDataEntities(new System.Data.EntityClient.EntityConnection(entityBuilder.ToString()));

// Specify the provider name, server and database.
string providerName = "System.Data.SqlClient";
string serverName = ".";
string databaseName = "AdventureWorks";

// Initialize the connection string builder for the
// underlying provider.
SqlConnectionStringBuilder sqlBuilder =
    new SqlConnectionStringBuilder();

// Set the properties for the data source.
sqlBuilder.DataSource = serverName;
sqlBuilder.InitialCatalog = databaseName;
sqlBuilder.IntegratedSecurity = true;

// Build the SqlConnection connection string.
string providerString = sqlBuilder.ToString();

// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder entityBuilder =
    new EntityConnectionStringBuilder();

//Set the provider name.
entityBuilder.Provider = providerName;

// Set the provider-specific connection string.
entityBuilder.ProviderConnectionString = providerString;

// Set the Metadata location.
entityBuilder.Metadata = @"res://*/AdventureWorksModel.csdl|
                            res://*/AdventureWorksModel.ssdl|
                            res://*/AdventureWorksModel.msl";
Console.WriteLine(entityBuilder.ToString());

using (EntityConnection conn =
    new EntityConnection(entityBuilder.ToString()))
{
    conn.Open();
    Console.WriteLine("Just testing the connection.");
    conn.Close();
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Iori
{
    public class IoriBaseDataAccess
    {
        public static System.Data.IDbConnection getConnectionBy(System.Data.Objects.ObjectContext ctx)
        {
            return (ctx.Connection as System.Data.EntityClient.EntityConnection).StoreConnection;
        }

        public static string getQuerySQL(IQueryable query)
        {
            System.Data.Objects.ObjectQuery objQuery = query as System.Data.Objects.ObjectQuery;
            if(objQuery != null)
            {
                return objQuery.ToTraceString();
            }
            else
            {
                return null;
            }
        }

        public static System.Data.EntityClient.EntityConnection getEntityConnByIDBConnection(System.Data.IDbConnection conn, string metaDataName)
        {
            string providerName = "System.Data.SqlClient";//Provider=SQLOLEDB;Data Source=172.17.60.4\sql2008;Persist Security Info=True;User ID=enspm;Initial Catalog=HW_MangerData
            string providerString = conn.ConnectionString;
            System.Data.EntityClient.EntityConnectionStringBuilder entityBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();
            entityBuilder.Provider = providerName;
            entityBuilder.ProviderConnectionString = providerString;
            entityBuilder.Metadata = string.Format(@"res://*/{0}.csdl|res://*/{0}.ssdl|res://*/{0}.msl", metaDataName);
            return new System.Data.EntityClient.EntityConnection(entityBuilder.ToString());
        }
    }
}