/// <summary>
/// Creates or updates the procedure on the database if the database does support procedures.
/// </summary>
internal void Execute()
{
if (!DbConnectionManager.SupportProcedures)
{
throw new NotSupportedException($"This task is not supported with the current connection manager ({ConnectionType})");
}
IsExisting = new IfProcedureExistsTask(ProcedureName)
{
ConnectionManager = this.ConnectionManager, DisableLogging = true
}.Exists();
if (IsExisting && ConnectionType == ConnectionManagerType.MySql)
{
new DropProcedureTask(ProcedureName)
{
ConnectionManager = this.ConnectionManager, DisableLogging = true
}
}
/// <summary>
/// Creates or updates the procedure on the database if the database does support procedures.
/// </summary>
public void Execute()
{
if (!DbConnectionManager.SupportProcedures)
{
throw new ETLBoxNotSupportedException("This task is not supported!");
}
IsExisting = new IfProcedureExistsTask(ProcedureName)
{
ConnectionManager = this.ConnectionManager, DisableLogging = true
}.Exists();
if (IsExisting && ConnectionType == ConnectionManagerType.MySql)
{
new DropProcedureTask(ProcedureName)
{
ConnectionManager = this.ConnectionManager, DisableLogging = true
}
}
