async Task <dynamic> execute(DbCmdType type = DbCmdType.NonQuery)
{
switch (connType)
{
case DbConType.MsSQL:
switch (type)
{
case DbCmdType.NonQuery:
return(await msSQL_cmd.ExecuteNonQueryAsync().ConfigureAwait(true));
case DbCmdType.Scalar:
return(await msSQL_cmd.ExecuteScalarAsync().ConfigureAwait(true));
case DbCmdType.Reader:
return(await msSQL_cmd.ExecuteReaderAsync().ConfigureAwait(true));
}
break;
case DbConType.MySQL:
switch (type)
{
case DbCmdType.NonQuery:
return(await mySQL_cmd.ExecuteNonQueryAsync().ConfigureAwait(true));
case DbCmdType.Scalar:
return(await mySQL_cmd.ExecuteScalarAsync().ConfigureAwait(true));
case DbCmdType.Reader:
return(await mySQL_cmd.ExecuteReaderAsync().ConfigureAwait(true));
}
break;
}
return(null);
}
public async Task <dynamic> Execute(DbCmdType type = DbCmdType.NonQuery)
{
try
{
return(await execute(type));
}
catch (Exception ex)
{
OnError(new DBError($"An Exception has occured!\nMessage: {ex.Message}\nStack-Trace: {ex.StackTrace}"));
}
return(null);
}
public async Task <dynamic> Execute(DbCommand cmd, DbCmdType type = DbCmdType.NonQuery)
{
try
{
SetCommand(cmd);
return(await execute(type));
}
catch (Exception ex)
{
MessageBox.Show($"An Exception has occured!\nMessage: {ex.Message}\nStack-Trace: {ex.StackTrace}", "execute", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
}
return(null);
}
public async Task <dynamic> Execute(string text, DbParameter parameters, DbCmdType type = DbCmdType.NonQuery, bool keepAlive = false)
{
try
{
NewCommand(text);
return(await execute(type));
}
catch (Exception ex)
{
MessageBox.Show($"An Exception has occured!\nMessage: {ex.Message}\nStack-Trace: {ex.StackTrace}", "Execute", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
}
return(null);
}
