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