public int ExecuteNonQuery(string commandText, CommandType commandType, params IDbDataParameter[] parameters)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
using (SqlCommand command = new SqlCommand(commandText, connection))
{
if(parameters != null)
{
command.Parameters.AddRange(parameters);
}
command.CommandType = commandType;
try
{
connection.Open();
return command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
}