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); }
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); }
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); }
/// <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); }
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); }
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); }
/// <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())); }
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()); }
/// <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; }
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()); }
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()); }
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\"; } }
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("База удачно подключена"); }
/// <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; }
/// <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); }
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); }
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\"; } }
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); }
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(); }
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); }
} // 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
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); }
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; }
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); }
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("База удачно подключена"); }