using SqlSugar; using System; using System.Collections.Generic; using System.Data; using Uninpho.DBOperation.Model; namespace Uninpho.DBOperation.Operation { public class Demo1_Queryable { public static void Test1() { Console.WriteLine(""); Console.WriteLine("#### Examples Start ####"); var db = Config.GetPgClient(); var dbTime = db.GetDate(); var getAll = db.Queryable().ToList(); var getOrderBy = db.Queryable().OrderBy(it => it.Name, OrderByType.Desc).ToList(); var getOrderBy2 = db.Queryable().OrderBy(it => it.Id).OrderBy(it => it.Name, OrderByType.Desc).ToList(); var getOrderBy3 = db.Queryable().OrderBy(it => new { it.Name, it.Id }).ToList(); var getRandom = db.Queryable().OrderBy(it => SqlFunc.GetRandom()).First(); var getByPrimaryKey = db.Queryable().InSingle(2); var getSingleOrDefault = db.Queryable().Where(it => it.Id == 1).Single(); var getFirstOrDefault = db.Queryable().First(); var getByWhere = db.Queryable().Where(it => it.Id == 1 || it.Name == "a").ToList(); var getByWhere2 = db.Queryable().Where(it => it.Id == DateTime.Now.Year).ToList(); var getByFuns = db.Queryable().Where(it => SqlFunc.IsNullOrEmpty(it.Name)).ToList(); var getByFuns2 = db.Queryable().GroupBy(it => it.Name).Select(it => SqlFunc.AggregateDistinctCount(it.Price)).ToList(); Console.WriteLine("#### Examples End ####"); } public static void Test2() { Console.WriteLine(""); Console.WriteLine("#### ReturnType Start ####"); var db = Config.GetPgClient(); List list = db.Queryable().ToList(); User item = db.Queryable().First(it => it.Id == 1); DataTable dataTable = db.Queryable().Select(it => it.Id).ToDataTable(); var json = db.Queryable().ToJson(); List listInt = db.Queryable().Select(it => it.Id).ToList(); var dynamic = db.Queryable().Select().ToList(); } } }