public static string GetCurrentDatabaseName(SqlDbConnectionType strType) { SqlResult result = new SqliteCompiler().Compile(GetQueryConfig(strType).Select("query_string").Where("name", "current_db")); //return RunQueryTable("SELECT FROM query_configs WHERE name = '' AND "); return ""; }
public static void SwitchConnection(SqlDbConnectionType connectionType, string strConnectionString) { if (CurrentDatabase == null) { CurrentDatabase = new SqlDbConnection(connectionType, strConnectionString); } else { CurrentDatabase.Connection.ConnectionString = strConnectionString; } }
static SqlDatabaseHelper() { try { _connectionType = SqlDbConnectionType.SqlServer; CurrentDatabase = new SqlDbConnection(_connectionType, GetConnectionString(_connectionType, _strServer, _strDatabase, _strUser, _strPass)); } catch (Exception exception) { MessageBox.Show("Can not connect to server - " + _strServer, "Messenger", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public static void ChangeDatabase(SqlDbConnectionType connectionType, string strDBName) { try { _strDatabase = strDBName; SwitchConnection(connectionType, _strServer, strDBName, _strUser, _strPass); if (CurrentDatabase.Connection.State != ConnectionState.Open) { CurrentDatabase.Connection.Open(); } CurrentDatabase.Connection.ChangeDatabase(strDBName); } catch (Exception e) { } }
public void CompareDatabase(SqlDbConnectionType consType, Dictionary <string, SqlDbConnection> lstCons) { if (!CheckSelectedDB()) { return; } switch (consType) { case SqlDbConnectionType.MySql: CompareDBMySql(lstCons); break; case SqlDbConnectionType.SqlServer: //(new TSQL.Tokens. break; } }
public static string GetDatabaseVersion(SqlDbConnectionType connectionType) { string strQuery = string.Empty; switch (connectionType) { case SqlDbConnectionType.MySql: strQuery = "SELECT VERSION()"; break; case SqlDbConnectionType.SqlServer: strQuery = ""; break; } DataTable dtData = RunQueryTable(strQuery); return(Convert.ToString(dtData.Rows[0][0])); }
public SqlDbConnection(SqlDbConnectionType connectionType, string connectionString) { _connectionType = connectionType; switch (connectionType) { case SqlDbConnectionType.MySql: _dbConnection = new MySqlConnection(connectionString); break; case SqlDbConnectionType.Sqlite: _dbConnection = new SQLiteConnection(connectionString); break; default: _dbConnection = new SqlConnection(connectionString); break; } }
public static string GetConnectionString(SqlDbConnectionType connectionType, String strServer, String strDatabase, String strUsername, String strPassword) { switch (connectionType) { case SqlDbConnectionType.MySql: string[] lstServer = strServer.Split(':'); MySqlConnectionStringBuilder mysqlBuilder = new MySqlConnectionStringBuilder { Server = lstServer.FirstOrDefault(), Port = Convert.ToUInt32(lstServer.LastOrDefault()), Database = strDatabase, UserID = strUsername, Password = strPassword, ConvertZeroDateTime = true, AllowUserVariables = true }; _connectionString = mysqlBuilder.ConnectionString; break; case SqlDbConnectionType.Sqlite: var builder = new SQLiteConnectionStringBuilder { DataSource = strServer, Version = 3 }; _connectionString = builder.ConnectionString; break; default: SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder { DataSource = strServer, UserID = strUsername, Password = strPassword, InitialCatalog = strDatabase }; _connectionString = sqlBuilder.ConnectionString; break; } return(_connectionString); }
public static void SwitchConnection(SqlDbConnectionType connectionType, String strServers, String strDatabases, String strUsernames, String strPasswords) { try { _connectionType = connectionType; if (!string.IsNullOrEmpty(strServers) || strServers != _strServer) { _strServer = strServers; } if (!string.IsNullOrEmpty(strDatabases) || strDatabases != _strDatabase) { _strDatabase = strDatabases; } if (!string.IsNullOrEmpty(strUsernames) || strUsernames != _strUser) { _strUser = strUsernames; } if (!string.IsNullOrEmpty(strPasswords) || strPasswords != _strPass) { _strPass = strPasswords; } if (CurrentDatabase == null) { CurrentDatabase = new SqlDbConnection(connectionType, GetConnectionString(connectionType, _strServer, _strDatabase, _strUser, _strPass)); } else if (!CurrentDatabase.Connection.GetType().Name.StartsWith(SqlDbConnectionType.MySql.ToString())) { CurrentDatabase = new SqlDbConnection(connectionType, GetConnectionString(connectionType, _strServer, _strDatabase, _strUser, _strPass)); } else if (!CurrentDatabase.Connection.GetType().Name.StartsWith("Sql")) { CurrentDatabase = new SqlDbConnection(connectionType, GetConnectionString(connectionType, _strServer, _strDatabase, _strUser, _strPass)); } else if (CurrentDatabase.Connection.State == ConnectionState.Closed) { CurrentDatabase.Connection.ConnectionString = GetConnectionString(connectionType, _strServer, _strDatabase, _strUser, _strPass); } } catch (Exception ex) { MessageBox.Show("Can't not change connection!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void SetSqlDbConnectionType(SqlDbConnectionType connectionType) { _connectionType = connectionType; }
public void GetDatabaseVersion(SqlDbConnectionType connectionType) { string strVersion = SQLDBUtil.GetDatabaseVersion(connectionType); ShowMessengeInfo(strVersion); }
private static Query GetQueryConfig(SqlDbConnectionType strType) { return new Query("query_configs").Where("type", strType.ToString().ToLower()); }