public void SourceTableParentValidation() { // Sets dataTableMappingCollection as the dataTableMapping Parent. DataTableMappingCollection dataTableMappingCollection = new DataTableMappingCollection(); dataTableMappingCollection.Add(_dataTableMapping); // Adds a data table with another source table name. DataTableMapping secondDataTableMapping = new DataTableMapping("AnotherCustomSourceTable", ""); dataTableMappingCollection.Add(secondDataTableMapping); // Attempts to change the second data table source table with a repeated value. Assert.Throws <ArgumentException>(() => secondDataTableMapping.SourceTable = "MyCustomSourceTable"); }
/// <summary> /// 创建默认表列映射 /// </summary> /// <param name="ds"></param> /// <returns></returns> public static System.Data.Common.DataTableMappingCollection CreateDefaultMapping(System.Data.DataSet ds) { DataTableMappingCollection rtn = new DataTableMappingCollection(); foreach (System.Data.DataTable dt in ds.Tables) { DataTableMapping dtm = rtn.Add(dt.TableName, dt.TableName); foreach (DataColumn dc in dt.Columns) { dtm.ColumnMappings.Add(dc.ColumnName, dc.ColumnName); } } return rtn; }
/// <include file='doc\DataAdapter.uex' path='docs/doc[@for="DataAdapter.DataAdapter1"]/*' /> protected DataAdapter(DataAdapter adapter) : base() // MDAC 81448 { AcceptChangesDuringFill = adapter.AcceptChangesDuringFill; ContinueUpdateOnError = adapter.ContinueUpdateOnError; MissingMappingAction = adapter.MissingMappingAction; MissingSchemaAction = adapter.MissingSchemaAction; if ((null != adapter.tableMappings) && (0 < adapter.TableMappings.Count)) { DataTableMappingCollection parameters = this.TableMappings; foreach (ICloneable parameter in adapter.TableMappings) { parameters.Add(parameter.Clone()); } } }
private void CloneFrom(DataAdapter from) { this._acceptChangesDuringUpdate = from._acceptChangesDuringUpdate; this._acceptChangesDuringUpdateAfterInsert = from._acceptChangesDuringUpdateAfterInsert; this._continueUpdateOnError = from._continueUpdateOnError; this._returnProviderSpecificTypes = from._returnProviderSpecificTypes; this._acceptChangesDuringFill = from._acceptChangesDuringFill; this._fillLoadOption = from._fillLoadOption; this._missingMappingAction = from._missingMappingAction; this._missingSchemaAction = from._missingSchemaAction; if ((from._tableMappings != null) && (0 < from.TableMappings.Count)) { DataTableMappingCollection tableMappings = this.TableMappings; foreach (object obj2 in from.TableMappings) { tableMappings.Add((obj2 is ICloneable) ? ((ICloneable)obj2).Clone() : obj2); } } }
[System.Security.Permissions.PermissionSetAttribute(System.Security.Permissions.SecurityAction.Demand, Name = "FullTrust")] // MDAC 82936 virtual protected DataAdapter CloneInternals() { DataAdapter clone = (DataAdapter)Activator.CreateInstance(GetType()); clone.AcceptChangesDuringFill = AcceptChangesDuringFill; clone.ContinueUpdateOnError = ContinueUpdateOnError; clone.MissingMappingAction = MissingMappingAction; clone.MissingSchemaAction = MissingSchemaAction; if ((null != this.tableMappings) && (0 < TableMappings.Count)) { DataTableMappingCollection parameters = clone.TableMappings; foreach (ICloneable parameter in TableMappings) { parameters.Add(parameter.Clone()); } } return(clone); }
private void CloneFrom(DataAdapter from) { _acceptChangesDuringUpdate = from._acceptChangesDuringUpdate; _acceptChangesDuringUpdateAfterInsert = from._acceptChangesDuringUpdateAfterInsert; _continueUpdateOnError = from._continueUpdateOnError; _returnProviderSpecificTypes = from._returnProviderSpecificTypes; _acceptChangesDuringFill = from._acceptChangesDuringFill; _fillLoadOption = from._fillLoadOption; _missingMappingAction = from._missingMappingAction; _missingSchemaAction = from._missingSchemaAction; if ((null != from._tableMappings) && (0 < from.TableMappings.Count)) { DataTableMappingCollection parameters = TableMappings; foreach (object parameter in from.TableMappings) { parameters.Add((parameter is ICloneable) ? ((ICloneable)parameter).Clone() : parameter); } } }
protected virtual ITableMappingCollection DoCreateMappingCollection(string[] dataSetTableNames) { DataTableMappingCollection mappingCollection; if (dataSetTableNames == null) { dataSetTableNames = new string[] { "Table" }; } foreach (string tableName in dataSetTableNames) { if (StringUtils.IsNullOrEmpty(tableName)) { throw new ArgumentException("TableName for DataTable mapping can not be null or empty"); } } mappingCollection = new DataTableMappingCollection(); int counter = 0; bool isFirstTable = true; foreach (string dataSetTableName in dataSetTableNames) { string sourceTableName; if (isFirstTable) { sourceTableName = "Table"; isFirstTable = false; } else { sourceTableName = "Table" + ++counter; } mappingCollection.Add(sourceTableName, dataSetTableName); } return mappingCollection; }
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 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 virtual int DataTableFill(DataTable dataTable, CommandType commandType, string sql, ITableMapping tableMapping) { ValidateFillArguments(dataTable, sql, tableMapping); ITableMappingCollection mappingCollection = new DataTableMappingCollection(); mappingCollection.Add((object)tableMapping); return (int)Execute(new DataAdapterFillCallback(dataTable, commandType, sql, mappingCollection, null, null, null)); }
public void DataSetFillNoParams() { String sql = "select USER_ID, USER_NAME from USER_TABLE"; DataSet dataSet = new DataSet(); adoOperations.DataSetFill(dataSet, CommandType.Text, sql); Assert.AreEqual(1, dataSet.Tables.Count); Assert.AreEqual(18, dataSet.Tables["Table"].Rows.Count); dataSet = new DataSet(); adoOperations.DataSetFill(dataSet, CommandType.Text, sql, new string[] {"TestObjects"}); Assert.AreEqual(1, dataSet.Tables.Count); Assert.AreEqual(18, dataSet.Tables["TestObjects"].Rows.Count); dataSet = new DataSet(); DataTableMappingCollection mappingCollection = new DataTableMappingCollection(); DataTableMapping testObjectsMapping = mappingCollection.Add("Table", "TestObjects"); testObjectsMapping.ColumnMappings.Add("USER_ID", "UserID"); testObjectsMapping.ColumnMappings.Add("USER_NAME", "UserName"); adoOperations.DataSetFill(dataSet, CommandType.Text, sql, mappingCollection); Assert.AreEqual(1, dataSet.Tables.Count); Assert.AreEqual(18, dataSet.Tables["TestObjects"].Rows.Count); foreach (DataRow testObjectRow in dataSet.Tables["TestObjects"].Rows) { Assert.IsNotNull(testObjectRow["UserID"]); Assert.IsNotNull(testObjectRow["UserName"]); } }
public void FillDataSetNoParams() { PopulateTestObjectsTable(); string sql = ValidateTestObjects(4); DataSet dataSet; dataSet = new DataSet(); adoOperations.DataSetFill(dataSet, CommandType.Text, sql, new string[] {"TestObjects"}); Assert.AreEqual(1, dataSet.Tables.Count); Assert.AreEqual(4, dataSet.Tables["TestObjects"].Rows.Count); dataSet = new DataSet(); DataTableMappingCollection mappingCollection = new DataTableMappingCollection(); DataTableMapping testObjectsMapping = mappingCollection.Add("Table", "TestObjects"); testObjectsMapping.ColumnMappings.Add("TestObjectNo", "UserID"); testObjectsMapping.ColumnMappings.Add("Name", "UserName"); adoOperations.DataSetFill(dataSet, CommandType.Text, sql, mappingCollection); Assert.AreEqual(1, dataSet.Tables.Count); Assert.AreEqual(4, dataSet.Tables["TestObjects"].Rows.Count); foreach (DataRow testObjectRow in dataSet.Tables["TestObjects"].Rows) { Assert.IsNotNull(testObjectRow["UserID"]); Assert.IsNotNull(testObjectRow["Age"]); Assert.IsNotNull(testObjectRow["UserName"]); } }