public int ExecuteNonQuery(CommandType commandType, string commandText, params object[] commandParameters)
{
using (IDbConnection conn = _dialect.CreateConnection(_ConnectionString))
{
conn.Open();
try
{
using (IDbCommand cmd = conn.CreateCommand())
{
cmd.CommandType = commandType;
cmd.CommandText = commandText;
for (int i = 0; i < commandParameters.Length; i++)
{
cmd.Parameters.Add(commandParameters[i]);
}
return(cmd.ExecuteNonQuery());
}
}
finally
{
conn.Close();
}
}
}
