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(); */ }