public int DataTableUpdate(DataTable dataTable, ITableMappingCollection mappingCollection, CommandType insertCommandtype, string insertSql, IDbParameters insertParameters, CommandType updateCommandtype, string updateSql, IDbParameters updateParameters, CommandType deleteCommandtype, string deleteSql, IDbParameters deleteParameters, IDataAdapterSetter dataAdapterSetter) { //TODO - refactor to remove cut-n-pasted code. IDbCommand insertCommand = null; if (insertSql != null) { insertCommand = DbProvider.CreateCommand(); insertCommand.CommandType = insertCommandtype; insertCommand.CommandText = insertSql; ParameterUtils.CopyParameters(insertCommand, insertParameters); } IDbCommand updateCommand = null; if (updateSql != null) { updateCommand = DbProvider.CreateCommand(); updateCommand.CommandType = updateCommandtype; updateCommand.CommandText = updateSql; ParameterUtils.CopyParameters(updateCommand, updateParameters); } IDbCommand deleteCommand = null; if (deleteSql != null) { deleteCommand = DbProvider.CreateCommand(); deleteCommand.CommandType = deleteCommandtype; deleteCommand.CommandText = deleteSql; ParameterUtils.CopyParameters(deleteCommand, deleteParameters); } int returnVal = (int)Execute(new DataAdapterUpdateCallback(dataTable, mappingCollection, insertCommand, updateCommand, deleteCommand, null)); if (insertSql != null) { ParameterUtils.CopyParameters(insertParameters, insertCommand); } if (updateSql != null) { ParameterUtils.CopyParameters(updateParameters, updateCommand); } if (deleteSql != null) { ParameterUtils.CopyParameters(deleteParameters, deleteCommand); } return returnVal; }
public DataAdapterFillCallback(DataTable dataTable, CommandType commandType, string sql, ITableMappingCollection mappingCollection, IDataAdapterSetter dataAdapterSetter, IDataSetFillLifecycleProcessor fillLifecycleProcessor, IDbParameters parameters) { containsDataSet = false; this.dataTable = dataTable; this.commandType = commandType; this.sql = sql; this.mappingCollection = mappingCollection; this.dataAdapterSetter = dataAdapterSetter; this.fillLifecycleProcessor = fillLifecycleProcessor; this.parameters = parameters; }
public virtual int DataSetUpdate(DataSet dataSet, string tableName, IDbCommand insertCommand, IDbCommand updateCommand, IDbCommand deleteCommand, IDataAdapterSetter dataAdapterSetter) { ValidateUpdateArguments(dataSet, tableName); ITableMappingCollection tableMapping = DoCreateMappingCollection(new string[] { tableName }); return (int)Execute(new DataAdapterUpdateCallback(dataSet, tableMapping, insertCommand, updateCommand, deleteCommand, dataAdapterSetter)); }
public virtual int DataSetUpdate(DataSet dataSet, ITableMappingCollection tableMapping, IDbCommand insertCommand, IDbCommand updateCommand, IDbCommand deleteCommand, IDataAdapterSetter dataAdapterSetter) { ValidateUpdateArguments(dataSet, tableMapping); return (int)Execute(new DataAdapterUpdateCallback(dataSet, tableMapping, insertCommand, updateCommand, deleteCommand, dataAdapterSetter)); }
public virtual int DataSetFillWithParameters(DataSet dataSet, CommandType commandType, string sql, IDbParameters parameters, ITableMappingCollection tableMapping, IDataAdapterSetter dataAdapterSetter, IDataSetFillLifecycleProcessor fillLifecycleProcessor) { ValidateFillWithParameterArguments(dataSet, sql, parameters, tableMapping); return (int)Execute(new DataAdapterFillCallback(dataSet, commandType, sql, tableMapping, dataAdapterSetter, fillLifecycleProcessor, parameters)); }
public virtual int DataSetUpdateWithCommandBuilder(DataSet dataSet, CommandType commandType, string selectSql, IDbParameters selectParameters, ITableMappingCollection mappingCollection, IDataAdapterSetter dataAdapterSetter) { ValidateUpdateWithCommandBuilderArguments(dataSet, mappingCollection, selectSql); return (int)Execute(new DataAdapterUpdateWithCommandBuilderCallback(dataSet, DbProvider.CreateCommandBuilder(), mappingCollection, commandType, selectSql, selectParameters, dataAdapterSetter)); }
public virtual DataSet DataSetCreateWithParams(CommandType commandType, string sql, IDbParameters parameters, ITableMappingCollection tableMapping, IDataAdapterSetter dataAdapterSetter, IDataSetFillLifecycleProcessor fillLifecycleProcessor) { DataSet dataSet = CreateDataSet(); DataSetFillWithParameters(dataSet, commandType, sql, parameters, tableMapping, dataAdapterSetter, fillLifecycleProcessor); return dataSet; }
public virtual DataTable DataTableCreateWithParams(CommandType commandType, string sql, IDbParameters parameters, ITableMapping tableMapping, IDataAdapterSetter dataAdapterSetter) { DataTable dataTable = CreateDataTable(); DataTableFillWithParams(dataTable, commandType, sql, parameters, tableMapping, dataAdapterSetter); return dataTable; }
public virtual int DataTableUpdate(DataTable dataTable, ITableMapping tableMapping, CommandType insertCommandtype, string insertSql, IDbParameters insertParameters, CommandType updateCommandtype, string updateSql, IDbParameters updateParameters, CommandType deleteCommandtype, string deleteSql, IDbParameters deleteParameters, IDataAdapterSetter dataAdapterSetter) { ValidateUpdateArguments(dataTable, tableMapping); ITableMappingCollection mappingCollection = new DataTableMappingCollection(); mappingCollection.Add((object)tableMapping); return DataTableUpdate(dataTable, mappingCollection, insertCommandtype, insertSql, insertParameters, updateCommandtype, updateSql, updateParameters, deleteCommandtype, deleteSql, deleteParameters, dataAdapterSetter); }
public virtual DataSet DataSetCreate(CommandType commandType, string sql, ITableMappingCollection tableMapping, IDataAdapterSetter setter, IDataSetFillLifecycleProcessor fillLifecycleProcessor) { DataSet dataSet = CreateDataSet(); DataSetFill(dataSet, commandType, sql, tableMapping, setter, fillLifecycleProcessor); return dataSet; }
public virtual int DataTableUpdate(DataTable dataTable, string tableName, CommandType insertCommandtype, string insertSql, IDbParameters insertParameters, CommandType updateCommandtype, string updateSql, IDbParameters updateParameters, CommandType deleteCommandtype, string deleteSql, IDbParameters deleteParameters, IDataAdapterSetter dataAdapterSetter) { ValidateUpdateArguments(dataTable, tableName); ITableMappingCollection mappingCollection = DoCreateMappingCollection(new string[] { tableName }); return DataTableUpdate(dataTable, mappingCollection, insertCommandtype, insertSql, insertParameters, updateCommandtype, updateSql, updateParameters, deleteCommandtype, deleteSql, deleteParameters, dataAdapterSetter); }
public virtual int DataTableUpdateWithCommandBuilder(DataTable dataTable, CommandType commandType, string selectSql, IDbParameters parameters, ITableMapping tableMapping, IDataAdapterSetter dataAdapterSetter) { ValidateUpdateWithCommandBuilderArguments(dataTable, tableMapping, selectSql); ITableMappingCollection mappingCollection = new DataTableMappingCollection(); mappingCollection.Add(tableMapping); return (int)Execute(new DataAdapterUpdateWithCommandBuilderCallback(dataTable, DbProvider.CreateCommandBuilder(), mappingCollection, commandType, selectSql, parameters, dataAdapterSetter)); }
public virtual int DataTableFillWithParams(DataTable dataTable, CommandType commandType, string sql, IDbParameters parameters, ITableMapping tableMapping, IDataAdapterSetter dataAdapterSetter) { ValidateFillWithParameterArguments(dataTable, sql, parameters, tableMapping); ITableMappingCollection mappingCollection = new DataTableMappingCollection(); mappingCollection.Add((object)tableMapping); return (int)Execute(new DataAdapterFillCallback(dataTable, commandType, sql, mappingCollection, dataAdapterSetter, null, parameters)); }
public DataAdapterUpdateCallback(DataTable dataTable, ITableMappingCollection mappingCollection, IDbCommand insertCommand, IDbCommand updateCommand, IDbCommand deleteCommand, IDataAdapterSetter dataAdapterSetter) { containsDataSet = false; this.dataTable = dataTable; this.mappingCollection = mappingCollection; this.insertCommand = insertCommand; this.updateCommand = updateCommand; this.deleteCommand = deleteCommand; this.dataAdapterSetter = dataAdapterSetter; }
public virtual int DataSetFill(DataSet dataSet, CommandType commandType, string sql, ITableMappingCollection tableMapping, IDataAdapterSetter setter, IDataSetFillLifecycleProcessor fillLifecycleProcessor) { ValidateFillArguments(dataSet, sql, tableMapping); return (int)Execute(new DataAdapterFillCallback(dataSet, commandType, sql, tableMapping, setter, fillLifecycleProcessor, null)); }
public DataAdapterUpdateWithCommandBuilderCallback(DataTable dataTable, object commandBuilder, ITableMappingCollection mappingCollection, CommandType selectCommandType, string selectSql, IDbParameters selectParameters, IDataAdapterSetter dataAdapterSetter) { containsDataSet = false; this.dataTable = dataTable; this.commandBuilder = commandBuilder; this.mappingCollection = mappingCollection; this.selectCommandType = selectCommandType; this.selectSql = selectSql; this.selectParameters = selectParameters; this.dataAdapterSetter = dataAdapterSetter; }
public virtual DataTable DataTableCreate(CommandType commandType, string sql, ITableMapping tableMapping, IDataAdapterSetter setter) { DataTable dataTable = CreateDataTable(); DataTableFill(dataTable, commandType, sql, tableMapping, setter); return dataTable; }