/// <summary> /// 异步执行 SQL 语句,并返回两个实体集合 /// </summary> /// <param name="query1">SQL 命令</param> /// <param name="query2">SQL 命令</param> /// <param name="query3">SQL 命令</param> public override async Task <Tuple <List <T1>, List <T2>, List <T3> > > ExecuteMultipleAsync <T1, T2, T3>(IDbQueryable <T1> query1, IDbQueryable <T2> query2, IDbQueryable <T3> query3) { List <T1> q1 = null; List <T2> q2 = null; List <T3> q3 = null; IDataReader reader = null; List <Command> sqlList = query1.Provider.Resolve(new List <object> { query1, query2, query3 }); List <IMapping> maps = sqlList.ToList(x => x as IMapping, x => x is IMapping); TypeDeserializer deserializer1 = null; TypeDeserializer deserializer2 = null; TypeDeserializer deserializer3 = null; Func <DbCommand, Task <object> > doExecute = async cmd => { reader = await base.ExecuteReaderAsync(cmd); do { if (q1 == null) { deserializer1 = new TypeDeserializer(reader, maps.Count > 0 ? maps[0] : null); q1 = deserializer1.Deserialize <T1>(); } else if (q2 == null) { deserializer2 = new TypeDeserializer(reader, maps.Count > 1 ? maps[1] : null); q2 = deserializer2.Deserialize <T2>(); } else if (q3 == null) { deserializer3 = new TypeDeserializer(reader, maps.Count > 2 ? maps[2] : null); q3 = deserializer3.Deserialize <T3>(); } }while (reader.NextResult()); // 释放当前的reader if (reader != null) { reader.Dispose(); } return(null); }; try { await base.DoExecuteAsync <object>(sqlList, doExecute); return(new Tuple <List <T1>, List <T2>, List <T3> >(q1, q2, q3)); } finally { if (reader != null) { reader.Dispose(); } } }
// 执行SQL 语句,并返回 <see cref="IEnumerable"/> 对象 List <T> ExecuteList <T>(IDbCommand cmd, DbCommandDefinition_Select definition) { IDataReader reader = null; List <T> objList = new List <T>(); try { reader = this.ExecuteReader(cmd); TypeDeserializer deserializer = new TypeDeserializer(reader, definition); objList = deserializer.Deserialize <T>(); } finally { if (reader != null) { reader.Dispose(); } if (cmd != null) { cmd.Dispose(); } this.InternalDispose(); } return(objList); }
// 执行SQL 语句,并返回 <see cref="IEnumerable"/> 对象 List <T> ExecuteList <T>(IDbCommand command, IMapping map) { IDataReader reader = null; List <T> objList = new List <T>(); try { reader = this.ExecuteReader(command); TypeDeserializer deserializer = new TypeDeserializer(reader, map); objList = deserializer.Deserialize <T>(); } finally { if (reader != null) { reader.Dispose(); } if (command != null) { command.Dispose(); } this.InternalDispose(); } return(objList); }
/// <summary> /// 执行 SQL 语句,并返回两个实体集合 /// </summary> /// <param name="query1">SQL 命令</param> /// <param name="query2">SQL 命令</param> /// <param name="query3">SQL 命令</param> /// <param name="trans">事务对象</param> public override Tuple <List <T1>, List <T2>, List <T3> > ExecuteMultiple <T1, T2, T3>(IDbQueryable <T1> query1, IDbQueryable <T2> query2, IDbQueryable <T3> query3) { List <T1> q1 = null; List <T2> q2 = null; List <T3> q3 = null; IDataReader reader = null; List <DbCommandDefinition> sqlList = query1.Provider.Resolve(new List <object> { query1, query2, query3 }); List <DbCommandDefinition_Select> defines = sqlList.ToList(x => x as DbCommandDefinition_Select, x => x is DbCommandDefinition_Select); TypeDeserializer deserializer1 = null; TypeDeserializer deserializer2 = null; TypeDeserializer deserializer3 = null; Func <IDbCommand, object> doExecute = cmd => { reader = base.ExecuteReader(cmd); do { if (q1 == null) { deserializer1 = new TypeDeserializer(reader, defines.Count > 0 ? defines[0] : null); q1 = deserializer1.Deserialize <T1>(); } else if (q2 == null) { deserializer2 = new TypeDeserializer(reader, defines.Count > 1 ? defines[1] : null); q2 = deserializer2.Deserialize <T2>(); } else if (q3 == null) { deserializer3 = new TypeDeserializer(reader, defines.Count > 2 ? defines[2] : null); q3 = deserializer3.Deserialize <T3>(); } }while (reader.NextResult()); // 释放当前的reader if (reader != null) { reader.Dispose(); } return(null); }; try { base.DoExecute <object>(sqlList, doExecute); return(new Tuple <List <T1>, List <T2>, List <T3> >(q1, q2, q3)); } finally { if (reader != null) { reader.Dispose(); } } }
/// <summary> /// 计算要插入、更新或删除的已修改对象的集,并执行相应命令以实现对数据库的更改 /// </summary> /// <returns></returns> public virtual 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 (autoIncrements != null && autoIncrements.Count > 0) { if (identitys == null) { identitys = new List <int>(); } identitys.AddRange(autoIncrements); } }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(); } }
/// <summary> /// 计算要插入、更新或删除的已修改对象的集,并执行相应命令以实现对数据库的更改 /// </summary> /// <returns></returns> public virtual 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 this.Database.ExecuteReaderAsync(cmd); TypeDeserializer deserializer = new TypeDeserializer(this.Database, reader, null); do { List <int> result = null; deserializer.Deserialize <int>(out result); if (result != null && result.Count > 0) { identitys.AddRange(result); } }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> public async Task <List <T> > DeserializeAsync <T>() { bool isThisLine = false; object prevLine = null; List <T> collection = new List <T>(); TypeDeserializer <T> deserializer = new TypeDeserializer <T>(_reader, _map); while (await(_reader as DbDataReader).ReadAsync()) { T model = deserializer.Deserialize(prevLine, out isThisLine); if (!isThisLine) { collection.Add(model); prevLine = model; } } // 返回结果 return(collection); }
/// <summary> /// 反序列化实体集合 /// <para> /// 适用于单一结果集的场景 /// </para> /// </summary> public List <T> Deserialize <T>() { bool isThisLine = false; object prevLine = null; List <T> collection = new List <T>(); TypeDeserializer <T> deserializer = new TypeDeserializer <T>(_reader, _map); while (_reader.Read()) { T model = deserializer.Deserialize(prevLine, out isThisLine); if (!isThisLine) { collection.Add(model); prevLine = model; } } // 返回结果 return(collection); }
// datareader 转实体 T GetResult <T>(IDataReader reader, IMapping map) { T result = default(T); if (typeof(T) == typeof(DataTable)) { DataTable table = new DataTable(); table.Load(reader); result = (T)(object)table; } else if (typeof(T) == typeof(DataSet)) { InternalDataSet data = new InternalDataSet(); data.Load(reader, LoadOption.OverwriteChanges, null, new DataTable[] { }); result = (T)(object)data; } else { TypeDeserializer deserializer = new TypeDeserializer(this, reader, map); result = deserializer.Deserialize <T>(); } return(result); }
// 执行SQL 语句,并返回单个实体对象 T Execute <T>(IDbCommand cmd, DbCommandDefinition_Select definition) { IDataReader reader = null; try { reader = this.ExecuteReader(cmd); TypeDeserializer deserializer = new TypeDeserializer(reader, definition); List <T> result = deserializer.Deserialize <T>(); return(result.FirstOrDefault()); } finally { if (cmd != null) { cmd.Dispose(); } if (reader != null) { reader.Dispose(); } this.InternalDispose(); } }
// 执行SQL 语句,并返回单个实体对象 protected virtual T Execute <T>(IDbCommand command, IMapper map) { IDataReader reader = null; try { reader = this.ExecuteReader(command); TypeDeserializer deserializer = new TypeDeserializer(this, reader, map); List <T> result = deserializer.Deserialize <T>(); return(result.FirstOrDefault()); } finally { if (command != null) { command.Dispose(); } if (reader != null) { reader.Dispose(); } this.InternalDispose(); } }
/// <summary> /// 计算要插入、更新或删除的已修改对象的集,并执行相应命令以实现对数据库的更改 /// </summary> /// <typeparam name="T">T</typeparam> /// <param name="result">提交更改并查询数据</param> /// <returns></returns> public virtual int SubmitChanges <T>(out List <T> result) { result = new List <T>(); int rowCount = _dbQueryables.Count; if (rowCount == 0) { return(0); } List <T> q1 = null; IDataReader reader = null; List <int> identitys = null; List <RawCommand> sqlList = this.Resolve(); Func <IDbCommand, object> doExecute = cmd => { reader = this.Database.ExecuteReader(cmd); TypeDeserializer deserializer = new TypeDeserializer(this.Database, reader, null); do { List <int> autoIncrements = null; var collection = deserializer.Deserialize <T>(out autoIncrements); if (autoIncrements != null) { if (identitys == null) { identitys = new List <int>(); } identitys.AddRange(autoIncrements); } else if (collection != null) { if (q1 == null) { q1 = collection; } } }while (reader.NextResult()); // 释放当前的reader if (reader != null) { reader.Dispose(); } return(null); }; try { this.Database.Execute <object>(sqlList, doExecute); result = q1 ?? new List <T>(0); this.SetIdentityValue(_dbQueryables, identitys); return(rowCount); } finally { if (reader != null) { reader.Dispose(); } this.InternalDispose(); } }
// 执行 SQL 语句,并返回多个实体集合 protected override async Task <Tuple <List <T1>, List <T2>, List <T3>, List <T4>, List <T5>, List <T6>, List <T7> > > ExecuteMultipleAsync <T1, T2, T3, T4, T5, T6, T7>(IDbCommand command, List <IMapping> maps = null) { List <T1> q1 = null; List <T2> q2 = null; List <T3> q3 = null; List <T4> q4 = null; List <T5> q5 = null; List <T6> q6 = null; List <T7> q7 = null; IDataReader reader = null; List <Command> myList = this.TrySeparate(command.CommandText, command.Parameters, command.CommandType); if (myList == null) { q1 = await this.ExecuteListAsync <T1>(command, maps != null && maps.Count > 0?maps[0] : null); } else { TypeDeserializer deserializer1 = null; TypeDeserializer deserializer2 = null; TypeDeserializer deserializer3 = null; TypeDeserializer deserializer4 = null; TypeDeserializer deserializer5 = null; TypeDeserializer deserializer6 = null; TypeDeserializer deserializer7 = null; Func <IDbCommand, Task <object> > doExecute = async cmd => { reader = await base.ExecuteReaderAsync(cmd); do { if (q1 == null) { deserializer1 = new TypeDeserializer(this, reader, maps != null && maps.Count > 0 ? maps[0] : null); q1 = deserializer1.Deserialize <T1>(); } else if (q2 == null) { deserializer2 = new TypeDeserializer(this, reader, maps != null && maps.Count > 1 ? maps[1] : null); q2 = deserializer2.Deserialize <T2>(); } else if (q3 == null) { deserializer3 = new TypeDeserializer(this, reader, maps != null && maps.Count > 2 ? maps[2] : null); q3 = deserializer3.Deserialize <T3>(); } else if (q4 == null) { deserializer4 = new TypeDeserializer(this, reader, maps != null && maps.Count > 3 ? maps[3] : null); q4 = deserializer4.Deserialize <T4>(); } else if (q5 == null) { deserializer5 = new TypeDeserializer(this, reader, maps != null && maps.Count > 4 ? maps[4] : null); q5 = deserializer5.Deserialize <T5>(); } else if (q6 == null) { deserializer6 = new TypeDeserializer(this, reader, maps != null && maps.Count > 5 ? maps[5] : null); q6 = deserializer6.Deserialize <T6>(); } else if (q7 == null) { deserializer7 = new TypeDeserializer(this, reader, maps != null && maps.Count > 6 ? maps[6] : null); q7 = deserializer7.Deserialize <T7>(); } }while (reader.NextResult()); // 释放当前的reader if (reader != null) { reader.Dispose(); } return(null); }; try { await base.DoExecuteAsync <object>(myList, doExecute); } finally { if (reader != null) { reader.Dispose(); } } } return(new Tuple <List <T1>, List <T2>, List <T3>, List <T4>, List <T5>, List <T6>, List <T7> >( q1 ?? new List <T1>(), q2 ?? new List <T2>(), q3 ?? new List <T3>(), q4 ?? new List <T4>(), q5 ?? new List <T5>(), q6 ?? new List <T6>(), q7 ?? new List <T7>())); }