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

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Data;
using Uninpho.DBOperation.Model;


namespace Uninpho.DBOperation.Operation
{
    public class Demo5_SqlQueryable
    {
        public static void Test()
        {
            Console.WriteLine("");
            Console.WriteLine("#### SqlQueryable Start ####");
            SqlSugarClient db = Config.GetPgClient();

           

            int total = 0;
            var list = db.SqlQueryable<User>("select * from \"user\"").ToPageList(1, 2, ref total);


            //by expression
            var list2 = db.SqlQueryable<User>("select * from \"user\"").Where(it => it.Id == 1).ToPageList(1, 2);
            //by sql
            var list3 = db.SqlQueryable<User>("select * from \"user\"").Where("id=@id", new { id = 1 }).ToPageList(1, 2);

            Console.WriteLine("#### SqlQueryable End ####");
        }
    }
}