Example #1
0
        public static string GetProviderConnectionString(string connectionString, out bool isEntity)
        {
            isEntity = false;
#if NETSTANDARD  // .NET Standard
#elif NETCOREAPP // .NET Core
            // EF Core does not support EF specific connection strings (metadata=res:... < this kind of connection strings).
#else // .NET Framework
            if (string.Compare(connectionString, "metadata=", true) == 0)
            {
                // Get connection string from entity connection string.
                var ecsb = new System.Data.EntityClient.EntityConnectionStringBuilder(connectionString);
                connectionString = ecsb.ProviderConnectionString;
                isEntity         = true;
            }
#endif
            var builder = new SqlConnectionStringBuilder(connectionString);
            if (!builder.ContainsKey("Application Name") || ".Net SqlClient Data Provider".Equals(builder["Application Name"]))
            {
                var asm = Assembly.GetEntryAssembly();
                if (asm == null)
                {
                    asm = Assembly.GetExecutingAssembly();
                }
                var appPrefix = asm.GetName().Name.Replace(".", "");
                var appName   = string.Format("{0}", appPrefix);
                builder.Add("Application Name", appName);
                connectionString = builder.ToString();
            }
            return(connectionString);
        }
Example #2
0
        public static string GetConnectionString()
        {
            // Initialize the connection string builder for the underlying provider.
            SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder
            {
                DataSource             = "",
                InitialCatalog         = "V10_QTouristik.Search",
                Encrypt                = true,
                TrustServerCertificate = true,
                UserID   = "",
                Password = ""
            };

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

            // Set the provider-specific connection string.
            entityBuilder.ProviderConnectionString = sqlBuilder.ToString();

            // Set the Metadata location.
            entityBuilder.Metadata = @"res://*/LM.OVH_V3_SearchModel.csdl|res://*/LM.OVH_V3_SearchModel.ssdl|res://*/LM.OVH_V3_SearchModel.msl";

            return(entityBuilder.ConnectionString);
        }
Example #3
0
        public static string GetProviderConnectionString(string connectionString, out bool isEntity)
        {
            isEntity = false;
            if (string.Compare(connectionString, "metadata=", true) == 0)
            {
                // Get connection string from entity connection string.
                var ecsb = new System.Data.EntityClient.EntityConnectionStringBuilder(connectionString);
                connectionString = ecsb.ProviderConnectionString;
                isEntity         = true;
            }
            var builder = new SqlConnectionStringBuilder(connectionString);

            if (!builder.ContainsKey("Application Name") || ".Net SqlClient Data Provider".Equals(builder["Application Name"]))
            {
                var asm = Assembly.GetEntryAssembly();
                if (asm == null)
                {
                    asm = Assembly.GetExecutingAssembly();
                }
                var appPrefix = asm.GetName().Name.Replace(".", "");
                var appName   = string.Format("{0}", appPrefix);
                builder.Add("Application Name", appName);
                connectionString = builder.ToString();
            }
            return(connectionString);
        }
Example #4
0
        /// <summary>
        /// Builds a Connection String that's usable by EntityFramework.
        /// SetConnectionString must be called before (if not, DefaultConnectionStringName is used).
        /// ConnectionString must be a simple SQL Connection string (not a Entity Framework one).
        /// </summary>
        /// <returns>ConnectionString for the EntityFramework</returns>
        internal static string GetConnectionString()
        {
            if (!string.IsNullOrEmpty(_connectionStringName))
            {
                //string ConnectionStringName = HttpContext.Current.Application[AppSettingPrefix + "." + ConnectionStringSetting].ToString();
                var connectionStringName = _connectionStringName;

                var builder = new System.Data.EntityClient.EntityConnectionStringBuilder();
                try
                {
                    builder.ProviderConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString;
                }
                catch (NullReferenceException)
                {
                    throw new Exception("Couldn't load Connection String with name \"" + connectionStringName + "\"");
                }
                if (!builder.ProviderConnectionString.Contains("MultipleActiveResultSets"))
                    builder.ProviderConnectionString += ";MultipleActiveResultSets=True";

                builder.Metadata = "res://*/Persistence.EavContext.csdl|res://*/Persistence.EavContext.ssdl|res://*/Persistence.EavContext.msl";
                builder.Provider = "System.Data.SqlClient";

                return builder.ToString();
            }
            try
            {
                return System.Configuration.ConfigurationManager.ConnectionStrings[DefaultConnectionStringName].ConnectionString;
            }
            catch (NullReferenceException)
            {
                throw new Exception("Couldn't load Connection String with name \"" + DefaultConnectionStringName + "\"");
            }
        }
        static public void AutoRefresh(this ObjectContext ctx,
                                       RefreshMode refreshMode, IEnumerable collection)
        {
            var    csInEF = ctx.Connection.ConnectionString;
            string csForEF;

            if (csInEF.StartsWith("name="))
            {   // old EF
                var csName = csInEF.Replace("name=", "").Trim();
                csForEF =
                    System.Configuration.ConfigurationManager.ConnectionStrings[csName].ConnectionString;
            }
            else
            {
                csForEF = csInEF;
            }
            var newConnectionString = new
                                      System.Data.EntityClient.EntityConnectionStringBuilder(csForEF).ProviderConnectionString;

            if (!connectionStrings.Contains(newConnectionString))
            {
                connectionStrings.Add(newConnectionString);
                SqlDependency.Start(newConnectionString);
            }
            ServiceBrokerUtility.ctx         = ctx;
            ServiceBrokerUtility.refreshMode = refreshMode;
            AutoRefresh(collection);
        }
Example #6
0
        public string GetConnectionString(string name)
        {
            // Try to find entity connection.
            var cs = ConfigurationManager.ConnectionStrings[name];

            // If configuration section with not found then return.
            if (cs == null)
            {
                return(null);
            }
            var connectionString = cs.ConnectionString;

            if (string.Compare(cs.ProviderName, "System.Data.EntityClient", true) == 0)
            {
                // Get connection string from entity connection string.
                var ecsb = new System.Data.EntityClient.EntityConnectionStringBuilder(cs.ConnectionString);
                connectionString = ecsb.ProviderConnectionString;
            }
            var builder = new SqlConnectionStringBuilder(connectionString);

            if (!builder.ContainsKey("Application Name") || ".Net SqlClient Data Provider".Equals(builder["Application Name"]))
            {
                var asm = Assembly.GetEntryAssembly();
                if (asm == null)
                {
                    asm = Assembly.GetExecutingAssembly();
                }
                var appPrefix = asm.GetName().Name.Replace(".", "");
                var appName   = string.Format("{0}", appPrefix);
                builder.Add("Application Name", appName);
                connectionString = builder.ToString();
            }
            return(connectionString);
        }
Example #7
0
        public static string GetProviderConnectionString()
        {
            var    entityConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ccEntities"].ConnectionString;
            var    builder = new System.Data.EntityClient.EntityConnectionStringBuilder(entityConnectionString);
            string providerConnectionString = builder.ProviderConnectionString;

            return(providerConnectionString);
        }
Example #8
0
        /// <summary>
        /// </summary>
        public static ItemEntities Instance()
        {
            var entityBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();

            entityBuilder.ProviderConnectionString = DotNetNuke.Common.Utilities.Config.GetConnectionString();
            entityBuilder.Metadata = "res://*/";
            entityBuilder.Provider = "System.Data.SqlClient";
            return(new ItemEntities(entityBuilder.ToString()));
        }
Example #9
0
 public void LoadContext()
 {
     System.Data.EntityClient.EntityConnectionStringBuilder connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder()
     {
         Metadata = "res://*/DataModel1.csdl|res://*/DataModel1.ssdl|res://*/DataModel1.msl",
         Provider = "System.Data.SqlClient",
         ProviderConnectionString = sageSession1.GetConnectionString()
     };
     conection = connectionString.ToString();
     mycontext = new Sage500AppEntities(connectionString.ToString());
 }
Example #10
0
 /// <summary>Builds a connection string for an EntityConnection.</summary>
 /// <param name='modelDirectory'>Directory where all model files are.</param>
 /// <param name='baseModelName'>Base name for all files (baseModelName.csdl, baseModelName.msl and baseModelName.ssdl)</param>
 /// <param name='connectionString'>Connection string for a provider (specified for ProviderName).</param>
 /// <returns>The connection string to be used with <see cref="System.Data.EntityClient.EntityConnection"/>.</returns>
 public static string BuildEntityConnection(string modelDirectory, string baseModelName, string connectionString)
 {
     System.Data.EntityClient.EntityConnectionStringBuilder builder = new System.Data.EntityClient.EntityConnectionStringBuilder();
     builder.Metadata =
         Path.Combine(modelDirectory, baseModelName + ".csdl") + "|" +
         Path.Combine(modelDirectory, baseModelName + ".msl") + "|" +
         Path.Combine(modelDirectory, baseModelName + ".ssdl");
     builder.Provider = ProviderName;
     builder.ProviderConnectionString = connectionString;
     return(builder.ConnectionString);
 }
 /// <summary>Builds a connection string for an EntityConnection.</summary>
 /// <param name='modelDirectory'>Directory where all model files are.</param>
 /// <param name='baseModelName'>Base name for all files (baseModelName.csdl, baseModelName.msl and baseModelName.ssdl)</param>
 /// <param name='connectionString'>Connection string for a provider (specified for ProviderName).</param>
 /// <returns>The connection string to be used with <see cref="System.Data.EntityClient.EntityConnection"/>.</returns>
 public static string BuildEntityConnection(string modelDirectory, string baseModelName, string connectionString)
 {
     System.Data.EntityClient.EntityConnectionStringBuilder builder = new System.Data.EntityClient.EntityConnectionStringBuilder();
     builder.Metadata =
         Path.Combine(modelDirectory, baseModelName + ".csdl") + "|" +
         Path.Combine(modelDirectory, baseModelName + ".msl") + "|" +
         Path.Combine(modelDirectory, baseModelName + ".ssdl");
     builder.Provider = ProviderName;
     builder.ProviderConnectionString = connectionString;
     return builder.ConnectionString;
 }
Example #12
0
        public static string generateEntityConnectionString(string modelName, LCADatabaseSettings dbSettings, LCADBTypes dbType)
        {
            System.Data.EntityClient.EntityConnectionStringBuilder cStr = new System.Data.EntityClient.EntityConnectionStringBuilder();
            string pcs = "";

            if (dbSettings.dbServer.ToUpper() == "LOCAL")
            {
                // Replace the word local with the actual ip address of this machine
                if (!System.Net.NetworkInformation.NetworkInterface.GetIsNetworkAvailable())
                {
                    return("");
                }
                IPHostEntry host = Dns.GetHostEntry(Dns.GetHostName());
                dbSettings.dbServer = host.AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork).ToString();
            }

            // Build up an entity connection string for the database settings provided
            // Metadata taken from generated App.Config code
            cStr.Metadata = "res://*/" + modelName + ".csdl|res://*/" + modelName + ".ssdl|res://*/" + modelName + ".msl";
            cStr.Provider = "System.Data.SqlClient";
            // Actual sql server connection string with options provided on the config screen
            pcs = "data source=" + dbSettings.dbServer + ";initial catalog=";
            switch (dbType)
            {
            case LCADBTypes.DB_Config:
                pcs += dbSettings.dbConfigDatabase;
                break;

            case LCADBTypes.DB_Data:
                pcs += dbSettings.dbDataDatabase;
                break;

            case LCADBTypes.DB_Ctrl:
                pcs += dbSettings.dbCtrlDatabase;
                break;

            case LCADBTypes.DB_Price:
                pcs += dbSettings.dbPriceDatabase;
                break;
            }

            if (dbSettings.dbNeedUser == true)
            {
                pcs += ";integrated security=false;User ID=" + dbSettings.dbUser + ";password="******";";
            }
            else
            {
                pcs += ";integrated security=True;";
            }
            pcs += "Connection Timeout=20;multipleactiveresultsets=True;App=EntityFramework;";
            cStr.ProviderConnectionString = pcs;

            return(cStr.ConnectionString);
        }
 void CreateObjectContextIfNull()
 {
     if (objectContext != null)
     {
         return;
     }
     System.Data.EntityClient.EntityConnectionStringBuilder builder = new System.Data.EntityClient.EntityConnectionStringBuilder();
     builder.ProviderConnectionString = ServerModeOptions.SQLConnectionString;
     builder.Metadata = @"res://*/Controls.EFServerModeModel.csdl|res://*/Controls.EFServerModeModel.ssdl|res://*/Controls.EFServerModeModel.msl";
     builder.Provider = "System.Data.SqlClient";
     DataContext      = objectContext = new DXGridServerModeDBEntities(builder.ToString());
 }
Example #14
0
    private static string GetEntityConnectionString(string password)
    {
        string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["fichario"].ConnectionString;

        System.Data.EntityClient.EntityConnectionStringBuilder entityconnection = new System.Data.EntityClient.EntityConnectionStringBuilder(s);
        //EntityConnectionStringBuilder inherits from DBConnectionStringBuilder
        //so you should be able to replace the password simply
        entityconnection["Password"] = password;

        //otherwise, if you know the connection properties you need
        //you could rebuild an entity connection object.
        return(entityconnection.ToString());
    }
Example #15
0
        static Stgs()
        {
            WebRt                = ConfigurationManager.AppSettings["WebRoot"];
            UploadRt             = ConfigurationManager.AppSettings["UploadRoot"];
            StaticRt             = ConfigurationManager.AppSettings["StaticRoot"];
            ImgsRt               = ConfigurationManager.AppSettings["ImagesRoot"];
            SvcRt                = ConfigurationManager.AppSettings["SvcRoot"];
            MapSvcRelativeUrl    = ConfigurationManager.AppSettings["MapSvcRelativeUrl"];
            SearchSvcRelativeUrl = ConfigurationManager.AppSettings["SearchSvcRelativeUrl"];
            AWSAccessKey         = ConfigurationManager.AppSettings["AWSAccessKey"];
            AWSSecretKey         = ConfigurationManager.AppSettings["AWSSecretKey"];

            DefaultMapInfoImage = string.Format("{0}/map/defaultInfo.png", StaticRt);

            MailMan = new MailAddress(
                ConfigurationManager.AppSettings["MailManAddress"],
                ConfigurationManager.AppSettings["MailManName"]);

            MailServer             = new SmtpClient(ConfigurationManager.AppSettings["MailServer"]);
            MailServer.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["MailManAddress"],
                                                                      ConfigurationManager.AppSettings["MailPassword"]);

            var timeZoneString = ConfigurationManager.AppSettings["SiteTimeZone"];

            if (!string.IsNullOrWhiteSpace(timeZoneString))
            {
                SiteTimeZone = TimeZoneInfo.FindSystemTimeZoneById(timeZoneString);
            }

            var efConnection = new System.Data.EntityClient.EntityConnectionStringBuilder(ConfigurationManager.ConnectionStrings["cfEntitiesData"].ConnectionString);

            DbConnectionString = efConnection.ProviderConnectionString;

            var cfUrbanCreds = ConfigurationManager.AppSettings["CFUrbanairshipCredentials"];

            if (cfUrbanCreds != null)
            {
                CFUrbanairshipCredentials = new NetworkCredential(cfUrbanCreds.Split(',')[0], cfUrbanCreds.Split(',')[1]);
                var pgUrbanCreds = ConfigurationManager.AppSettings["PGUrbanairshipCredentials"];
                PGUrbanairshipCredentials = new NetworkCredential(pgUrbanCreds.Split(',')[0], pgUrbanCreds.Split(',')[1]);
            }

            if (IsDevelopmentEnvironment)
            {
                DebugMailDir = AppDomain.CurrentDomain.BaseDirectory
                               .Replace("\\bin\\Debug", "")
                               .Replace("\\bin\\Release", "")
                               + @"\..\mailtemplates\";
            }
        }
Example #16
0
        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            openFileDialog1.ShowDialog();
            var path = openFileDialog1.FileName;

            System.Data.SQLite.SQLiteConnectionStringBuilder       connect        = new SQLiteConnectionStringBuilder("Data Source=" + path);
            System.Data.EntityClient.EntityConnectionStringBuilder entity_connect = new System.Data.EntityClient.EntityConnectionStringBuilder();
            entity_connect.Provider = @"System.Data.SQLite";
            entity_connect.ProviderConnectionString = connect.ConnectionString;
            entity_connect.Metadata = @"res://*/DB_Model.csdl|res://*/DB_Model.ssdl|res://*/DB_Model.msl";

            data_source = new DB_ModelContainer(entity_connect.ConnectionString);

            dataGridView1.DataSource = data_source.Ciphers_Table;
            MessageBox.Show("База удачно подключена");
        }
Example #17
0
        /// <summary>Builds a connection string for an EntityConnection.</summary>
        /// <param name='baseModelName'>Base name for all files (baseModelName.csdl, baseModelName.msl and baseModelName.ssdl)</param>
        /// <param name='connectionString'>Connection string for a provider (specified for ProviderName).</param>
        /// <param name="assembly">Assembly where the model resources are held</param>
        /// <returns>The connection string to be used with <see cref="System.Data.EntityClient.EntityConnection"/>.</returns>
        public static string BuildEntityConnection(string baseModelName, string connectionString, System.Reflection.Assembly assembly)
        {
            string[] extensions = new string[] { ".csdl", ".msl", ".ssdl" };
            string prefix = String.Empty;
            StringBuilder metaBuilder = new StringBuilder();
            foreach (string extension in extensions)
            {
                metaBuilder.Append(prefix).Append("res://*/").Append(IOUtil.FindResourceNameForPath(assembly, baseModelName + extension));
                prefix = "|";
            }

            System.Data.EntityClient.EntityConnectionStringBuilder builder = new System.Data.EntityClient.EntityConnectionStringBuilder();
            builder.Provider = ProviderName;
            builder.ProviderConnectionString = connectionString;
            builder.Metadata = metaBuilder.ToString();
            return builder.ConnectionString;
        }
 public static string getConStrSQL(string UID,string PWD)
 {
     
     string connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
     {
         Metadata = "res://*",
         Provider = "System.Data.SqlClient",
         ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
         {
             InitialCatalog = "your_database_name",
             DataSource = "your_server",
             IntegratedSecurity = false,
             UserID = UID,                
             Password = PWD,              
         }.ConnectionString
     }.ConnectionString;
     return connectionString;
 }
Example #19
0
        /// <summary>Builds a connection string for an EntityConnection.</summary>
        /// <param name='baseModelName'>Base name for all files (baseModelName.csdl, baseModelName.msl and baseModelName.ssdl)</param>
        /// <param name='connectionString'>Connection string for a provider (specified for ProviderName).</param>
        /// <param name="assembly">Assembly where the model resources are held</param>
        /// <returns>The connection string to be used with <see cref="System.Data.EntityClient.EntityConnection"/>.</returns>
        public static string BuildEntityConnection(string baseModelName, string connectionString, System.Reflection.Assembly assembly)
        {
            string[]      extensions  = new string[] { ".csdl", ".msl", ".ssdl" };
            string        prefix      = String.Empty;
            StringBuilder metaBuilder = new StringBuilder();

            foreach (string extension in extensions)
            {
                metaBuilder.Append(prefix).Append("res://*/").Append(IOUtil.FindResourceNameForPath(assembly, baseModelName + extension));
                prefix = "|";
            }

            System.Data.EntityClient.EntityConnectionStringBuilder builder = new System.Data.EntityClient.EntityConnectionStringBuilder();
            builder.Provider = ProviderName;
            builder.ProviderConnectionString = connectionString;
            builder.Metadata = metaBuilder.ToString();
            return(builder.ConnectionString);
        }
Example #20
0
        private string GetConnectionString()
        {
            string connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
            {
                Metadata = "res://*",
                Provider = "System.Data.SqlClient",
                ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                {
                    InitialCatalog     = _database,
                    DataSource         = _dBServer,
                    IntegratedSecurity = false,
                    UserID             = _userId,
                    Password           = _password,
                }.ConnectionString
            }.ConnectionString;

            return(connectionString);
        }
Example #21
0
        static Stgs()
        {
            WebRt = ConfigurationManager.AppSettings["WebRoot"];
            UploadRt = ConfigurationManager.AppSettings["UploadRoot"];
            StaticRt = ConfigurationManager.AppSettings["StaticRoot"];
            ImgsRt = ConfigurationManager.AppSettings["ImagesRoot"];
            SvcRt = ConfigurationManager.AppSettings["SvcRoot"];
            MapSvcRelativeUrl = ConfigurationManager.AppSettings["MapSvcRelativeUrl"];
            SearchSvcRelativeUrl = ConfigurationManager.AppSettings["SearchSvcRelativeUrl"];
            AWSAccessKey = ConfigurationManager.AppSettings["AWSAccessKey"];
            AWSSecretKey = ConfigurationManager.AppSettings["AWSSecretKey"];

            DefaultMapInfoImage = string.Format("{0}/map/defaultInfo.png", StaticRt);

            MailMan = new MailAddress(
                ConfigurationManager.AppSettings["MailManAddress"],
                ConfigurationManager.AppSettings["MailManName"]);

            MailServer = new SmtpClient(ConfigurationManager.AppSettings["MailServer"]);
            MailServer.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["MailManAddress"],
                ConfigurationManager.AppSettings["MailPassword"]);

            var timeZoneString = ConfigurationManager.AppSettings["SiteTimeZone"];
            if (!string.IsNullOrWhiteSpace(timeZoneString)) { SiteTimeZone = TimeZoneInfo.FindSystemTimeZoneById(timeZoneString); }

            var efConnection = new System.Data.EntityClient.EntityConnectionStringBuilder(ConfigurationManager.ConnectionStrings["cfEntitiesData"].ConnectionString);
            DbConnectionString = efConnection.ProviderConnectionString;

            var cfUrbanCreds = ConfigurationManager.AppSettings["CFUrbanairshipCredentials"];
            if (cfUrbanCreds != null)
            {
                CFUrbanairshipCredentials = new NetworkCredential(cfUrbanCreds.Split(',')[0], cfUrbanCreds.Split(',')[1]);
                var pgUrbanCreds = ConfigurationManager.AppSettings["PGUrbanairshipCredentials"];
                PGUrbanairshipCredentials = new NetworkCredential(pgUrbanCreds.Split(',')[0], pgUrbanCreds.Split(',')[1]);
            }

            if (IsDevelopmentEnvironment)
            {
                DebugMailDir = AppDomain.CurrentDomain.BaseDirectory
                            .Replace("\\bin\\Debug", "")
                            .Replace("\\bin\\Release", "")
                            + @"\..\mailtemplates\";
            }
        }
Example #22
0
        public IDatabaseConfiguration BuildConnectionString(GatewayRegistrationCallback registrationCallback)
        {
            string connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder

            {
                Metadata = "res://*",
                Provider = "System.Data.SqlClient",
                ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                {
                    DataSource         = registrationCallback.DatabaseAddress.AbsoluteUri,
                    InitialCatalog     = registrationCallback.InitialCatalog,
                    IntegratedSecurity = false,
                    UserID             = registrationCallback.Username,
                    Password           = registrationCallback.Password
                }.ConnectionString
            }.ConnectionString;

            return(new DatabaseConfiguration(connectionString));
        }
        /// <summary>
        /// 得到Entity的连接字符串
        /// </summary>
        /// <param name="edmxFullName">Edmx的包括命名空间的全名称</param>
        /// <param name="server">服务器地址或名称</param>
        /// <param name="dadaBase">数据库</param>
        /// <param name="usr">用户</param>
        /// <param name="pswd">密码</param>
        /// <param name="appName">程序名称</param>
        /// <returns>Entity连接字符串</returns>
        public static string GetEntityConnectionString(string edmxFullName, string server, string dadaBase, string usr, string pswd, string appName)
        {
            System.Data.EntityClient.EntityConnectionStringBuilder entityConnectionStringBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();
            entityConnectionStringBuilder.Metadata = "res://*/" + edmxFullName + ".csdl|res://*/" + edmxFullName + ".ssdl|res://*/" + edmxFullName + ".msl";
            entityConnectionStringBuilder.Provider = "System.Data.SqlClient";

            SqlConnectionStringBuilder sqlConnectionStringBuilder = new SqlConnectionStringBuilder();

            sqlConnectionStringBuilder.DataSource                  = server;
            sqlConnectionStringBuilder.InitialCatalog              = dadaBase;
            sqlConnectionStringBuilder.IntegratedSecurity          = true;
            sqlConnectionStringBuilder.UserID                      = usr;
            sqlConnectionStringBuilder.Password                    = pswd;
            sqlConnectionStringBuilder.MultipleActiveResultSets    = true;
            sqlConnectionStringBuilder.ApplicationName             = appName;
            entityConnectionStringBuilder.ProviderConnectionString = sqlConnectionStringBuilder.ToString();

            return(entityConnectionStringBuilder.ConnectionString);
        }
        public IDatabaseConfiguration BuildConnectionString(GatewayRegistrationCallback registrationCallback)
        {
            string connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder

            {
                Metadata = "res://*",
                Provider = "System.Data.SqlClient",
                ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                {
                    DataSource = registrationCallback.DatabaseAddress.AbsoluteUri,
                    InitialCatalog = registrationCallback.InitialCatalog,
                    IntegratedSecurity = false,
                    UserID = registrationCallback.Username,
                    Password = registrationCallback.Password
                }.ConnectionString
            }.ConnectionString;

            return new DatabaseConfiguration(connectionString);
        }
Example #25
0
        public Server()
        {
           

            if (System.IO.File.Exists(@".\Server.txt"))
            {
                System.Configuration.Configuration cfg = System.Configuration.ConfigurationManager.OpenExeConfiguration(System.Configuration.ConfigurationUserLevel.None);
                
                System.Data.EntityClient.EntityConnectionStringBuilder ecsb = new System.Data.EntityClient.EntityConnectionStringBuilder();
                ecsb.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbroomEntities"].ConnectionString;
                ecsb.ProviderConnectionString = System.IO.File.ReadLines(@".\Server.txt").First();
                System.Configuration.ConnectionStringsSection conSection = (System.Configuration.ConnectionStringsSection)cfg.GetSection("connectionStrings");
                conSection.ConnectionStrings["dbroomEntities"].ConnectionString = ecsb.ConnectionString;
                cfg.Save();
                System.Configuration.ConfigurationManager.RefreshSection("connectionStrings");
            }

            InitializeComponent();

            if (IsHostIp())
            {
                this.Text = "門禁管理伺服器";
                ServerConfing();
            }
            else
            {
                this.Text = "門禁管理";
            }
            this.dataGridView1.AutoGenerateColumns = false;
            cboType.SelectedIndex = 0;
            //DateTime time = card.ReadTime();
            //CardControl card = new CardControl("192.168.2.199");
            //List<LogData> Cardlog = card.ReadLog(LogType.CradLog);
            //List<LogData> EventLog = card.ReadLog(LogType.EventLog);
            //List<LogData> runTimeLog = card.ReadLog(LogType.RuntimeLog);
            //DateTime date = card.ReadTime();
            //card.SetTime(DateTime.Now);
            //RAC960CardControl Rac960 = new RAC960CardControl("192.168.2.198");
            //List<RAC960Record> data = Rac960.ReadRecord();
            //Rac960.readFlashData();
            //DateTime RacDate = Rac960.ReadTime();
                       
        }
Example #26
0
        public static string getConStrSQL()
        {
            string connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
            {
                Metadata = "res://*",
                Provider = "System.Data.SqlClient",
                ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                {
                    InitialCatalog     = "MyDB",
                    DataSource         = "192.168.43.211",
                    IntegratedSecurity = false,
                    //UserID = getUID(),                 // User ID such as "sa"
                    //Password = getPWD(),               // hide the password
                    UserID   = "sa",               // User ID such as "sa"
                    Password = "******",           // hide the password
                }.ConnectionString
            }.ConnectionString;

            return(connectionString);
        }
Example #27
0
        } // End Function GetConnectionString

        public static string GetEntityConnectionString()
        {
            System.Data.SqlClient.SqlConnectionStringBuilder       csb = new System.Data.SqlClient.SqlConnectionStringBuilder(GetConnectionString());
            System.Data.EntityClient.EntityConnectionStringBuilder ecb = new System.Data.EntityClient.EntityConnectionStringBuilder();

            // http://itstu.blogspot.ch/2008/07/to-load-specified-metadata-resource.html
            // The standard metadata string looks like this:
            // metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl
            // However, in some (including mine) Entity Framework get confused and does not know which dll to look in.
            // Therefore, change the metadata string to:
            // metadata=res://nameOfDll/Model.csdl|res://nameOfDll/Model.ssdl|res://nameOfDll/Model.msl

            string ass = System.IO.Path.GetFileNameWithoutExtension(System.Reflection.Assembly.GetExecutingAssembly().Location);

            ecb.Metadata = @"res://*/COR_Basic_Demo.csdl|res://*/COR_Basic_Demo.ssdl|res://*/COR_Basic_Demo.msl".Replace("*", ass);

            ecb.Provider = "System.Data.SqlClient";
            ecb.ProviderConnectionString = csb.ConnectionString;

            return(ecb.ConnectionString);
        } // End Function GetEntityConnectionString
Example #28
0
        public static string getAIMSConStrIntegrated()
        {
            string conStrIntegratedSecurity = new System.Data.EntityClient.EntityConnectionStringBuilder
            {
                Metadata = "res://PRM/Models.PRM_MfsIwm.csdl|res://PRM/Models.PRM_MfsIwm.ssdl|res://PRM/Models.PRM_MfsIwm.msl",
                Provider = "System.Data.SqlClient",
                ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                {
                    InitialCatalog           = "LILI_BMS",
                    DataSource               = @"PC54\SQL2008",
                    IntegratedSecurity       = false,
                    UserID                   = "sa",
                    Password                 = "******",
                    MultipleActiveResultSets = true,
                    ConnectTimeout           = 0,
                    MaxPoolSize              = 500,
                }.ConnectionString
            }.ConnectionString;

            return(conStrIntegratedSecurity);
        }
Example #29
0
        public static string GetConnectionString(string name, out bool isEntity)
        {
            isEntity = false;
            string connectionString = null;

#if !NETSTANDARD
            // Try to find entity connection.
            var cs = ConfigurationManager.ConnectionStrings[name];
            connectionString = cs.ConnectionString;
#endif
            // If configuration section with not found then return.
            // EF Core does not support EF specific connection strings (metadata=res:... < this kind of connection strings).
#if NETFRAMEWORK // .NET Framework
            if (string.Compare(cs.ProviderName, "System.Data.EntityClient", true) == 0)
            {
                // Get connection string from entity connection string.
                var ecsb = new System.Data.EntityClient.EntityConnectionStringBuilder(cs.ConnectionString);
                connectionString = ecsb.ProviderConnectionString;
                isEntity         = true;
            }
#endif
            if (connectionString == null)
            {
                return(null);
            }
            var builder = new SqlConnectionStringBuilder(connectionString);
            if (!builder.ContainsKey("Application Name") || ".Net SqlClient Data Provider".Equals(builder["Application Name"]))
            {
                var asm = Assembly.GetEntryAssembly();
                if (asm == null)
                {
                    asm = Assembly.GetExecutingAssembly();
                }
                var appPrefix = asm.GetName().Name.Replace(".", "");
                var appName   = string.Format("{0}", appPrefix);
                builder.Add("Application Name", appName);
                connectionString = builder.ToString();
            }
            return(connectionString);
        }
		static public void AutoRefresh(this ObjectContext ctx,
					  RefreshMode refreshMode, IEnumerable collection)
		{
			var csInEF = ctx.Connection.ConnectionString;
            string csForEF;
            if (csInEF.StartsWith("name="))
            {   // old EF
                var csName = csInEF.Replace("name=", "").Trim();
                csForEF =
                  System.Configuration.ConfigurationManager.ConnectionStrings[csName].ConnectionString;
            }
            else
                csForEF = csInEF;
			var newConnectionString = new
			  System.Data.EntityClient.EntityConnectionStringBuilder(csForEF).ProviderConnectionString;
			if (!connectionStrings.Contains(newConnectionString))
			{
				connectionStrings.Add(newConnectionString);
				SqlDependency.Start(newConnectionString);
			}
			ServiceBrokerUtility.ctx = ctx;
			ServiceBrokerUtility.refreshMode = refreshMode;
			AutoRefresh(collection);
		}
        //static clsMultipleDB()
        //{
        //    getDynamicConString();
        //}

        #region Static variables...
        //public static string strDBName = string.Empty;
        //public static string strDynamicConString = "";
        //public static string strMasterConns = "metadata=res://*;provider=System.Data.SqlClient;provider connection string=" + '"' + "Data Source=216.245.213.58,1433;Initial Catalog=AutoTesting;Integrated Security=False;User ID=sa;Password=o5q1Fn0ui@e" + '"' + "";

        #endregion

        #region Public Connection...

        public static string strDynamicConString()
        {
            string strDBName = string.Empty;

            if ((System.Web.HttpContext.Current.Session["DBName"]) != null)
            {
                strDBName = System.Web.HttpContext.Current.Session["DBName"].ToString();
            }

            if (string.IsNullOrEmpty(strDBName) == true)
            {
                if (HttpContext.Current != null)
                {
                    HttpContext.Current.Response.Redirect("Login.aspx");
                }
            }
            string connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
            {
                Metadata = "res://*",
                Provider = "System.Data.SqlClient",
                ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                {
                    InitialCatalog      = strDBName,
                    DataSource          = "136.243.149.22,1443",
                    PersistSecurityInfo = true,
                    UserID   = "sa",
                    Password = "******",

                    //InitialCatalog = strDBName,
                    //DataSource = "ACER-PC\\SQLEXPRESS",
                    //IntegratedSecurity = true,
                }.ConnectionString
            }.ConnectionString;

            return(connectionString);
        }
        public static bool GetEntityConnection(string Username, string Password, string Host, string Database, string Name, bool IntegratedSecurity)
        {
            string connectionString;
            if (IntegratedSecurity)
            {
                connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
                {
                    Metadata = "res://*",
                    Provider = "System.Data.SqlClient",
                    ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                    {
                        InitialCatalog = Database,
                        DataSource = Host,
                        IntegratedSecurity = true,
                        MultipleActiveResultSets = true
                    }.ConnectionString
                }.ConnectionString;
            }

            else
            {
                connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder
                {
                    Metadata = "res://*",
                    Provider = "System.Data.SqlClient",
                    ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder
                    {
                        InitialCatalog = Database,
                        DataSource = Host,
                        IntegratedSecurity = false,
                        UserID = Username,
                        Password = Password,
                        MultipleActiveResultSets = true
                    }.ConnectionString
                }.ConnectionString;
            }

            try
            {
                using (var Context = new finalDBEContext(connectionString))
                {
                    Context.Database.Connection.Open();
                    Context.Database.Connection.Close();
                }

            }
            catch(Exception e)
            {
                Debug.WriteLine("Connection Failed. Message: " + e.Message);
                return false;
            }
            string BaseConnStr = connectionString;
            ConnDictionary.Add(Name, BaseConnStr.Replace(Password, "{0}"));

            ConnectionString = connectionString;
            return true;
        }
Example #33
0
        private void CopyServiceFiles()
        {
            Assembly resourceAssembly = this.GetType().Assembly;

            IOUtil.EnsureDirectoryExists(DestinationFolder);
            IOUtil.EmptyDirectoryRecusively(DestinationFolder);

            string serviceSourceCodePath = Path.Combine(DestinationFolder, _serviceName + ".cs");

            StringBuilder serviceSource = new StringBuilder();

            serviceSource.AppendLine(this.Workspace.BuildDataServiceClassUsings());
            serviceSource.AppendLine("namespace CustomTestServiceHost");
            serviceSource.AppendLine("{");
            serviceSource.AppendLine(this.Workspace.BuildDataServiceClassCode());
            serviceSource.AppendLine("}");

            File.WriteAllText(serviceSourceCodePath, serviceSource.ToString());

            this.Workspace.PopulateHostSourceFolder();

            // copy additional files
            foreach (string file in this.Workspace.ServiceHostFiles())
            {
                File.Copy(file, Path.Combine(DestinationFolder, Path.GetFileName(file)));

                if (file.Contains("Edm.ObjectLayer"))
                {
                    string copiedFile = Path.Combine(DestinationFolder, Path.GetFileName(file));
                    string fileText   = File.ReadAllText(copiedFile);

                    string pathAndName = Path.Combine(DestinationFolder, this.Workspace.Name);

                    System.Data.EntityClient.EntityConnectionStringBuilder connBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();
                    connBuilder.ProviderConnectionString = this.Workspace.Database.DatabaseConnectionString;
                    connBuilder.Metadata = pathAndName + ".csdl|" + pathAndName + ".ssdl|" + pathAndName + ".msl";
                    connBuilder.Provider = "System.Data.SqlClient";

                    string connString = connBuilder.ToString();
                    connString = connString.Replace(@"\", @"\\");
                    connString = connString.Replace("\"", "\\\"");

                    string modifiedText = fileText.Replace("name=" + this.Workspace.ContextTypeName, connString);

                    File.WriteAllText(copiedFile, modifiedText);
                }
            }

#if false // pulled from GAC - not local filesystem
            // Copy Microsoft.OData.Service.dll and test framework
            if (!AstoriaTestProperties.SetupRunOnWebServer)
            {
                if (AstoriaTestProperties.Host != Host.Debug)
                {
                    File.Copy(Path.Combine(Path.GetDirectoryName(resourceAssembly.Location), DataFxAssemblyRef.File.DataServices), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServices));
                }
                else
                {
                    File.Copy(Path.Combine(TestUtil.GreenBitsReferenceAssembliesDirectory, DataFxAssemblyRef.File.DataServices), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServices));
                }
                if (AstoriaTestProperties.Host != Host.Debug)
                {
                    File.Copy(Path.Combine(Path.GetDirectoryName(resourceAssembly.Location), DataFxAssemblyRef.File.DataServicesClient), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServicesClient));
                }
                else
                {
                    File.Copy(Path.Combine(TestUtil.GreenBitsReferenceAssembliesDirectory, DataFxAssemblyRef.File.DataServicesClient), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServicesClient));
                }
            }
#endif

            // TODO: cannot get rid of framework DLL for client SKU
            // File.Copy(resourceAssembly.Location, Path.Combine(hostFolder, Path.GetFileName(resourceAssembly.Location)));
            CopyServerWorkspaceFiles(DestinationFolder);
        }
        private void CopyServiceFiles()
        {
            Assembly resourceAssembly = this.GetType().Assembly;

            IOUtil.EnsureDirectoryExists(DestinationFolder);
            IOUtil.EmptyDirectoryRecusively(DestinationFolder);

            string serviceSourceCodePath = Path.Combine(DestinationFolder, _serviceName + ".cs");

            StringBuilder serviceSource = new StringBuilder();
            serviceSource.AppendLine(this.Workspace.BuildDataServiceClassUsings());
            serviceSource.AppendLine("namespace CustomTestServiceHost");
            serviceSource.AppendLine("{");
            serviceSource.AppendLine(this.Workspace.BuildDataServiceClassCode());
            serviceSource.AppendLine("}");

            File.WriteAllText(serviceSourceCodePath, serviceSource.ToString());

            this.Workspace.PopulateHostSourceFolder();

            // copy additional files
            foreach (string file in this.Workspace.ServiceHostFiles())
            {
                File.Copy(file, Path.Combine(DestinationFolder, Path.GetFileName(file)));

                if (file.Contains("Edm.ObjectLayer"))
                {
                    string copiedFile = Path.Combine(DestinationFolder, Path.GetFileName(file));
                    string fileText = File.ReadAllText(copiedFile);

                    string pathAndName = Path.Combine(DestinationFolder, this.Workspace.Name);

                    System.Data.EntityClient.EntityConnectionStringBuilder connBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();
                    connBuilder.ProviderConnectionString = this.Workspace.Database.DatabaseConnectionString;
                    connBuilder.Metadata = pathAndName + ".csdl|" + pathAndName + ".ssdl|" + pathAndName + ".msl";
                    connBuilder.Provider = "System.Data.SqlClient";

                    string connString = connBuilder.ToString();
                    connString = connString.Replace(@"\", @"\\");
                    connString = connString.Replace("\"", "\\\"");

                    string modifiedText = fileText.Replace("name=" + this.Workspace.ContextTypeName, connString);

                    File.WriteAllText(copiedFile, modifiedText);
                }
            }

#if false // pulled from GAC - not local filesystem
            // Copy Microsoft.OData.Service.dll and test framework
            if (!AstoriaTestProperties.SetupRunOnWebServer)
            {
                if (AstoriaTestProperties.Host != Host.Debug)
                    File.Copy(Path.Combine(Path.GetDirectoryName(resourceAssembly.Location), DataFxAssemblyRef.File.DataServices), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServices));
                else
                    File.Copy(Path.Combine(TestUtil.GreenBitsReferenceAssembliesDirectory, DataFxAssemblyRef.File.DataServices), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServices));
                if (AstoriaTestProperties.Host != Host.Debug)
                    File.Copy(Path.Combine(Path.GetDirectoryName(resourceAssembly.Location), DataFxAssemblyRef.File.DataServicesClient), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServicesClient));
                else
                    File.Copy(Path.Combine(TestUtil.GreenBitsReferenceAssembliesDirectory, DataFxAssemblyRef.File.DataServicesClient), Path.Combine(DestinationFolder, DataFxAssemblyRef.File.DataServicesClient));
            }
#endif

            // TODO: cannot get rid of framework DLL for client SKU
            // File.Copy(resourceAssembly.Location, Path.Combine(hostFolder, Path.GetFileName(resourceAssembly.Location)));
            CopyServerWorkspaceFiles(DestinationFolder);
        }
Example #35
0
        private void button2_Click(object sender, EventArgs e)
        {
            openFileDialog1.ShowDialog();
            var path = openFileDialog1.FileName;

            System.Data.SQLite.SQLiteConnectionStringBuilder connect = new SQLiteConnectionStringBuilder("Data Source=" + path);
            System.Data.EntityClient.EntityConnectionStringBuilder entity_connect = new System.Data.EntityClient.EntityConnectionStringBuilder();
            entity_connect.Provider = @"System.Data.SQLite";
            entity_connect.ProviderConnectionString = connect.ConnectionString;
            entity_connect.Metadata = @"res://*/DB_Model.csdl|res://*/DB_Model.ssdl|res://*/DB_Model.msl";

            data_source = new DB_ModelContainer(entity_connect.ConnectionString);

            dataGridView1.DataSource = data_source.Ciphers_Table;
            MessageBox.Show("База удачно подключена");
        }