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);
}
