internal static IDbCommand GetCommand(string commandText, CommandType commandType, IDbConnection connection) { var cmd = new SqlCommand(commandText); cmd.CommandType = commandType; cmd.Connection = (SqlConnection)connection; return cmd; }