jiance-analysis/Uninpho.DBOperation/Operation/Demo1_Queryable.cs

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<User>().ToList();
            var getOrderBy = db.Queryable<User>().OrderBy(it => it.Name, OrderByType.Desc).ToList();
            var getOrderBy2 = db.Queryable<User>().OrderBy(it => it.Id).OrderBy(it => it.Name, OrderByType.Desc).ToList();
            var getOrderBy3 = db.Queryable<User>().OrderBy(it => new { it.Name, it.Id }).ToList();
            var getRandom = db.Queryable<User>().OrderBy(it => SqlFunc.GetRandom()).First();
            var getByPrimaryKey = db.Queryable<User>().InSingle(2);
            var getSingleOrDefault = db.Queryable<User>().Where(it => it.Id == 1).Single();
            var getFirstOrDefault = db.Queryable<User>().First();
            var getByWhere = db.Queryable<User>().Where(it => it.Id == 1 || it.Name == "a").ToList();
            var getByWhere2 = db.Queryable<User>().Where(it => it.Id == DateTime.Now.Year).ToList();
            var getByFuns = db.Queryable<User>().Where(it => SqlFunc.IsNullOrEmpty(it.Name)).ToList();
            var getByFuns2 = db.Queryable<User>().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<User> list = db.Queryable<User>().ToList();

            User item = db.Queryable<User>().First(it => it.Id == 1);

            DataTable dataTable = db.Queryable<User>().Select(it => it.Id).ToDataTable();

            var json = db.Queryable<User>().ToJson();

            List<int> listInt = db.Queryable<User>().Select(it => it.Id).ToList();

            var dynamic = db.Queryable<User>().Select<dynamic>().ToList();


        }

    }
}