public static void Init() { Console.WriteLine(""); Console.WriteLine("#### Queue Start ####"); SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { DbType = DbType.SqlServer, ConnectionString = Config.ConnectionString, InitKeyType = InitKeyType.Attribute, IsAutoCloseConnection = true, AopEvents = new AopEvents { OnLogExecuting = (sql, p) => { Console.WriteLine(sql); Console.WriteLine(string.Join(",", p?.Select(it => it.ParameterName + ":" + it.Value))); } } }); db.Insertable <Order>(new Order() { Name = "a" }).AddQueue(); db.Insertable <Order>(new Order() { Name = "b" }).AddQueue(); db.SaveQueues(); db.Insertable <Order>(new Order() { Name = "a" }).AddQueue(); db.Insertable <Order>(new Order() { Name = "b" }).AddQueue(); db.Insertable <Order>(new Order() { Name = "c" }).AddQueue(); db.Insertable <Order>(new Order() { Name = "d" }).AddQueue(); var ar = db.SaveQueuesAsync(); ar.Wait(); db.Queryable <Order>().AddQueue(); db.Queryable <Order>().AddQueue(); db.AddQueue("select * from [Order] where id=@id", new { id = 10000 }); db.AddQueue("select id=@id+1", new { id = 10000 }); var result2 = db.SaveQueues <Order, Order, Order>(); Console.WriteLine("#### Queue End ####"); }
/// <summary> /// sql增删改 /// </summary> /// <param name="sql"></param> public virtual void SqlAddDelUp(string sql) { Db.AddQueue(sql); }