MARKUS



namespace Markus.Service.DataBase

{

    using System;

    using System.Data.Entity;

    using System.Data.Entity.Core.EntityClient;

    using System.Data.Entity.Infrastructure;

    using System.Data.SqlClient;

    public partial class MarkusEntities : DbContext

    {

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

        private const string MarkusMeta = @"res://*/markusModel.csdl|res://*/markusModel.ssdl|res://*/markusModel.msl";

        public MarkusEntities(string ConnectionString)

            : base(ConnectionStringBuilder(ConnectionString).ToString())

        {

        }

        private static EntityConnectionStringBuilder ConnectionStringBuilder(string ConnectionString)

        {

            //SqlConnectionStringBuilder _bl = new SqlConnectionStringBuilder(string.Format(Properties.Settings.Default.ProjectCIConnectionString, "DeepView"));

            SqlConnectionStringBuilder _bl = new SqlConnectionStringBuilder(ConnectionString);

            return EntityConnectionBuilder(_bl, MarkusMeta);

        }

        private static EntityConnectionStringBuilder

          EntityConnectionBuilder(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()))

            {

                try

                {

                    conn.Open();

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

                    conn.Close();

                }

                catch (Exception ex)

                {

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

                    throw ex;

                }

            }

            return entityBuilder;

        }

    }

}