MARKUS

using System;

using System.Collections.Generic;

using System.Data.EntityClient;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

namespace KCOMDataModel.Common

{

    public class ConnectStringBuilder

    {

        private const string InitialCatalogString = "InitialCatalog";

        private const string providerName = "System.Data.SqlClient";

        //private const string providerName = "MS.Data.MySqlClient"; //MYSQL 일때 사용

        private const string DeepViewMeta = @"res://*/DataModel.KCOM_Model.csdl|res://*/DataModel.KCOM_Model.ssdl|res://*/DataModel.KCOM_Model.msl";

        private const string CIMeta = @"res://*/DataModel.CIModel.csdl|res://*/DataModel.CIModel.ssdl|res://*/DataModel.CIModel.msl";

        public static EntityConnectionStringBuilder KCOMConnectionString()

        {

            SqlConnectionStringBuilder _bl = new SqlConnectionStringBuilder(string.Format(CommonLib.Common.GetConnectionString(), "markus"));

            return EntityConnectionStringBuilder(_bl, DeepViewMeta);

        }

        public static EntityConnectionStringBuilder ProjectCIConnectString(string ProjectNo)

        {

            return CIConnectionStringBuilder(CommonLib.Common.GetConnectionString(), ProjectNo, CIMeta);

        }

        private static EntityConnectionStringBuilder CIConnectionStringBuilder(string adoConnectionString, string ProjectNo, string Metadata)

        {

            try

            {

                SqlConnectionStringBuilder bl = new SqlConnectionStringBuilder(string.Format(CommonLib.Common.GetConnectionString(), "markus"));

                using (DataModel.KCOMEntities entity

                    = new DataModel.KCOMEntities(EntityConnectionStringBuilder(bl, DeepViewMeta).ToString()))

                {

                    var _catalog = entity.PROPERTIES.Where(property => property.TYPE == InitialCatalogString

                                                                        /*&& property.PROPERTY == ProjectNo*/);

                    EntityConnectionStringBuilder builder = null;

                    if (_catalog.Count() > 0)

                    {

                        string _ConnectionString = string.Format(adoConnectionString, _catalog.First().VALUE);

                        SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(_ConnectionString);

                        builder = ConnectStringBuilder.EntityConnectionStringBuilder(sqlBuilder, Metadata);

                    }

                    return builder;

                }

            }

            catch (Exception ex)

            {

                System.Diagnostics.Debug.WriteLine(ex.ToString());

            }

            return null;

        }

        private static EntityConnectionStringBuilder EntityConnectionStringBuilder(SqlConnectionStringBuilder SqlStringBuilder, string EntityMetaData)

        {

            string providerString = SqlStringBuilder.ToString();

            EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();

            entityBuilder.Provider = providerName;

            entityBuilder.ProviderConnectionString = providerString;

            entityBuilder.Metadata = EntityMetaData;

            //Console.WriteLine(entityBuilder.ToString());

            //using (EntityConnection conn =

            //    new EntityConnection(entityBuilder.ToString()))

            //{

            //    conn.Open();

            //    Console.WriteLine("Just testing the connection.");

            //    conn.Close();

            //}

            return entityBuilder;

        }

    }

}