/// <summary>
/// 执行带匿名参数的 SQL 查询，并返回查询结果
/// </summary>
/// <typeparam name="T">返回类型</typeparam>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="values">参数值列表</param>
public static IEnumerable <T> Find <T>(this ISession session, string sql, IList <object> values)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql, values.ToArray());
return(session.Provider.Find <T>(builder));
}
/// <summary>
/// 执行带命名参数的 SQL 查询，并返回查询结果
/// </summary>
/// <typeparam name="T">返回类型</typeparam>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="parameters">参数列表</param>
public static IEnumerable <T> Find <T>(this ISession session, string sql, IDictionary <string, object> parameters)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql, parameters);
return(session.Provider.Find <T>(builder));
}
/// <summary>
/// 执行带命令参数的分页查询，并返回分页查询结果
/// </summary>
/// <returns>分页查询结果</returns>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页大小</param>
/// <param name="orderBy">排序字段</param>
/// <param name="parameters">参数列表</param>
public static DataPage ExecuteDataPage(this ISession session, string sql, int pageIndex, int pageSize, string orderBy, IDictionary <string, object> parameters)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql, parameters);
return(session.Provider.ExecuteDataPage(builder, pageIndex, pageSize, orderBy));
}
/// <summary>
/// 执行带匿名参数的 SQL 查询，并返回查询结果
/// </summary>
/// <typeparam name="T">返回类型</typeparam>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="values">参数值列表</param>
public static IEnumerable <T> Find <T>(this ISession session, string sql, params object[] values)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql, values);
return(session.Provider.Find <T>(builder));
}
/// <summary>
/// 执行分页查询，并返回分页查询结果
/// </summary>
/// <returns>分页查询结果</returns>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页大小</param>
/// <param name="orderBy">排序字段</param>
public static DataPage ExecuteDataPage(this ISession session, string sql, int pageIndex, int pageSize, string orderBy)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql);
return(session.Provider.ExecuteDataPage(builder, pageIndex, pageSize, orderBy));
}
/// <summary>
/// 执行带匿名参数的分页查询，并返回分页查询结果
/// </summary>
/// <returns>分页查询结果</returns>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页大小</param>
/// <param name="orderBy">排序字段</param>
/// <param name="values">参数值列表</param>
public static DataPage ExecuteDataPage(this ISession session, string sql, int pageIndex, int pageSize, string orderBy, IList <object> values)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql, values.ToArray());
return(session.Provider.ExecuteDataPage(builder, pageIndex, pageSize, orderBy));
}
/// <summary>
/// 执行带匿名参数的非查询 SQL 语句，返回受影响的行数
/// </summary>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="values">参数值列表</param>
/// <returns>受影响的行数</returns>
public static int ExecuteNonQuery(this ISession session, string sql, IList <object> values)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql, values.ToArray());
return(session.Provider.ExecuteNonQuery(builder));
}
/// <summary>
/// 执行带命名参数的非查询 SQL 语句，返回受影响的行数
/// </summary>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="parameters">参数列表</param>
/// <returns>受影响的行数</returns>
public static int ExecuteNonQuery(this ISession session, string sql, IDictionary <string, object> parameters)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql, parameters);
return(session.Provider.ExecuteNonQuery(builder));
}
/// <summary>
/// 执行带匿名参数的非查询 SQL 语句，返回受影响的行数
/// </summary>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="values">参数值列表</param>
/// <returns>受影响的行数</returns>
public static int ExecuteNonQuery(this ISession session, string sql, params object[] values)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql, values);
return(session.Provider.ExecuteNonQuery(builder));
}
/// <summary>
/// 执行非查询 SQL 语句，返回受影响的行数
/// </summary>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <returns>受影响的行数</returns>
public static int ExecuteNonQuery(this ISession session, string sql)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql);
return(session.Provider.ExecuteNonQuery(builder));
}
/// <summary>
/// 执行 SQL 语句，返回一个 DataSet 对象
/// </summary>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <returns>DataSet 对象</returns>
public static DataSet ExecuteDataSet(this ISession session, string sql)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql);
return(session.Provider.ExecuteDataSet(builder));
}
/// <summary>
/// 执行带匿名参数 SQL 语句，返回一个 DataTable 对象
/// </summary>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <param name="values">参数值列表</param>
/// <returns>DataTable 对象</returns>
public static DataTable ExecuteDataTable(this ISession session, string sql, params object[] values)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql, values);
return(session.Provider.ExecuteDataTable(builder));
}
/// <summary>
/// 执行 SQL 语句，返回查询结果中的第一行第一列的值
/// </summary>
/// <param name="session">session</param>
/// <param name="sql">SQL 语句</param>
/// <returns>查询结果中的第一行第一列的值</returns>
public static T ExecuteScalar <T>(this ISession session, string sql)
{
CommandBuilder builder = session.ConvertToCommandBuilder(sql);
return(session.Provider.ExecuteScalar <T>(builder));
}
