public SqlCommand UP__Table__Account__Update(SqlConnection connection = null, SqlTransaction transaction = null) { SqlCommand cmd = new SqlCommand() { Connection = connection, CommandType = CommandType.StoredProcedure, CommandText = @"[customer].[UP__Table__Account__Update]", Transaction = transaction, }; SqlParameter[] pa = new SqlParameter[] { ParameterFactory.ReturnValueParameter(), ParameterFactory.PrimaryKeyParameter(parameterName: "@pAccountID", sourceColumn: "AccountID", forInsert: false), ParameterFactory.RowVersionParameter(forInsert: false), ParameterFactory.ForeignKeyParameter(parameterName: "@pCustomerID", sourceColumn: "CustomerID"), ParameterFactory.NVarCharCodeParameter(), ParameterFactory.NVarCharEntityNameParameter(parameterName: "@pAccount", sourceColumn: "Account"), ParameterFactory.BitParameter(parameterName: "@pActive", sourceColumn: "Active"), }; cmd.Parameters.AddRange(pa); return(cmd); }
public SqlCommand UP__Table__Customer__Delete(SqlConnection connection = null, SqlTransaction transaction = null) { SqlCommand cmd = new SqlCommand() { Connection = connection, CommandType = CommandType.StoredProcedure, CommandText = @"[customer].[UP__Table__Customer__Delete]", Transaction = transaction, }; SqlParameter[] pa = new SqlParameter[] { ParameterFactory.ReturnValueParameter(), ParameterFactory.PrimaryKeyParameter(parameterName: "@pCustomerID", sourceColumn: "CustomerID", forInsert: false), ParameterFactory.RowVersionParameter(forInsert: false), }; cmd.Parameters.AddRange(pa); return(cmd); }