/// <summary>
/// 计算要插入、更新或删除的已修改对象的集，并执行相应命令以实现对数据库的更改
/// </summary>
/// <returns></returns>
public override async Task <int> SubmitChangesAsync()
{
int rowCount = _dbQueryables.Count;
if (rowCount == 0)
{
return(0);
}
List <Command> sqlList = this.Provider.Resolve(_dbQueryables);
List <int> identitys = new List <int>();
IDataReader reader = null;
try
{
Func <IDbCommand, Task <object> > func = async cmd =>
{
reader = await base.Database.ExecuteReaderAsync(cmd);
TypeDeserializer deserializer = new TypeDeserializer(this.Database, reader, null);
do
{
var result = deserializer.Deserialize <int>();
foreach (IDbDataParameter p in cmd.Parameters)
{
if (p.Direction != ParameterDirection.Output)
{
continue;
}
identitys.Add(Convert.ToInt32(p.Value));
}
}while (reader.NextResult());
// 释放当前的reader
if (reader != null)
{
reader.Dispose();
}
return(null);
};
await this.Database.ExecuteAsync <object>(sqlList, func);
this.SetAutoIncrementValue(_dbQueryables, identitys);
return(rowCount);
}
finally
{
if (reader != null)
{
reader.Dispose();
}
this.InternalDispose();
}
}
/// <summary>
/// 计算要插入、更新或删除的已修改对象的集，并执行相应命令以实现对数据库的更改
/// </summary>
/// <returns></returns>
public override int SubmitChanges()
{
int rowCount = _dbQueryables.Count;
if (rowCount == 0)
{
return(0);
}
IDataReader reader = null;
List <int> identitys = null;
List <Command> sqlList = this.Provider.Resolve(_dbQueryables);
Func <IDbCommand, object> doExecute = cmd =>
{
reader = this.Database.ExecuteReader(cmd);
TypeDeserializer deserializer = new TypeDeserializer(this.Database, reader, null);
do
{
List <int> autoIncrements = null;
deserializer.Deserialize <object>(out autoIncrements);
if (cmd.Parameters != null)
{
foreach (IDbDataParameter p in cmd.Parameters)
{
if (p.Direction != ParameterDirection.Output)
{
continue;
}
if (identitys == null)
{
identitys = new List <int>();
}
identitys.Add(Convert.ToInt32(p.Value));
}
}
}while (reader.NextResult());
// 释放当前的reader
if (reader != null)
{
reader.Dispose();
}
return(null);
};
try
{
this.Database.Execute <object>(sqlList, doExecute);
this.SetAutoIncrementValue(_dbQueryables, identitys);
return(rowCount);
}
finally
{
if (reader != null)
{
reader.Dispose();
}
this.InternalDispose();
}
}
