Esempio n. 1
0
 /// <summary>
 ///  查询方法,设定查询返回的行数
 /// </summary>
 /// <typeparam name="TModel"></typeparam>
 /// <param name="query"></param>
 /// <param name="topNum">行数</param>
 /// <returns>查询构造器,后面可接其它查询构造器方法</returns>
 public static SelectQuery <TModel> Top <TModel>(this SelectQuery <TModel> query, int topNum)
 {
     query.SqlBuilder.AddTop(topNum);
     return(query);
 }
Esempio n. 2
0
 /// <summary>
 /// 执行,立即返回查询中的第一行实体数据,如果没有查询到则返回为空
 /// </summary>
 /// <typeparam name="TModel"></typeparam>
 /// <param name="query"></param>
 /// <returns></returns>
 public static TModel First <TModel>(this SelectQuery <TModel> query)
 {
     return(First(query, null));
 }
Esempio n. 3
0
 /// <summary>
 /// 条件查询
 /// </summary>
 /// <typeparam name="TModel"></typeparam>
 /// <param name="query"></param>
 /// <param name="whereExpression">条件表达式</param>
 /// <returns>查询构造器,后面可接其它查询构造器方法</returns>
 public static SelectQuery <TModel> Where <TModel>(this SelectQuery <TModel> query, Expression <Func <TModel, bool> > whereExpression)
 {
     return(And(query, whereExpression));
 }