|
private Add ( |
||
| value | ||
| return | ||
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"]);
}
}
