//--------------------------------------------------------------
// Load Data by calling related Stored Procedure
public void UomLoadData(IConfiguration configuration)
{
System.Console.WriteLine("--------------------------------UomLoadData:1--------------------------------");
// Link to resolve the error: 'The type 'MySqlConnection ' exists in both 'MySql.Data' ... and 'MySqlConnector'...
// - https://stackoverflow.com/questions/48683241/the-type-mysqlconnection-exists-in-both-mysql-data-issue
// Link used to calll a MySql Stored Procedure:
// - https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-using.html
// Call Stored Procedure
const string storedProcedureName = "DSP_INS_Data";
MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlConnection();
// Get connection string from appsettings.json
conn.ConnectionString = configuration.GetSection("DBInfo").GetSection("ConnectionString").Value;
MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlCommand cmd = new MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlCommand();
try{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = storedProcedureName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pTruncateData", 1);
cmd.Parameters["@pTruncateData"].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
}
catch (MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlException ex)
{
System.Console.WriteLine($"Error: {ex.Number}, Message: {ex.Message}");
}
finally
{
conn.Close();
}
}
