public static FluentSqlBuilder <OrderDataModel> SelectWithAlias15() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>("order_alias"); return(sqlBuilder); }
public static FluentSqlBuilder <OrderDataModel> SelectWithOrderByDescendingBy09() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .OrderByDescending(x => x.CustomerId); return(sqlBuilder); }
public static FluentSqlBuilder <OrderDataModel> SelectWithWhere05() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .Where(x => x.Status == OrderStatus.Paid && x.CustomerId == 1); return(sqlBuilder); }
public static FluentSqlBuilder <CustomerDataModel> SelectWithRightJoin04() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .RightJoin <CustomerDataModel>((order, customer) => order.CustomerId == customer.Id); return(sqlBuilder); }
public static FluentSqlBuilder <OrderDataModel> SelectWithDistinct17() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .Distinct(x => x.CustomerId); return(sqlBuilder); }
public static FluentSqlBuilder <OrderDataModel> SelectWithLimit13() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .Limit(10); return(sqlBuilder); }
public static FluentSqlBuilder <OrderDataModel> SelectWithProjection12() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .Projection(x => new { x.Id, x.Status }); return(sqlBuilder); }
public static FluentSqlBuilder <OrderDataModel> SelectWithPagination14() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .OrderBy(x => x.Id) .Pagination(10, 1); return(sqlBuilder); }
public static FluentSqlBuilder <OrderDataModel> SelectWithGroupBy10() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .Min(x => x.CustomerId) .GroupBy(x => x.CustomerId); return(sqlBuilder); }
public static FluentSqlBuilder <CustomerDataModel> SelectWithWhereAndInnerJoin07_02() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .Where(x => x.Status == OrderStatus.Paid && x.CustomerId == 1) .InnerJoin <CustomerDataModel>((order, customer) => order.CustomerId == customer.Id) .Where(x => x.Type == CustomerType.B2B); return(sqlBuilder); }
public static FluentSqlBuilder <OrderDataModel> SelectWithGroupByAndHaving11() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>() .Min(x => x.CustomerId) .GroupBy(x => x.CustomerId) .Having(SelectFunction.Min, x => x.CustomerId > 1); return(sqlBuilder); }
public static FluentSqlBuilder <CustomerDataModel> SelectWithFull16() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions) .From <OrderDataModel>("order_alias") .Projection((orderDataModel) => new { orderDataModel.CustomerId }, "order_alias") .Projection <CustomerDataModel>((customer) => customer, "customer_alias") .Where(x => x.Status == OrderStatus.Paid && x.CustomerId == 1) .InnerJoin <CustomerDataModel>((order, customer) => order.CustomerId == customer.Id, "customer_alias") .OrderBy(x => x.Id) .Limit(10); return(sqlBuilder); }
public static FluentSqlBuilder <OrderDataModel> SelectSimple01() { var sqlBuilder = new FluentSqlBuilderService(_fluentSqlBuilderMiddlewareOptions).From <OrderDataModel>(); return(sqlBuilder); }