 | DapperDbHelperQueryMultipleTFirst, TSecond, TThird, TFour, TFive, TSix, TSenven 方法 (String, IListTFirst, IListTSecond, IListTThird, IListTFour, IListTFive, IListTSix, IListTSenven, Object, IDbTransaction, NullableInt32, NullableCommandType) |
Sweet 开发框架
7条Sql语句查询
命名空间:
Sweet.DBUtility.SQLServer
程序集:
Sweet.DBUtility.SQLServer (在 Sweet.DBUtility.SQLServer.dll 中) 版本:3.10.1.0 (3.10.1.0)
语法public static void QueryMultiple<TFirst, TSecond, TThird, TFour, TFive, TSix, TSenven>(
string sql,
out IList<TFirst> tfList,
out IList<TSecond> tsList,
out IList<TThird> ttList,
out IList<TFour> tfourList,
out IList<TFive> tfiveList,
out IList<TSix> tsixList,
out IList<TSenven> tsenvenList,
Object param = null,
IDbTransaction transaction = null,
int? commandTimeout = null,
CommandType? commandType = null
)
Public Shared Sub QueryMultiple(Of TFirst, TSecond, TThird, TFour, TFive, TSix, TSenven) (
sql As String,
<OutAttribute> ByRef tfList As IList(Of TFirst),
<OutAttribute> ByRef tsList As IList(Of TSecond),
<OutAttribute> ByRef ttList As IList(Of TThird),
<OutAttribute> ByRef tfourList As IList(Of TFour),
<OutAttribute> ByRef tfiveList As IList(Of TFive),
<OutAttribute> ByRef tsixList As IList(Of TSix),
<OutAttribute> ByRef tsenvenList As IList(Of TSenven),
Optional param As Object = Nothing,
Optional transaction As IDbTransaction = Nothing,
Optional commandTimeout As Integer? = Nothing,
Optional commandType As CommandType? = Nothing
)
static member QueryMultiple :
sql : string *
tfList : IList<'TFirst> byref *
tsList : IList<'TSecond> byref *
ttList : IList<'TThird> byref *
tfourList : IList<'TFour> byref *
tfiveList : IList<'TFive> byref *
tsixList : IList<'TSix> byref *
tsenvenList : IList<'TSenven> byref *
?param : Object *
?transaction : IDbTransaction *
?commandTimeout : Nullable<int> *
?commandType : Nullable<CommandType>
(* Defaults:
let _param = defaultArg param null
let _transaction = defaultArg transaction null
let _commandTimeout = defaultArg commandTimeout null
let _commandType = defaultArg commandType null
*)
-> unit
参数
- sql
- 类型:SystemString
7条查询语句 - tfList
- 类型:System.Collections.GenericIListTFirst
返回第一条语句的实体集合 - tsList
- 类型:System.Collections.GenericIListTSecond
返回第二条语句的实体集合 - ttList
- 类型:System.Collections.GenericIListTThird
返回第三条语句的实体集合 - tfourList
- 类型:System.Collections.GenericIListTFour
返回第四条语句的实体集合 - tfiveList
- 类型:System.Collections.GenericIListTFive
返回第五条语句的实体集合 - tsixList
- 类型:System.Collections.GenericIListTSix
返回第六条语句的实体集合 - tsenvenList
- 类型:System.Collections.GenericIListTSenven
返回第七条语句的实体集合 - param (Optional)
- 类型:SystemObject
参数值(可选) - transaction (Optional)
- 类型:System.DataIDbTransaction
事务名称(可选) - commandTimeout (Optional)
- 类型:SystemNullableInt32
超时时间(可选) - commandType (Optional)
- 类型:SystemNullableCommandType
指定如果解释sql字符串:语句/存储过程(可选)
类型参数
- TFirst
- 实体集合一
- TSecond
- 实体集合二
- TThird
- 实体集合三
- TFour
- 实体集合四
- TFive
- 实体集合五
- TSix
- 实体集合六
- TSenven
- 实体集合七
参见