/// <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(); } }