EntitiesConnection.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data.Entity.Core.EntityClient;
using System.Data.Entity;
using MyCaffe.basecode;
using System.Data.Entity.SqlServer;
using System.Data.Entity.Infrastructure;
 
namespace MyCaffe.db.image
{
    public partial class DNNEntities
    {
        public DNNEntities(string strConnectionString)
            : base(strConnectionString)
        {
        }
    }
 
    public class DNNConfiguration : DbConfiguration
    {
        public DNNConfiguration()
        {
            SetExecutionStrategy("System.Data.SqlClient", () => new SqlAzureExecutionStrategy());
            SetDefaultConnectionFactory(new LocalDbConnectionFactory("mssqllocaldb"));
        }
    }
 
    public class EntitiesConnection
    {
        static protected ConnectInfo g_connectInfo = new ConnectInfo(".", "DNN");
        static Dictionary<int, string> m_rgstrConnections = new Dictionary<int, string>();
        static Dictionary<int, ConnectInfo> m_rgciConnections = new Dictionary<int, ConnectInfo>();
 
        public EntitiesConnection()
        {
        }
 
        public static ConnectInfo GlobalDatabaseConnectInfo
        {
            get { return g_connectInfo; }
            set { g_connectInfo = value; }
        }
 
        public static string CreateConnectionString(string strDb)
        {
            return CreateConnectionString(new ConnectInfo(null, strDb));
        }
 
        public static string CreateConnectionString(ConnectInfo ci)
        {
            if (ci == null)
                ci = g_connectInfo;
 
            string strDb = ci.Database;
            string strServerName = g_connectInfo.Server;
 
            if (ci.Server != null)
                strServerName = ci.Server;
 
            if (strServerName == "NONE" || strServerName == "DEFAULT")
                strServerName = ".";
 
            string strKey = strDb + strServerName;
            int nKey = strKey.GetHashCode();
 
            if (m_rgstrConnections.ContainsKey(nKey) && m_rgciConnections.ContainsKey(nKey) && m_rgciConnections[nKey].Compare(ci))
                return m_rgstrConnections[nKey];
 
            string strProviderName = "System.Data.SqlClient";
            string strDatabaseName = strDb;
            SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
            EntityConnectionStringBuilder builder = new EntityConnectionStringBuilder();
 
            sqlBuilder.DataSource = strServerName;
            sqlBuilder.InitialCatalog = strDatabaseName;
 
            if (string.IsNullOrEmpty(ci.Password))
            {
                sqlBuilder.IntegratedSecurity = true;
            }
            else
            {
                sqlBuilder.PersistSecurityInfo = false;
                sqlBuilder.UserID = ci.Username;
                sqlBuilder.Password = ci.Password;
                sqlBuilder.MultipleActiveResultSets = false;
                sqlBuilder.Encrypt = true;
                sqlBuilder.TrustServerCertificate = true;
                sqlBuilder.ConnectTimeout = 180;
            }
 
            string strProviderString = sqlBuilder.ToString();
 
            builder.Provider = strProviderName;
            builder.ProviderConnectionString = strProviderString;
            builder.Metadata = @"res://*/" + strDb + "Model.csdl|" + 
                                "res://*/" + strDb + "Model.ssdl|" +
                                "res://*/" + strDb + "Model.msl";
 
            string strConnection = builder.ToString();
 
            if (!m_rgstrConnections.ContainsKey(nKey))
                m_rgstrConnections.Add(nKey, strConnection);
            else
                m_rgstrConnections[nKey] = strConnection;
 
            if (!m_rgciConnections.ContainsKey(nKey))
                m_rgciConnections.Add(nKey, ci);
            else
                m_rgciConnections[nKey] = ci;
 
            return strConnection;
        }
 
        public static DNNEntities CreateEntities(ConnectInfo ci = null)
        {
            return new DNNEntities(CreateConnectionString(ci));
        }
    }
}