SunnyUI.SqlSugar 5.1.4.66

class Program
    {
        static void Main(string[] args)
        {
            //创建连接
            DAL.InitSqlite("Test.db");

            //显示日志
            DAL.WriteLogToConsole = true;

            //判断连接状态
            Console.WriteLine("Connection state: " + DAL.Connected);
            if (!DAL.Connected)
            {
                //创建数据库
                DAL.CreateDatabase();
            }

            Test();

            Console.WriteLine("按任意键退出。");
            Console.ReadKey();
        }

        private static async void Test()
        {
            //更新连接状态（InitMySql 和 CreateDatabase 会自动调用）
            Console.WriteLine("Connection state: " + DAL.Connected);

            if (DAL.Connected)
            {
                //创建数据表
                DAL.CreateTable<NewTable>();

                //生成数据表实体类
                DAL.CreateClassFile("C:\\", "DBAuth");

                //调用 DAL.Client（SqlSugarClient）处理数据
                DAL.Client.Queryable<NewTable>().ToList();

                //Console.Clear();

                Console.WriteLine(DAL.DeleteAll<NewTable>());

                //根据主键获取对象
                NewTable test = DAL.Queryable<NewTable>(2);
                if (test == null)
                {
                    test = new NewTable();
                }

                var t = await test.InsertAsync();

                Console.WriteLine(DAL.DeleteAll<NewTable>());

                test.fvcName = "ddddd";
                Console.WriteLine(test.Upsert());

                var list = DAL.GetSimpleClient<NewTable>().GetList();
                Console.WriteLine(list.Count);
                Console.WriteLine(DAL.Count<NewTable>());
                //根据主键删除对象
                DAL.Deleteable<NewTable>(2);
            }
        }
    }