public static void LoadDatabase()
{
Logging.Write("Connecting to database");
try
{
var connectionString = new MySqlConnectionStringBuilder
{
ConnectionTimeout = 10,
Database = GetConfig().Data["db.name"],
DefaultCommandTimeout = 30,
Logging = false,
MaximumPoolSize = uint.Parse(GetConfig().Data["db.pool.maxsize"]),
MinimumPoolSize = uint.Parse(GetConfig().Data["db.pool.minsize"]),
Password = GetConfig().Data["db.password"],
Pooling = true,
Port = uint.Parse(GetConfig().Data["db.port"]),
Server = GetConfig().Data["db.hostname"],
UserID = GetConfig().Data["db.username"],
AllowZeroDateTime = true,
ConvertZeroDateTime = true,
};
DatabaseManager = new DatabaseManager(connectionString.ToString());
Logging.WriteSimpleLine(" - Completed!");
}
catch (Exception Error)
{
Logging.WriteSimpleLine(" - Incomplete!");
Logging.LogError(Error.ToString());
Logging.WriteLine("Failed to connect to MySQL server!", ConsoleColor.Red);
Logging.WriteLine("Press any key to shut down ...", ConsoleColor.Red);
Console.ReadKey(true);
Environment.Exit(1);
return;
}
}
public frmmalzemeekrani()
{
InitializeComponent();
MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();
bag.Server = "localhost";
bag.UserID = "root";
bag.Password = "******";
bag.Database = "dbhastanebts";
baglanti = new MySqlConnection(bag.ToString());
//malzeme tablosu select,insert
MySqlCommand cmd_malzeme_sel = new MySqlCommand("select id,malzemeadi,malzemecinsi,malzemeadedi,malzemeaciklama,malzemegiristarihi from malzeme", baglanti);
da_malzeme = new MySqlDataAdapter();
da_malzeme.SelectCommand = cmd_malzeme_sel;
MySqlCommand cmd_malzeme_ins = new MySqlCommand("insert into malzeme(malzemeadi,malzemecinsi,malzemeadedi,malzemegiristarihi,malzemeaciklama) values(@malzemeadi,@malzemecinsi,@malzemeadedi,@malzemegiristarihi,@malzemeaciklama)", baglanti);
cmd_malzeme_ins.Parameters.Add("@malzemeadi", MySqlDbType.VarChar, 45, "malzemeadi");
cmd_malzeme_ins.Parameters.Add("@malzemecinsi", MySqlDbType.VarChar, 45, "malzemecinsi");
cmd_malzeme_ins.Parameters.Add("@malzemeadedi", MySqlDbType.Int32, 11, "malzemeadedi");
cmd_malzeme_ins.Parameters.Add("@malzemegiristarihi", MySqlDbType.VarChar, 45, "malzemegiristarihi");
cmd_malzeme_ins.Parameters.Add("@malzemeaciklama", MySqlDbType.VarChar, 45, "malzemeaciklama");
da_malzeme.InsertCommand = cmd_malzeme_ins;
malzemegetir();
//
da_ustbirim = new MySqlDataAdapter();
// ustbirim tablosu select,insert
MySqlCommand cmd_ustbirim_sel = new MySqlCommand("select id,malzemeadi,malzemecinsi,malzemeadedi,malzemegiristarihi");
da_ustbirim.SelectCommand = cmd_ustbirim_sel;
}
/// <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;
}
Console.WriteLine("BUILD SERVICE INFO...");
Console.WriteLine(_connectionString);
Console.WriteLine("BUILD SERVICE INFO...");
}
public static string HelloWorld()
{
try
{
MySqlConnectionStringBuilder connectionBuilder = new MySqlConnectionStringBuilder
{
Server = "localhost",
Port = 3307,
UserID = "root", //francois
Password = "", //root
Database = "confposte"
};
string hello = null;
using (MySqlConnection connection = new MySqlConnection(connectionBuilder.ToString()))
{
connection.Open();
using (MySqlCommand command = new MySqlCommand("SELECT libelle FROM hello;", connection))
{
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
hello = reader.GetString("libelle");
}
}
}
}
return(hello);
}
catch (Exception e)
{
Debug.WriteLine(e);
throw e;
}
}
private void buttonAtualizar_Click(object sender, EventArgs e)
{
if (ValidarCampos())
{
return;
}
MySqlConnectionStringBuilder conexaoBD = new MySqlConnectionStringBuilder();
conexaoBD.Server = "localhost";
conexaoBD.Database = "locadora_carros";
conexaoBD.UserID = "root";
conexaoBD.Password = "";
MySqlConnection realizaConexacoBD = new MySqlConnection(conexaoBD.ToString());
try
{
realizaConexacoBD.Open(); //Abre a conexão com o banco
MySqlCommand comandoMySql = realizaConexacoBD.CreateCommand(); //Crio um comando SQL
comandoMySql.CommandText = "UPDATE clientes SET nome = '" + textboxNome.Text + "', " +
"local_retirada = '" + comboboxLocal.Text + "', " +
"data_retirada = '" + dateTimePickerRetirada.Value.ToString("yyyy-MM-dd") + "', " +
"data_entrega = '" + dateTimePickerDevolucao.Value.ToString("yyyy-MM-dd") + "', " +
"modelo_veiculo = '" + comboboxVeiculo.Text + "' WHERE id = " + textboxId.Text + "";
comandoMySql.ExecuteNonQuery();
realizaConexacoBD.Close(); // Fecho a conexão com o banco
MessageBox.Show("Atualizado com sucesso");
atualizarGrid();
limparCampos();
}
catch (Exception ex)
{
//MessageBox.Show("Não foi possivel abrir a conexão! ");
Console.WriteLine(ex.Message);
}
}
public String GetConnectionString()
{
switch (DatabaseTypeEnum)
{
case DatabaseTypeEnum.mysql:
{
var builder = new MySqlConnectionStringBuilder
{
Server = Server,
UserID = Username,
Password = Password,
Database = Database,
};
if (Port != null)
{
builder.Port = (uint)Port.Value;
}
return(builder.ToString());
}
case DatabaseTypeEnum.postgresql:
{
var builder = new NpgsqlConnectionStringBuilder
{
Host = Server,
UserName = Username,
Password = Password,
Database = Database,
};
if (Port != null)
{
builder.Port = Port.Value;
}
return(builder.ToString());
}
}
throw new ArgumentException();
}
private void buttonHapusBaju_Click(object sender, EventArgs e)
{
if (textBoxIdBaju.Text != "")
{
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
builder.Server = SERVER;
builder.Database = DATABASE;
builder.UserID = UID;
builder.Password = PASSWORD;
String connString = builder.ToString();
dbConn = new MySqlConnection(connString);
FormPeringatan frmP = new FormPeringatan(this);
frmP.isiLabel("Apakah anda yakin?");
DialogResult result = frmP.ShowDialog();
if (result == DialogResult.OK)
{
String query = string.Format("DELETE from pesan_baju where Id IN ('" + textBoxIdBaju.Text + "')");
MySqlCommand cmd = new MySqlCommand(query, dbConn);
dbConn.Open();
cmd.ExecuteNonQuery();
dbConn.Close();
MessageBox.Show("Anda berhasil menghapus");
loadBaju();
}
else if (result == DialogResult.Cancel)
{
MessageBox.Show("hapus dibatalkan");
}
}
else
{
MessageBox.Show("Data tidak boleh kosong");
}
}
/// <summary>
/// Acepta un objeto tipo conexión y crea una cadena de conexión bien formada
/// de tipo MySQL
/// </summary>
/// <param name="usarSSL">Si la conexión debe usar SSL.</param>
/// <returns>Cadena de conexión válida MySQL</returns>
private string ObtenerCadenaConexionMySQL(bool usarSSL)
{
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
builder.Server = Direccion;
if (BaseDatos != null)
{
builder.Database = BaseDatos;
}
else
{
builder.Database = "";
}
builder.UserID = UsuarioConexion;
builder.Password = ContraseniaConexion;
if (!usarSSL)
{
builder.SslMode = MySqlSslMode.None;
}
return(builder.ToString());
}
protected void ProcessOutstandingEmails(CancellationToken stoppingToken)
{
MySqlConnectionStringBuilder csBuilder = new MySqlConnectionStringBuilder()
{
Server = _mantisDbConfig.Host,
Port = _mantisDbConfig.Port,
Database = _mantisDbConfig.Database,
UserID = _mantisDbConfig.Username,
Password = _mantisDbConfig.Password
};
using (var oDB = new MySqlConnection(csBuilder.ToString()))
{
oDB.Open();
var sentIdList = SendEmailsFromDatabase(stoppingToken, oDB);
if (sentIdList.Count > 0)
{
RemoveSentEmails(stoppingToken, oDB, sentIdList);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
var conexion = new MySqlConnectionStringBuilder
{
Server = "localhost",
UserID = "root",
Password = "******",
Database = "prueba",
Port = 3306,
PersistSecurityInfo = true,
SslMode = none
};
var con = new MySqlConnection(conexion.ToString());
con.Open();
MessageBox.Show("Conectado a la base de datos");
}
catch (Exception)
{
MessageBox.Show("NO ESTA Conectado a la base de datos");
}
}
public DBHandler(string server, MySqlConnectionProtocol protocol, uint timeout = 20, uint poolsize = 40, uint lifetime = 3600)
{
if (lifetime != 0 && lifetime < timeout)
{
throw new ArgumentException("lifetime < timeout");
}
var builder = new MySqlConnectionStringBuilder()
{
Server = server,
ConnectionProtocol = protocol,
Database = "twiten",
SslMode = MySqlSslMode.None, //にゃーん
UserID = "twigaten",
Password = "",
MinimumPoolSize = 1,
MaximumPoolSize = poolsize, //デフォルトは100
ConnectionLifeTime = lifetime,
CharacterSet = "utf8mb4",
DefaultCommandTimeout = timeout //デフォルトは20(秒
};
ConnectionStr = builder.ToString();
}
public static void createConnection(string user_id, string password, string name_database, int port)
{
if (_connection == null)
{
// setup new connection
MySqlConnectionStringBuilder b = new MySqlConnectionStringBuilder();
my_lock = new Object();
b.Server = "127.0.0.1";
b.UserID = user_id;
b.Password = password;
b.Database = name_database;
b.SslMode = MySqlSslMode.None;
b.Port = (uint)port;
_connection = new MySqlConnection(b.ToString());
try
{
_connection.Open();
} catch
{
throw new Exception("Cannot connect to MySQL");
}
}
}
private void sil()
{
string bag;
MySqlConnectionStringBuilder build = new MySqlConnectionStringBuilder();
build.UserID = "root";
build.Password = "";
build.Database = "newdatabase";
build.Server = "localhost";
bag = build.ToString();
baglanti = new MySqlConnection(bag);
string sql = "DELETE FROM kullanici WHERE idkullanici=" + textBox1.Text + ";";
DataTable dt = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand();
command.CommandText = sql;
command.Connection = baglanti;
adapter.SelectCommand = command;
// baglanti.Open();
adapter.Fill(dt);
dataGridView1.DataSource = dt;
}
public MySqlConnection GetConexion()
{
MySqlConnection conexion = null;
try
{
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
builder.Server = "localhost";
builder.Port = 3306;
builder.UserID = "root";
builder.Password = "";
builder.Database = "cine";
//Asigna y abre la conexión
conexion = new MySqlConnection(builder.ToString());
conexion.Open();
}
catch (Exception ex)
{
Console.WriteLine("Error en la conexión: " + ex.Message);
}
return(conexion);
}
//private const string conStr = "";
public static IDbConnection OpenConnection()
{
var cBuilder = new MySqlConnectionStringBuilder();
cBuilder.Server = "localhost";
cBuilder.UserID = "root";
cBuilder.Password = "******";
cBuilder.Database = "classicmodels";
var conStr = cBuilder.ToString();
var connection = new MySqlConnection(conStr);
connection.Open();
return(connection);
System.Data.SqlClient.SqlConnectionStringBuilder builder =
new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.DataSource = "";
builder.UserID = "";
builder.Password = "";
builder.InitialCatalog = "";
}
private void buttonSalvar_Click(object sender, EventArgs e)
{
MySqlConnectionStringBuilder conexaoBD = conexaoBanco();
MySqlConnection realizaConexacoBD = new MySqlConnection(conexaoBD.ToString()); try
{
realizaConexacoBD.Open();
MySqlCommand comandoMySql = realizaConexacoBD.CreateCommand();
comandoMySql.CommandText = "INSERT INTO filme (nomeFilme,generoFilme,anoFilme) " +
"VALUES('" + textBoxNome.Text + "', '" + textBoxGenero.Text + "', " + Convert.ToInt16(textBoxAno.Text) + ")";
comandoMySql.ExecuteNonQuery();
realizaConexacoBD.Close();
MessageBox.Show("Inserido!");
limparCampos();
atualizarGrid();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private DBConnection()
{
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder()
{
Server = SERVER,
UserID = UID,
Password = PASSWORD,
Database = DATABASE,
SslMode = MySqlSslMode.None
};
String connString = builder.ToString();
dbConn = new MySqlConnection(connString);
Application.ApplicationExit += (sender, args) =>
{
if (dbConn != null)
{
dbConn.Dispose();
dbConn = null;
}
};
}
/// <summary>
/// Publiczna funkcja pozwalająca dodać płatność do zamówienia kontrahenta
/// </summary>
public void DodajPlatnoscDoPortalgames()
{
MySqlConnectionStringBuilder portalgamesconn = Utils.PortalGamesConnSring;
using (MySqlConnection conn = new MySqlConnection(portalgamesconn.ToString()))
{
conn.Open();
string sqlCommand = "INSERT INTO `order_pay_history`(order_id, add_date, pay_date, user_id, customer_id, price_brutto) VALUES(@orderId, @addDate, @payDate, @userId, @customerId, @priceBrutto);";
using (var cmd = conn.CreateCommand())
{
cmd.Parameters.AddWithValue("orderId", Zamowienie.IdZamowienia);
cmd.Parameters.AddWithValue("addDate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("payDate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("userId", 3);
cmd.Parameters.AddWithValue("customerId", 0);
cmd.Parameters.AddWithValue("priceBrutto", Zamowienie.KwotaDoZaplaty);
cmd.CommandText = sqlCommand;
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
public void InsertBuilding()
{
if (String.IsNullOrWhiteSpace(tbAddressBuilding.Text) == false && String.IsNullOrWhiteSpace(tbNameBuilding.Text) == false && numNoF.Value > 0)
{
MySqlConnectionStringBuilder sb = new MySqlConnectionStringBuilder
{
Server = "localhost",
Port = 3306,
UserID = "skill09-95",
Password = "******",
Database = "skills_it_95",
CharacterSet = "utf8"
};
MySqlConnection conn = new MySqlConnection(sb.ToString());
MySqlCommand cmd = new MySqlCommand("INSERT INTO buildings (name, num_of_floors, address) VALUES (@name, @num_of_floors, @address)", conn);
cmd.Parameters.AddWithValue("@name", tbNameBuilding.Text);
cmd.Parameters.AddWithValue("@num_of_floors", numNoF.Value);
cmd.Parameters.AddWithValue("@address", tbAddressBuilding.Text);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
}
private void btnSalvar_Click(object sender, EventArgs e)
{
MySqlConnectionStringBuilder conexaoBD = conexaoBanco();
MySqlConnection realizaConexaoBD = new MySqlConnection(conexaoBD.ToString());
try
{
realizaConexaoBD.Open();
MySqlCommand comandoMySql = realizaConexaoBD.CreateCommand();
comandoMySql.CommandText = "INSERT INTO carros (idCarro,ModeloCarro, MarcaCarro, AnoCarro, CorCarro) VALUES ('" + txtID.Text + "','" + txtModelo.Text + "', '" + txtMarca.Text + "', " + txtAno.Text + ", '" + txtCor.Text + "')";
comandoMySql.ExecuteNonQuery();
realizaConexaoBD.Close();
MessageBox.Show("Inserido com sucesso!");
atualizarGrid();
}
catch (Exception ex)
{
MessageBox.Show("Não foi possível abrir a conexão!");
Console.WriteLine(ex.Message);
}
}
private void connect()
{
MySqlConnectionStringBuilder sb = new MySqlConnectionStringBuilder();
sb.Server = "localhost";
sb.UserID = "root";
sb.Password = "";
sb.Database = "cs_harcosok";
sb.CharacterSet = "utf8";
conn = new MySqlConnection(sb.ToString());
try
{
conn.Open();
sql = conn.CreateCommand();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
Environment.Exit(0);
}
}
public MySqlConnection GetMySqlConnection()
{
MySqlConnectionStringBuilder connectionString = new MySqlConnectionStringBuilder
{
Server = m_hostname,
Port = 3306,
UserID = m_user,
Password = m_password,
Database = m_database,
};
MySqlConnection connection = new MySqlConnection(connectionString.ToString());
try
{
connection.Open();
connection.Close();
}
catch
{
return(null);
}
return(connection);
}
public static void EstablishConnection()
{
try
{
MySqlConnectionStringBuilder stringBuilder = new MySqlConnectionStringBuilder();
stringBuilder.Server = "127.0.0.1";
stringBuilder.UserID = "root";
stringBuilder.Password = "******";
stringBuilder.Database = "csgo";
stringBuilder.SslMode = MySqlSslMode.None;
stringBuilder.AllowPublicKeyRetrieval = true;
stringBuilder.AutoEnlist = true;
stringBuilder.AllowUserVariables = true;
connection = new MySqlConnection(stringBuilder.ToString());
// Get the logger
// MessageBox.Show("Database connection successful", "Connection", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception e)
{
MessageBox.Show("Connection Failed!");
}
}
static PCFEnvironment()
{
if (BoundServices.GetValue("p-mysql") != null)
{
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 if (BoundServices.GetValue("p.mysql") != null)
{
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();
}
}
private static void Connect(out MySqlConnection con)
{
try
{
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
builder.Server = SERVER;
builder.UserID = USERNAME;
builder.Password = PASSWORD;
builder.Database = DATABASE;
builder.SslMode = MySqlSslMode.None;
String connString = builder.ToString();
builder = null;
Console.WriteLine(connString);
con = new MySqlConnection(connString);
}
catch (Exception ex)
{
Console.WriteLine("DBConnection | Caught an exception while executing Connect() : " + ex);
con = null;
}
}
public static bool EstableceConexion(string sUsuario, string sPassword, string sServer, string sDatabase)
{
try
{
MySqlConnectionStringBuilder cnx = new MySqlConnectionStringBuilder();
cnx.Server = sServer;
cnx.UserID = sUsuario;
cnx.Password = sPassword;
cnx.Database = sDatabase;
cnx.SslMode = MySqlSslMode.None;
connection = new MySqlConnection(cnx.ToString());
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
connection.Open();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public static void connectMySQL()
{
MySqlConnectionStringBuilder _stringConnection = new MySqlConnectionStringBuilder
{
Server = "localhost",
Database = "database",
UserID = "root",
Password = "******",
Port = 3306
};
// string connectionString = "SERVER=sql12.freemysqlhosting.net;PORT=3306;DATABASE=sql12232054;UID=sql12232054;PWD=L2shZZrK4X";
mysqlConnection = new MySqlConnection(_stringConnection.ToString());
try
{
mysqlConnection.Open();
}
catch (Exception e)
{
Console.WriteLine(e);
MessageBox.Show("Can't connect MySQL");
}
}
public void conectar()
{
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
builder.Server = "mysql5013.smarterasp.net";
builder.UserID = "a131fe_bd";
builder.Password = "******";
builder.Database = "db_a131fe_bd";
MySqlConnection con = new MySqlConnection(builder.ToString());
MySqlCommand cmd = con.CreateCommand();
try
{
con.Open();
}
catch (Exception)
{
}
finally
{
con.Close();
}
}
/// <summary>
///
/// </summary>
/// <param name="dbOptions"></param>
/// <param name="options"></param>
/// <param name="loggerFactory"></param>
/// <param name="loginInfo"></param>
public MySqlDbContextOptions(DbOptions dbOptions, DbModuleOptions options, ILoggerFactory loggerFactory, ILoginInfo loginInfo) : base(dbOptions, options, new MySqlAdapter(dbOptions, options), loggerFactory, loginInfo)
{
if (options.ConnectionString.IsNull())
{
Check.NotNull(dbOptions.Server, nameof(dbOptions.Server), "数据库服务器地址不能为空");
Check.NotNull(dbOptions.UserId, nameof(dbOptions.UserId), "数据库用户名不能为空");
Check.NotNull(dbOptions.Password, nameof(dbOptions.Password), "数据库密码不能为空");
options.Version = dbOptions.Version;
var connStrBuilder = new MySqlConnectionStringBuilder
{
Server = DbOptions.Server,
Port = DbOptions.Port > 0 ? (uint)DbOptions.Port : 3306,
Database = options.Database,
UserID = DbOptions.UserId,
Password = DbOptions.Password,
AllowUserVariables = true,
CharacterSet = "utf8",
SslMode = MySqlSslMode.None
};
options.ConnectionString = connStrBuilder.ToString();
}
}
async void initDb()
{
//Create a new connectionstring
MySqlConnectionStringBuilder _sb = new MySqlConnectionStringBuilder();
_sb.Server = sqlServer;
_sb.Database = sqlDatabase;
_sb.UserID = sqlUserID;
_sb.Password = sqlPassword;
string _cs = _sb.ToString();
//Open new sql connection
sqlConnection = new MySqlConnection(_cs);
await sqlConnection.OpenAsync();
//Just checking if the connection is valid
sqlState = sqlConnection.State;
ConsoleLog.Write(ConsoleState.Warning, $"Database connection -> {sqlState.ToString()}");
//Mandatory to close connection after each call.
await sqlConnection.CloseAsync();
}
