private static void MyCompiledTestFailure()
{
var dataSource = MySqlDataSource.CreateFromConfig("MySqlTestDatabase");
dataSource.TestConnection();
var sql = "INSERT INTO hr.employee (`FirstName`, `LastName`, `ManagerKey`, `MiddleName`, `Title`, `UpdatedDate`) VALUES (@FirstName, @LastName, @ManagerKey, @MiddleName, @Title, @UpdatedDate);SELECT `CreatedDate`, `EmployeeKey`, `FirstName`, `LastName`, `ManagerKey`, `MiddleName`, `Title`, `UpdatedDate` FROM `hr`.`employee` WHERE `EmployeeKey` = LAST_INSERT_ID();";
var con = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySqlTestDatabase"].ConnectionString);
con.Open();
var cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("@FirstName", "Test");
cmd.Parameters.AddWithValue("@LastName", "Employee636768087033711525");
cmd.Parameters.AddWithValue("@ManagerKey", DBNull.Value);
cmd.Parameters.AddWithValue("@MiddleName", DBNull.Value);
cmd.Parameters.AddWithValue("@Title", "Mail Room");
cmd.Parameters.AddWithValue("@UpdatedDate", DBNull.Value);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var result = Load(reader);
}
}
private static void MySqlMetadata()
{
var dataSource = MySqlDataSource.CreateFromConfig("MySqlTestDatabase");
dataSource.TestConnection();
/*
* var table1 = dataSource.DatabaseMetadata.GetTableOrView("Film");
* Console.WriteLine($"{table1.Name} Columns {table1.Columns.Count}");
* Console.WriteLine();
*
* dataSource.TestConnection();
* dataSource.DatabaseMetadata.PreloadTables();
*
* foreach (var item in dataSource.DatabaseMetadata.GetTablesAndViews())
* {
* var x = item.IsTable ? "TABLE" : "VIEW";
* Console.WriteLine($"{item.Name} {x} Columns {item.Columns.Count}");
* }
*
* Console.WriteLine();
*
* dataSource.DatabaseMetadata.PreloadStoredProcedures();
*
* foreach (var item in dataSource.DatabaseMetadata.GetStoredProcedures())
* {
* Console.WriteLine($"{item.Name} Parameters {item.Parameters.Count}");
* }
* Console.WriteLine();
*
* dataSource.DatabaseMetadata.PreloadScalarFunctions();
*
* foreach (var item in dataSource.DatabaseMetadata.GetScalarFunctions())
* {
* Console.WriteLine($"{item.Name} Parameters {item.Parameters.Count}");
* }
* Console.WriteLine();
*/
}
