public static Task CreateDatabaseAsync(this MySqlDatabase db) { return Task.Run(() => { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(); connStr.Server = db.Host; connStr.Port = (uint)db.Port; connStr.UserID = db.Username; connStr.Password = db.Password; string connString = connStr.ToString(); string nonQuery = String.Format("DROP DATABASE IF EXISTS {0}; CREATE DATABASE {0};", db.DatabaseName); using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand(nonQuery, conn)) { cmd.ExecuteNonQuery(); } conn.Close(); } }); }
protected MySQLDatabase(MySQLStorageEngine engine) { StorageEngine = engine; Name = String.Format("MySQL ({0})", StorageEngine); Category = "SQL"; Description = "MySQL + .NET Connector"; Website = "http://www.mysql.com/"; Color = System.Drawing.Color.FromArgb(215, 233, 247); Requirements = new string[] { "MySql.Data.dll" }; MySqlConnectionStringBuilder cb = new MySqlConnectionStringBuilder(); cb.ConnectionLifeTime = 0; cb.DefaultCommandTimeout = 0; cb.Server = "localhost"; cb.UserID = "root"; cb.Password = ""; cb.Database = "test"; CollectionName = "table1"; ConnectionString = cb.ConnectionString; InsertsPerQuery = 10000; }
public override void initialize_connections(ConfigurationPropertyHolder configuration_property_holder) { if (!string.IsNullOrEmpty(connection_string)) { string[] parts = connection_string.Split(';'); foreach (string part in parts) { if (string.IsNullOrEmpty(server_name) && (part.to_lower().Contains("server") || part.to_lower().Contains("data source"))) { server_name = part.Substring(part.IndexOf("=") + 1); } if (string.IsNullOrEmpty(database_name) && (part.to_lower().Contains("database") || part.to_lower().Contains("database"))) { database_name = part.Substring(part.IndexOf("=") + 1); } } } configuration_property_holder.ConnectionString = connection_string; set_provider(); if (string.IsNullOrEmpty(admin_connection_string)) { var builder = new MySqlConnectionStringBuilder(connection_string); builder.Database = "information_schema"; admin_connection_string = builder.ConnectionString; } }
/// <summary> /// Constructor /// </summary> /// <param name="Engine">The string name, from the GetDatabaseEngine() method</param> /// <param name="Host">The Database server IP Address</param> /// <param name="Port">The Database server Port Number</param> /// <param name="DatabaseName">The name of the database</param> /// <param name="User">A username, with database privliages</param> /// <param name="Pass">The password to the User</param> public DatabaseDriver(string Engine, string Host, int Port, string DatabaseName, string User, string Pass) { // Set class variables, and create a new connection builder this.DatabaseEngine = GetDatabaseEngine(Engine); DbConnectionStringBuilder Builder; if (this.DatabaseEngine == DatabaseEngine.Sqlite) { string FullPath = Path.Combine(MainForm.Root, DatabaseName + ".sqlite3"); IsNewDatabase = !File.Exists(FullPath) || new FileInfo(FullPath).Length == 0; Builder = new SQLiteConnectionStringBuilder(); Builder.Add("Data Source", FullPath); Connection = new SQLiteConnection(Builder.ConnectionString); } else if (this.DatabaseEngine == DatabaseEngine.Mysql) { IsNewDatabase = false; Builder = new MySqlConnectionStringBuilder(); Builder.Add("Server", Host); Builder.Add("Port", Port); Builder.Add("User ID", User); Builder.Add("Password", Pass); Builder.Add("Database", DatabaseName); Connection = new MySqlConnection(Builder.ConnectionString); } else { throw new Exception("Invalid Database type."); } }
protected void OnTestClicked(object sender, EventArgs e) { MySql.Data.MySqlClient.MySqlConnectionStringBuilder bld = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); bld.Server = _server.Text; bld.UserID = _user.Text; bld.Password = _pass.Text; _connectionstring = bld.ConnectionString; MySql.Data.MySqlClient.MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection(); con.ConnectionString = _connectionstring; MessageDialog dlg; try{ con.Open(); if (con.State != System.Data.ConnectionState.Open) { dlg = new MessageDialog(this, DialogFlags.Modal, MessageType.Error, ButtonsType.Ok, "オープンできません。" + con.State.ToString()); dlg.Show(); } else { dlg = new MessageDialog(this, DialogFlags.Modal, MessageType.Info, ButtonsType.Ok, "Success. " + con.State.ToString()); dlg.Show(); con.Close(); } } catch (MySql.Data.MySqlClient.MySqlException ex) { dlg = new MessageDialog(this, DialogFlags.Modal, MessageType.Error, ButtonsType.Ok, "Can not open MySQL." + ex.ErrorCode.ToString()); dlg.Show(); } }
private void GetOptionsPricingParam() { //从数据库中读取合约参数 MySqlConnection connMysql = new MySqlConnection(); MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder(); connBuilder.Server = "10.2.7.210"; connBuilder.Port = 3306; connBuilder.Database = "otc"; connBuilder.UserID = "tanzehuan"; connBuilder.Password = "******"; connMysql.ConnectionString = connBuilder.ConnectionString; connMysql.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter("select * from options_contracts", connMysql);//创建连接sql数据库和datatable的dataadapter adapter.Fill(this, "options_contracts");//将sql数据库中的数据读入datatable connMysql.Close(); //在datatable中添加新的列,用来储存最新价 DataColumn col = new DataColumn("last_price"); col.DataType = typeof(decimal); col.AllowDBNull = true; col.DefaultValue = 0; this.Tables["options_contracts"].Columns.Add(col); DataColumn colBls = new DataColumn("bls_price"); colBls.DataType = typeof(decimal); colBls.AllowDBNull = true; colBls.DefaultValue = 0; this.Tables["options_contracts"].Columns.Add(colBls); }
private void btnOK_Click(object sender, EventArgs e) { //验证控件内容 if (!CheckInput()) { lblMsg.ForeColor = Color.Red; lblMsg.Text = "بوش قالمىسۇن"; return; } lblMsg.ForeColor = Color.Blue; lblMsg.Text = "ساندانغا ئۇلىنىۋاتىدۇ..."; //string conStr = string.Format("user id={0};password={1};host={2};Database={3};persist security info=True", txtUserName.Text.Trim(), txtPassWord.Text, txtHost.Text.Trim(), txtDataBase.Text.Trim()); MySqlConnectionStringBuilder buil = new MySqlConnectionStringBuilder(); buil.CharacterSet = "utf8"; buil.Server = txtHost.Text.Trim(); buil.UserID = txtUserName.Text.Trim(); buil.Password = txtPassWord.Text; buil.Database = txtDataBase.Text.Trim(); using (MySqlConnection con = new MySqlConnection(buil.ConnectionString)) { try { con.Open(); } catch (Exception) { lblMsg.ForeColor = Color.Red; lblMsg.Text = "ساندانغا ئۇلىنالمىدى"; return; } } MessageBox.Show("ساندانغا مۇۋاپىقىيەتلىك ئۇلاندى!~"); Helper.conStr = buil.ConnectionString; this.DialogResult = System.Windows.Forms.DialogResult.OK; }
/// <summary> /// /// </summary> /// <param name="connStr">���ܹ��������ַ���</param> /// <returns></returns> /// <exception cref="System.NullReferenceException"></exception> /// <exception cref="System.Execption"></exception> public static MySqlConnection GetMySqlConn(string connStr) { if(string.IsNullOrEmpty(connStr)) { throw new System.NullReferenceException("�����ֲ���Ϊ��"); } string tmp = PswdHelper.DecryptString(connStr); string[] ss = tmp.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries); if(ss.Length!=5) { throw new Exception("�����ָ�ʽ����"); } MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder(); connBuilder.Add("User Id", ss[0]); connBuilder.Add("Password", ss[1]); connBuilder.Add("Data Source", ss[2]); connBuilder.Add("Database", ss[3]); connBuilder.Add("Charset", ss[4]); MySqlConnection connection = new MySqlConnection(connBuilder.ConnectionString); return connection; }
// Zu Quell- und Zieldatenbank verbinden private void connectFischFaunaButton_Click(object sender, EventArgs e) { DatabaseConnection sourceCon = (DatabaseConnection)sourceDatabaseConnetions.SelectedValue; DatabaseConnection targetCon = (DatabaseConnection)targetDatabaseConnetions.SelectedValue; NpgsqlConnectionStringBuilder pgConStrBuilder = new NpgsqlConnectionStringBuilder(); pgConStrBuilder.Host = sourceCon.ServerAddress; pgConStrBuilder.UserName = sourceCon.UserName; pgConStrBuilder.Password = sourceCon.Password; pgConStrBuilder.Database = sourceCon.Database; MySqlConnectionStringBuilder mySqlConStrBuilder = new MySqlConnectionStringBuilder(); mySqlConStrBuilder.Server = targetCon.ServerAddress; mySqlConStrBuilder.UserID = targetCon.UserName; mySqlConStrBuilder.Password = targetCon.Password; mySqlConStrBuilder.Database = targetCon.Database; mySqlConStrBuilder.AllowZeroDateTime = true; _sourceCon = new NpgsqlConnection(pgConStrBuilder.ToString()); _targetCon = new MySqlConnection(mySqlConStrBuilder.ToString()); _mainLogic = new MainLogic(_sourceCon, _targetCon); _mainLogic.CheckForImportedFieldInMySql(); FillImportsCombobox(); FillImportUsersCombobox(); FillRecordQualityCombobox(); FillSourceTypeCombobox(); FillCountryCombobox(); PreSelectTestData(); groupBox2.Enabled = true; }
public static void DeleteBoatSQL(string sqlQuery) { MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder(); connBuilder.Add("Database", "boatclub"); connBuilder.Add("Data Source", "127.0.0.1"); connBuilder.Add("User Id", "root"); connBuilder.Add("Password", ""); MySqlConnection connection = new MySqlConnection(connBuilder.ConnectionString); MySqlCommand cmd = connection.CreateCommand(); connection.Open(); cmd.CommandText = sqlQuery; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine(String.Format("{0} {1} {2}", reader.GetInt32(0), reader.GetString(1), reader.GetString(2)) ); } reader.Close(); }
private void TestBtn_Click(object sender, EventArgs e) { // Disable console this.Enabled = false; // Build Connection String DbConnectionStringBuilder Builder = new MySqlConnectionStringBuilder(); Builder.Add("Server", Hostname.Text); Builder.Add("Port", (int)Port.Value); Builder.Add("User ID", Username.Text); Builder.Add("Password", Password.Text); Builder.Add("Database", DBName.Text); // Attempt to connect, reporting any and all errors try { MySqlConnection Connection = new MySqlConnection(Builder.ConnectionString); Connection.Open(); Connection.Close(); } catch(Exception E) { this.Enabled = true; MessageBox.Show(E.Message, "Connection Error"); return; } MessageBox.Show("Connection Successful!", "Success"); this.Enabled = true; }
private bool testConnection() { bool returning; //Teste Mysql-Verbindung MySqlConnectionStringBuilder connectionString = new MySqlConnectionStringBuilder(); connectionString.Server = mysqlRow.Host; connectionString.Port = mysqlRow.Port; connectionString.Database = mysqlRow.Database; connectionString.UserID = mysqlRow.UserID; connectionString.Password = mysqlRow.Password; connectionString.ConnectionTimeout = 3; MySqlConnection connection = new MySqlConnection(connectionString.ConnectionString); try { connection.Open(); this.mysqlConnection = connection; returning = true; } catch (MySqlException ex) { this.mysqlException = ex.Message; returning = false; } finally { connection.Close(); } return returning; }
public override bool Connect() { bool opened = true; if (this.Connection == null || this.Connection.State == ConnectionState.Closed) { if (this.Connection != null) { this.Connection.Close(); this.Connection = null; } MySqlConnectionStringBuilder connectionBuilder = new MySqlConnectionStringBuilder { Server = this.Settings.Hostname, Port = this.Settings.Port != null ? this.Settings.Port.Value : 0, Database = this.Settings.Database, UserID = this.Settings.Username, Password = this.Settings.Password, UseCompression = true }; try { this.Connection = new MySqlConnection(connectionBuilder.ToString()); this.Connection.Open(); if (this.Connection.State != ConnectionState.Open) { this.Connection.Close(); this.Connection = null; } } catch { opened = false; } } return opened; }
/// <summary> /// static constructor to determine the state of the environment and set defaults /// </summary> static CurrentEnvironment() { // Not on cloud foundry filling in the blanks. if (string.IsNullOrEmpty(Environment.GetEnvironmentVariable(INSTANCE_GUID_ENV_VARIABLE_NAME))) { Environment.SetEnvironmentVariable(BOUND_SERVICES_ENV_VARIABLE_NAME, "{}"); Environment.SetEnvironmentVariable(PORT_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE); Environment.SetEnvironmentVariable(INSTANCE_GUID_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE); Environment.SetEnvironmentVariable(INSTANCE_INDEX_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE); } // check to see if DB is bound, if so...what type // sql server first if (BoundServices.GetValue("mssql-dev") != null) // sql server { DbEngine = DatabaseEngine.SqlServer; _connectionString = BoundServices["mssql-dev"][0]["credentials"]["connectionString"].ToString(); } else if (BoundServices.GetValue("p-mysql") != null) { DbEngine = DatabaseEngine.MySql;; MySqlConnectionStringBuilder csbuilder = new MySqlConnectionStringBuilder(); csbuilder.Add("server", BoundServices["p-mysql"][0]["credentials"]["hostname"].ToString()); csbuilder.Add("port", BoundServices["p-mysql"][0]["credentials"]["port"].ToString()); csbuilder.Add("uid", BoundServices["p-mysql"][0]["credentials"]["username"].ToString()); csbuilder.Add("pwd", BoundServices["p-mysql"][0]["credentials"]["password"].ToString()); csbuilder.Add("database", BoundServices["p-mysql"][0]["credentials"]["name"].ToString()); _connectionString = csbuilder.ToString(); } else DbEngine = DatabaseEngine.None; }
public static void ClearPool(MySqlConnectionStringBuilder settings) { Debug.Assert(settings != null); string text = settings.ConnectionString; ClearPoolByText(text); }
public DataTable GetComments(string queryString) { DataTable = new DataTable(); mysqlCS = connectToBase(); using (con = new MySqlConnection()) { con.ConnectionString = mysqlCS.ConnectionString; command = new MySqlCommand(queryString, con); try { con.Open(); using (dr = command.ExecuteReader()) { if (dr.HasRows) { DataTable.Load(dr); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } return DataTable; }
private static string GetKey(MySqlConnectionStringBuilder settings) { string key = settings.ConnectionString; #if !CF if(settings.IntegratedSecurity && !settings.ConnectionReset) { try { // Append SID to the connection string to generate a key // With Integrated security different Windows users with the same // connection string may be mapped to different MySQL accounts. System.Security.Principal.WindowsIdentity id = System.Security.Principal.WindowsIdentity.GetCurrent(); key += ";" + id.User; } catch (System.Security.SecurityException ex) { // Documentation for WindowsIdentity.GetCurrent() states // SecurityException can be thrown. In this case the // connection can only be pooled if reset is done. throw new MySqlException(Resources.NoWindowsIdentity, ex ); } } #endif return key; }
DataTable dt_dr = new DataTable(); // tek tablo #endregion Fields #region Constructors public Form3(MySqlConnectionStringBuilder _bag) { InitializeComponent(); MySqlConnection conn = new MySqlConnection(_bag.ToString()); MySqlCommand cmd_hasta_sel = new MySqlCommand("select h.tc,h.adsoyad,d.doktorad from hasta h inner join doktor d on d.iddoktor=h.iddr;", conn); da_hasta = new MySqlDataAdapter(); da_hasta.SelectCommand = cmd_hasta_sel; MySqlCommand cmd_dr_sel = new MySqlCommand("select iddoktor, doktorad from doktor;", conn); MySqlDataAdapter da_dr = new MySqlDataAdapter(); da_dr.SelectCommand = cmd_dr_sel; da_dr.Fill(dt_dr); // doktorlarin listesi da_hasta_ekle = new MySqlDataAdapter(); // hasta eklemek icin MySqlCommand cmdhasta_sel = new MySqlCommand("select tc, adsoyad, iddr from hasta;", conn); MySqlCommand cmdhasta_ins = new MySqlCommand("insert into hasta(tc, adsoyad, iddr) values(@tc, @adsoyad, @iddr);", conn); cmdhasta_ins.Parameters.Add("@tc", MySqlDbType.VarChar, 11, "tc"); cmdhasta_ins.Parameters.Add("@adsoyad", MySqlDbType.VarChar, 45, "adsoyad"); cmdhasta_ins.Parameters.Add("@iddr", MySqlDbType.Int32, 11, "iddr"); da_hasta_ekle.SelectCommand = cmdhasta_sel; da_hasta_ekle.InsertCommand = cmdhasta_ins; verigetir(); // doktorlarin listesini comboya for (int i = 0; i < dt_dr.Rows.Count; i++) cdoktor.Items.Add(dt_dr.Rows[i].ItemArray[1].ToString()); }
public DbConnection CreateConnection(string nameOrConnectionString) { var connectionBuilder = new MySqlConnectionStringBuilder(_baseConnectionString); connectionBuilder.Database = nameOrConnectionString; return new MySqlConnection(connectionBuilder.ToString()); }
public static MySqlConnectionStringBuilder ConnectionBuilder() { string connectionString = "Server=127.0.0.1;Database=vk_app;Uid=root;CharSet=utf8"; MySqlConnectionStringBuilder mysqlCSB; mysqlCSB = new MySqlConnectionStringBuilder(connectionString); return mysqlCSB; }
public static void Command(string command) { try { var connstring = new MySqlConnectionStringBuilder { Server = meh.Default.MysqlHost, UserID = meh.Default.MysqlUsername, Password = meh.Default.MysqlPassword, Database = meh.Default.MysqlDatabase }; var connection = new MySqlConnection(connstring.ToString()); LogWriter.WriteLine(@"opening connection to mysql"); connection.Open(); LogWriter.WriteLine(@"connection successful!"); var sqlcommand = new MySqlCommand(command, connection); LogWriter.WriteLine(@"Running sql command"); sqlcommand.ExecuteNonQuery(); LogWriter.WriteLine(@"Sql Command finished."); } catch (Exception ex) { MessageBox.Show(@"An Error occured while importing the file!, log output should have more info."); LogWriter.WriteLine(ex.Data + ex.StackTrace + ex.Message); } }
public WizardSelectDatabaseViewModel(WizardSelectDatabaseModel model, string host, int port, string username, string password) { WizardSelectDatabase = model; OkCommand = new Command(Ok); CancelCommand = new Command(CancelCmd); var connStr = new MySqlConnectionStringBuilder(); connStr.Server = host; connStr.Port = (uint)port; connStr.UserID = username; connStr.Password = password; using (var connection = new MySqlConnection(connStr.ToString())) { connection.Open(); using (var returnVal = new MySqlDataAdapter("SHOW DATABASES", connection)) { var dataTable = new DataTable(); returnVal.Fill(dataTable); foreach (DataRow row in dataTable.Rows) for (int i = 0; i < row.ItemArray.Length; i++) Databases.Add(row.ItemArray[i].ToString()); } } }
public static SerializeResult Serialize() { try { var Builder = new MySqlConnectionStringBuilder(); Builder.Server = Settings.GetValue("Database.Host"); Builder.Port = uint.Parse(Settings.GetValue("Database.Port")); Builder.UserID = Settings.GetValue("Database.Username"); Builder.Password = Settings.GetValue("Database.Password"); Builder.Database = Settings.GetValue("Database.Database"); Builder.Pooling = Settings.GetValue("Database.Pooling.Enabled").ToLower() == "true"; Builder.MinimumPoolSize = uint.Parse(Settings.GetValue("Database.Pooling.Min")); Builder.MaximumPoolSize = uint.Parse(Settings.GetValue("Database.Pooling.Max")); ConnectionString = Builder.ConnectionString; var Connection = new MySqlConnection(ConnectionString); Connection.Open(); Solution.AppendLine("DatabaseHandler: Connected with database: {0}({1})", Connection.Database, Connection.ServerVersion); } catch { return SerializeResult.Broken; } return SerializeResult.Finished; }
// API GO // Запросы на получение public DataTable get_clients() { DataTable dt = new DataTable(); MySqlConnectionStringBuilder mysqlCSB; mysqlCSB = new MySqlConnectionStringBuilder(); mysqlCSB.Server = server; mysqlCSB.Database = db; mysqlCSB.UserID = user; mysqlCSB.Password = pass; string queryString = @"SELECT * FROM clients"; using (MySqlConnection con = new MySqlConnection()) { con.ConnectionString = mysqlCSB.ConnectionString; MySqlCommand com = new MySqlCommand(queryString, con); try { con.Open(); using (MySqlDataReader dr = com.ExecuteReader()) { if (dr.HasRows) { dt.Load(dr); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } return dt; }
// Передача параметров подключения фенкции, с последующим назначением свойств. /// <summary> /// Метод MySqlConnection. Устанавливает подлючение к БД. /// </summary> public static bool MySqlConnection(string user, string passwd, string host, string db, bool test) { User = user; Pass = passwd; Host = host; DB = db; MySqlConnectionStringBuilder mysqlSting = new MySqlConnectionStringBuilder(); mysqlSting.Server = Host; mysqlSting.Database = DB; mysqlSting.UserID = User; mysqlSting.Password = Pass; mysqlSting.CharacterSet = "utf8"; connection = new MySqlConnection(mysqlSting.ToString()); { try { connection.Open(); connection.Close(); return true; } catch { return false; } } }
public DatabaseDriver() { this.DatabaseEngine = Config.GetDatabaseEngine(); DbConnectionStringBuilder Builder; if (this.DatabaseEngine == DatabaseEngine.Sqlite) { Builder = new SQLiteConnectionStringBuilder(); string FullPath = Path.Combine(Utils.AssemblyPath, Config.GetType<string>("Database", "Database") + ".sqlite3"); IsNewDatabase = !File.Exists(FullPath) || new FileInfo(FullPath).Length == 0; Builder.Add("Data Source", FullPath); Connection = new SQLiteConnection(Builder.ConnectionString); } else if (this.DatabaseEngine == DatabaseEngine.Mysql) { Builder = new MySqlConnectionStringBuilder(); Builder.Add("Server", Config.GetType<string>("Database", "Hostname")); Builder.Add("Port", Config.GetType<int>("Database", "Port")); Builder.Add("User ID", Config.GetType<string>("Database", "Username")); Builder.Add("Password", Config.GetType<string>("Database", "Password")); Builder.Add("Database", Config.GetType<string>("Database", "Database")); Connection = new MySqlConnection(Builder.ConnectionString); } else { throw new Exception("Invalid Database type."); } }
private static void StringBuilderCopy(DbConStringBuilder strBuilder, MySqlConnectionStringBuilder stringBuilder) { stringBuilder.Server = strBuilder.Server; stringBuilder.UserID = strBuilder.UserID; stringBuilder.Password = strBuilder.Password; stringBuilder.Database = strBuilder.Database; }
private string BuildConnectionString() { uint port = 0; try { port = Convert.ToUInt32(this.portTB.Text); } catch (FormatException) { MessageBox.Show("Invalid port number."); return null; } MySqlConnectionStringBuilder bldr = new MySqlConnectionStringBuilder(); bldr.Server = this.hostTB.Text.Trim(); bldr.Port = port; bldr.UserID = this.userTB.Text.Trim(); bldr.Database = this.dbTB.Text.Trim(); bldr.Password = this.passwordTB.Text; if (this.useSslCB.Checked) { bldr.SslMode = MySqlSslMode.Required; } return bldr.GetConnectionString(true); }
/// <summary> /// Default Constructor /// </summary> public ConnectionStringDialog() { InitializeComponent(); this.cmbServerName.Items.Add("<Browse for more>"); this.cmbServerName.Text = ""; dbConnectionStringBuilder = new MySqlConnectionStringBuilder(); }
/// <summary> /// Constructor /// </summary> /// <param name="Engine">The string name, for the GetDatabaseEngine() method</param> /// <param name="Host">The Database server IP Address</param> /// <param name="Port">The Database server Port Number</param> /// <param name="DatabaseName">The name of the database</param> /// <param name="User">A username, with database privliages</param> /// <param name="Pass">The password to the User</param> public DatabaseDriver(string Engine, string Host, int Port, string DatabaseName, string User, string Pass) { // Set class variables, and create a new connection builder this.DatabaseEngine = GetDatabaseEngine(Engine); DbConnectionStringBuilder Builder; // Establish the connection if (this.DatabaseEngine == DatabaseEngine.Sqlite) { // Create the connection Builder = new SQLiteConnectionStringBuilder(); Builder.Add("Data Source", Path.Combine(Program.RootPath, DatabaseName + ".sqlite3")); Connection = new SQLiteConnection(Builder.ConnectionString); } else if (this.DatabaseEngine == DatabaseEngine.Mysql) { // Create the connection Builder = new MySqlConnectionStringBuilder(); Builder.Add("Server", Host); Builder.Add("Port", Port); Builder.Add("User ID", User); Builder.Add("Password", Pass); Builder.Add("Database", DatabaseName); Builder.Add("Convert Zero Datetime", "true"); Connection = new MySqlConnection(Builder.ConnectionString); } else { throw new Exception("Invalid Database type."); } }
/// <include file='docs/MySqlConnection.xml' path='docs/DefaultCtor/*'/> public MySqlConnection() { //TODO: add event data to StateChange docs settings = new MySqlConnectionStringBuilder(); advisor = new UsageAdvisor(this); database = String.Empty; }
public static String getConnectionStr(String host, String port, String userName, String passWord, String dataBase) { MySql.Data.MySqlClient.MySqlConnectionStringBuilder builder = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); builder.Server = host; builder.Port = UInt32.Parse(port); //builder.Database = dataBaseName; builder.UserID = userName; builder.Password = passWord; builder.Database = dataBase; return(builder.GetConnectionString(true)); //return String.Format("host={0};database={1};uid={2};pwd={3};charset=UTF-8", host, dataBaseName, userName, passWord); }
public static DbConnection GetConnection(IOrchardServices orchardServices, ILogger logger) { var setting = orchardServices.WorkContext.CurrentSite.As <SuiteCRMSettingPart>(); if (setting == null) { logger.Error("SuiteCRMSettingPart is null for current site"); return(null); } DbConnectionStringBuilder builder = null; string providerName = string.Empty; if (setting.Provider == Constants.SqlServer) { var sqlConnectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder(); sqlConnectionStringBuilder.DataSource = setting.Host; sqlConnectionStringBuilder.InitialCatalog = setting.Database; sqlConnectionStringBuilder.UserID = setting.Username; sqlConnectionStringBuilder.Password = setting.Password; providerName = "System.Data.SqlClient"; EntityConnectionStringBuilder mainBuilder = new EntityConnectionStringBuilder(); mainBuilder.Provider = providerName; mainBuilder.ProviderConnectionString = builder.ConnectionString; mainBuilder.Metadata = "res://*/Database.SuiteCRMDataContext.csdl|" + "res://*/Database.SuiteCRMDataContext.ssdl|" + "res://*/Database.SuiteCRMDataContext.msl"; return(new EntityConnection(mainBuilder.ConnectionString)); } else if (setting.Provider == Constants.MySql) { var mySqlConnectionStringBuilder = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); mySqlConnectionStringBuilder.Database = setting.Database; mySqlConnectionStringBuilder.UserID = setting.Username; mySqlConnectionStringBuilder.Password = setting.Password; mySqlConnectionStringBuilder.Port = (uint)setting.Port; mySqlConnectionStringBuilder.Server = setting.Host; mySqlConnectionStringBuilder.OldGuids = true; builder = mySqlConnectionStringBuilder; return(new MySqlConnection(builder.ConnectionString)); } else { logger.Error("The provider is not supported"); return(null); } }
private MySqlConnection GetMySqlConnection(bool open = true, bool convertZeroDatetime = false, bool allowZeroDatetime = false) { string cs = @"Server=35.228.116.222;Database=bachelordb;user=Read;pwd=Read1234;"; var csb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(cs) { AllowZeroDateTime = allowZeroDatetime, ConvertZeroDateTime = convertZeroDatetime }; var conn = new MySql.Data.MySqlClient.MySqlConnection(csb.ConnectionString); if (open) { conn.Open(); } return(conn); }
public static bool SetDatabaseParameters_MySQL() { try { MySql.Data.MySqlClient.MySqlConnectionStringBuilder sqlCnnStrBld = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); sqlCnnStrBld.Server = ConfigurationManager.AppSettings["dbServer_MySQL"].ToString(); sqlCnnStrBld.Database = ConfigurationManager.AppSettings["dbDatabase_MySQL"].ToString(); sqlCnnStrBld.UserID = ConfigurationManager.AppSettings["dbUserID_MySQL"].ToString(); sqlCnnStrBld.Password = ConfigurationManager.AppSettings["dbPassword_MySQL"].ToString(); strSQLconn_MySQL = sqlCnnStrBld.ConnectionString; sqlCnnStrBld.Pooling = false; sqlCnnStrBld.Clear(); strTableName = ConfigurationManager.AppSettings["dbImageTable_MySQL"].ToString(); return(true); } catch { return(false); } }
protected void CheckConnectionStringAsUri(string connectionstring, string user, string password, string server, uint port, params string[] parameters) { string result = this.session.ParseConnectionString(connectionstring); MySql.Data.MySqlClient.MySqlConnectionStringBuilder csbuilder = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(result); Assert.True(user == csbuilder.UserID, string.Format("Expected:{0} Current:{1} in {2}", user, csbuilder.UserID, connectionstring)); Assert.True(password == csbuilder.Password, string.Format("Expected:{0} Current:{1} in {2}", password, csbuilder.Password, connectionstring)); Assert.True(server == csbuilder.Server, string.Format("Expected:{0} Current:{1} in {2}", server, csbuilder.Server, connectionstring)); Assert.True(port == csbuilder.Port, string.Format("Expected:{0} Current:{1} in {2}", port, csbuilder.Port, connectionstring)); if (parameters != null) { if (parameters.Length % 2 != 0) { throw new ArgumentOutOfRangeException(); } for (int i = 0; i < parameters.Length; i += 2) { Assert.True(csbuilder.ContainsKey(parameters[i])); Assert.Equal(parameters[i + 1], csbuilder[parameters[i]].ToString()); } } }
public DbConnectionStringBuilder BuildConnectionString(EnumDbProviderType providerType, string server, string database, string userId, string password, bool integratedSecurity = false, int port = 0, bool embedded = false, string provider = null) { var csb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); csb.Server = server; csb.Database = database; if (!string.IsNullOrWhiteSpace(userId)) { csb.UserID = userId; } if (!string.IsNullOrWhiteSpace(password)) { csb.Password = password; } if (integratedSecurity) { csb.IntegratedSecurity = integratedSecurity; } if (port > 0) { csb.Port = (uint)port; } return(csb); }
public static void ClearPool(MySqlConnectionStringBuilder settings) { string text = settings.GetConnectionString(true); ClearPoolByText(text); }
internal object GetValue(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender) { return((bool)msb.values["useoldsyntax"]); }
internal object getConnectiontimeout(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender) { return((uint)msb.values["connectiontimeout"]); }
internal void SetSslMode(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender, object value) { sender.ValidateValue(ref value); MySqlTrace.LogWarning(-1, "Encrypt is now obsolete. Use Ssl Mode instead"); msb.SetValue("Ssl Mode", ((bool)value) ? MySqlSslMode.Preferred : MySqlSslMode.None); }
private async void Connect() { mainForm.ResetStatusStripColors(); TreeNode selectedNode = treeServers.SelectedNode; if (selectedNode.Tag.GetType() == typeof(Realm)) { Server selectedServer = (Server)selectedNode.Parent.Tag; Realm selectedRealm = (Realm)selectedNode.Tag; RealmManager.currRealm = selectedRealm; if (selectedServer.useSSHTunnel) { if (selectedServer.sshHost != String.Empty && selectedServer.sshUser != String.Empty) { ServerManager.initSSH(new SshConnection(selectedServer.sshHost, selectedServer.sshPort, selectedServer.sshUser, selectedServer.sshPassword)); ServerManager.sshConn.AddForwardedPort(selectedServer.sshForwardedPort, selectedServer.sqlHost, selectedServer.sqlPort); } } if (selectedServer.sqlHost != String.Empty && selectedServer.sqlUser != String.Empty) { if (selectedServer.authdb != String.Empty) { MySqlConnectionStringBuilder authString = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); authString.Server = selectedServer.sqlHost; if (ServerManager.sshConn != null && ServerManager.sshConn.isConnected) { authString.Port = selectedServer.sshForwardedPort; } else { authString.Port = selectedServer.sqlPort; } authString.UserID = selectedServer.sqlUser; authString.Password = selectedServer.sqlPassword; authString.Database = selectedServer.authdb; authString.IgnorePrepare = false; connSuccess = ServerManager.InitDB(new AuthDatabase(authString)); } if (selectedRealm.chardb != String.Empty) { MySqlConnectionStringBuilder charString = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); charString.Server = selectedServer.sqlHost; if (ServerManager.sshConn != null && ServerManager.sshConn.isConnected) { charString.Port = selectedServer.sshForwardedPort; } else { charString.Port = selectedServer.sqlPort; } charString.UserID = selectedServer.sqlUser; charString.Password = selectedServer.sqlPassword; charString.Database = selectedRealm.chardb; charString.IgnorePrepare = false; connSuccess = ServerManager.InitDB(new CharDatabase(charString)); } } } if (connSuccess) { await Account.LoadFromDB(); ServerManager.Save(); this.Close(); } }
internal object GetSslMode(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender) { return(msb.SslMode > MySqlSslMode.None); }
internal object GetIntegratedSecurity(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender) { return((bool)msb.values["Integrated Security"]); }
public NativeDriver(MySqlConnectionStringBuilder settings) : base(settings) { isOpen = false; }
internal void SetValue(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender, object value) { MySqlTrace.LogWarning(-1, "Use Old Syntax is now obsolete. Please see documentation"); msb.SetValue("useoldsyntax", value); }
/// <include file='docs/MySqlConnection.xml' path='docs/Open/*'/> public override void Open() { if (State == ConnectionState.Open) { Throw(new InvalidOperationException(Resources.ConnectionAlreadyOpen)); } #if !CF && !WINDOWS_UWP // start up our interceptors exceptionInterceptor = new ExceptionInterceptor(this); commandInterceptor = new CommandInterceptor(this); #endif SetState(ConnectionState.Connecting, true); AssertPermissions(); #if !CF && !WINDOWS_UWP // if we are auto enlisting in a current transaction, then we will be // treating the connection as pooled if (Settings.AutoEnlist && Transaction.Current != null) { driver = DriverTransactionManager.GetDriverInTransaction(Transaction.Current); if (driver != null && (driver.IsInActiveUse || !driver.Settings.EquivalentTo(this.Settings))) { Throw(new NotSupportedException(Resources.MultipleConnectionsInTransactionNotSupported)); } } #endif try { MySqlConnectionStringBuilder currentSettings = Settings; #if !CF // Load balancing if (ReplicationManager.IsReplicationGroup(Settings.Server)) { if (driver == null) { ReplicationManager.GetNewConnection(Settings.Server, false, this); } else { currentSettings = driver.Settings; } } #endif if (Settings.Pooling) { MySqlPool pool = MySqlPoolManager.GetPool(currentSettings); if (driver == null || !driver.IsOpen) { driver = pool.GetConnection(); } procedureCache = pool.ProcedureCache; } else { if (driver == null || !driver.IsOpen) { driver = Driver.Create(currentSettings); } procedureCache = new ProcedureCache((int)Settings.ProcedureCacheSize); } } catch (Exception ex) { SetState(ConnectionState.Closed, true); throw; } // if the user is using old syntax, let them know if (driver.Settings.UseOldSyntax) { MySqlTrace.LogWarning(ServerThread, "You are using old syntax that will be removed in future versions"); } SetState(ConnectionState.Open, false); driver.Configure(this); if (!(driver.SupportsPasswordExpiration && driver.IsPasswordExpired)) { if (Settings.Database != null && Settings.Database != String.Empty) { ChangeDatabase(Settings.Database); } } // setup our schema provider schemaProvider = new ISSchemaProvider(this); #if !CF perfMonitor = new PerformanceMonitor(this); #endif // if we are opening up inside a current transaction, then autoenlist // TODO: control this with a connection string option #if !MONO && !CF && !WINDOWS_UWP if (Transaction.Current != null && Settings.AutoEnlist) { EnlistTransaction(Transaction.Current); } #endif hasBeenOpen = true; SetState(ConnectionState.Open, true); }
/// <include file='docs/MySqlConnection.xml' path='docs/DefaultCtor/*'/> public MySqlConnection() { //TODO: add event data to StateChange docs Settings = new MySqlConnectionStringBuilder(); database = String.Empty; }
public abstract object GetObject(MySqlConnectionStringBuilder builder);
public TracingDriver(MySqlConnectionStringBuilder settings) : base(settings) { driverId = Interlocked.Increment(ref driverCounter); }
// // Entity Code Gen // public string GetSourceCode() { tit = Filename; tit = tit.Substring(tit.LastIndexOf(Resources.DirSp) + 1, tit.LastIndexOf(".") - tit.LastIndexOf("/") - 1); string ret = Resources.Header1; ret = ret + Resources.ComSp + tab + tit + ".cs" + nl + nl; ret = ret + "NameSpace " + Name + Resources.SB + nl + tab + "[DbConfigurationType(typeof(MySqlEFConfiguration))]" + nl + tab + "public partial class " + tit + "DB : DbContext {" + nl + tab + tab + "public " + tit + "DB() : base(" + bd + "name=" + tit + "ConnectionS" + bd + ") {" + nl + tab + tab + tab + _init + ";" + nl + tab + tab + "}" + nl + tab + tab + "public " + tit + "DB(string ConnectionString) : base( ConnectionString ){ " + nl + tab + tab + tab + _init + ";" + nl + tab + tab + "}" + nl + tab + tab + "public " + tit + "DB(MySqlConnection Connection) : base(Connection.ConnectionString) {" + nl + tab + tab + tab + _init + ";" + nl + tab + tab + "}" + nl + tab + tab + "private void " + _init + " {" + nl; if (Routines.Count > 0) { ret = ret + tab + tab + tab + tit + "Connection = new MySqlConnection();" + nl; } foreach (MyRoutine rtn in Routines) { ret = ret + tab + tab + tab + rtn.name + " = new MySqlCommand();" + nl; ret = ret + tab + tab + tab + rtn.name + ".Connection = (MySqlConnection)" + "Database.Connection;" + nl; ret = ret + tab + tab + tab + rtn.name + ".CommandText = \"CALL " + rtn.name; if (rtn.Params.Count > 0) { ret = ret + " (\"" + nl; } else { ret = ret + ";\";" + nl; } int wk1 = 0; foreach (MyRoutineParam prm in rtn.Params) { wk1++; ret = ret + tab + tab + tab + tab + "+ \"`" + prm.name + "`"; if (wk1 != rtn.Params.Count) { ret = ret + ",\"" + nl; } else { ret = ret + "\"" + nl + tab + tab + tab + tab + "+ \");\";" + nl; } } foreach (MyRoutineParam prm in rtn.Params) { ret = ret + tab + tab + tab + rtn.name + ".Parameters.Add(new MySqlParameter(\"" + prm.name + "\","; int len = prm.datatype.LastIndexOf("("); if (len < 1) { len = prm.datatype.Length; } //len--; string type = prm.datatype.Substring(0, len); type = type.ToLower(); type = paramtype(type); ret = ret + type + "));" + nl; } } ret = ret + tab + tab + Resources.EB + nl; foreach (MyTable tbl in Tables) { ret = ret + tab + tab + "public DbSet<" + tbl.name + "> " + tbl.name + "s " + prop + nl; } ret = ret + nl; if (Routines.Count > 0) { ret = ret + tab + tab + "private MySqlConnection " + tit + "Connection;" + nl; } foreach (MyRoutine rtn_name in Routines) { ret = ret + tab + tab + "public MySqlCommand " + rtn_name.name + ";" + nl; } ret = ret + nl + tab + "}" + nl + nl; foreach (MyTable tbl in Tables) { ret = ret + tab + "public partial class " + tbl.name + " {" + nl; MyIndexColumn icx = null; MyIndex ixx = null; foreach (MyColumn col in tbl.Columns) { icx = null; ixx = null; foreach (MyIndex idx in Indexes) { foreach (MyIndexColumn icl in idx.IndexColumn) { if (col.linkid == icl.referencedColumn) { icx = icl; break; } } if (icx != null) { ixx = idx; break; } } if ((icx != null) && (ixx != null)) { if (ixx.isPrimary > 0) { if (col.autoIncrement > 0) { ret = ret + tab + tab + "[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]" + nl; } else { ret = ret + tab + tab + "[Key, DatabaseGenerated(DatabaseGeneratedOption.None)]" + nl; } } } MyUserDatatype typ = Usertype.Find(x => x.actualType == col.SimpleDatatype); string styp = ""; if (typ != null) { styp = cstype(typ); } if (styp.Length < 1) { styp = col.SimpleDatatype.Substring(col.SimpleDatatype.LastIndexOf(".") + 1, col.SimpleDatatype.Length - col.SimpleDatatype.LastIndexOf(".") - 1); styp = cstype(styp); } if (styp != "string") { if (col.isNotNull == 0) { ret = ret + tab + tab + "public Nullable<" + styp + "> " + col.name + prop + nl; } else { ret = ret + tab + tab + "public " + styp + " " + col.name + prop + nl; } } else { ret = ret + tab + tab + "public " + styp + " " + col.name + prop + nl; } } ret = ret + tab + Resources.EB + nl; } ret = ret + tab + "public partial class " + tit + "CreateDatabaseIfNotExists : CreateDatabaseIfNotExists<" + tit + "> {" + nl + tab + tab + "public " + tit + "CreateDatabaseIfNotExists() :base() {" + nl + tab + tab + Resources.EB + nl + tab + tab + "protected override void Seed(" + tit + " context) {" + nl + tab + tab + tab + "base.Seed(context);" + nl + tab + tab + Resources.EB + nl + tab + Resources.EB + nl + Resources.EB + nl; string savename = Filename; savename = savename.Substring(0, savename.LastIndexOf(Resources.DirSp)); savename = savename + Resources.DirSp + tit + ".cs"; StreamWriter wrt = File.CreateText(savename); wrt.Write(ret); wrt.Close(); savename = savename.Substring(0, savename.LastIndexOf(Resources.DirSp)); savename = savename + Resources.DirSp + "RreadmeAppconfig.txt"; wrt = File.CreateText(savename); wrt.Write(Resources.Config1); wrt.Write("\"" + tit + "ConnectionS\" "); wrt.Write(Resources.Config2); MySql.Data.MySqlClient.MySqlConnectionStringBuilder bld = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); bld.Server = Server; bld.UserID = UserID; bld.Password = Password; bld.Database = Database; wrt.Write("\"" + bld.ConnectionString + "\" "); wrt.Write(Resources.Config3); wrt.Close(); return(ret); }
internal object GetUseprocedurebodies(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender) { return((bool)msb.values["useprocedurebodies"]); }