private static void MySqlDbContextTest()
{
var result1 = StopwatchHelper.Caculate(100, () =>
{
using (MySqlTestDbContext db = new MySqlTestDbContext())
{
//for (int i = 1; i < 4; i++)
//{
// Student stu = new Student();
// stu.Age = i;
// stu.Name = $"monky-{i}";
// stu.GradeId = i;
// db.Add(stu);
//}
//var result = db.QueryOne<Student>(t => t.Name.Equals("monky-6"));
//result.Name = "monky-6";
//result.Age = 6;
//db.Update(t => t.Id == 109, result);
//var result = db.QueryCount<Student>(t => t.Name.Contains("1"));
//var result = db.QueryListPaging<Student>(3,3,t=>t.Age,t => t.Name.EndsWith("3"),true);
//var grades = db.QueryList<Grade2>(t => true);
var list = db.QueryList <Student>(t => t.Name.Contains("monky"));
//var student = db.QueryOne<Student>(t => true);
//Console.WriteLine(student.Name);
}
});
Console.WriteLine();
Console.WriteLine($"QueryOne 100 sec：{result1.TotalMilliseconds} ms");
}
private static void BankinateCacheTest()
{
int i = 0;
var result1 = StopwatchHelper.Caculate(100, () =>
{
using (var db = new MySqlTestDbContext())
{
Thread.Sleep(1000);
i++;
//Task.Run(() =>
//{
// db.AddAsync(new Student { Name = "jony-" + i });
//});
Console.WriteLine(i);
var c1 = db.QueryCount <Student>(t => t.Name.EndsWith("1"));
Console.WriteLine(db.IsFromCache);
var stu = db.QueryOne <Student>(t => t.Id == 205);
Console.WriteLine(db.IsFromCache);
var stu2 = db.QueryOne <Student>(t => t.Id == 206);
Console.WriteLine(db.IsFromCache);
var stu3 = db.QueryOne <Student>(t => t.Id == 207);
Console.WriteLine(db.IsFromCache);
var c2 = db.QueryCount <Student>(t => t.Name.EndsWith("2"));
Console.WriteLine(db.IsFromCache);
//var stu4 = db.QueryOne<Student>(t => t.Id == 207);
//Console.WriteLine(db.IsFromCache);
//var stu5 = db.QueryList<Student>(t => t.Name.StartsWith("monk"));
//Console.WriteLine(db.IsFromCache);
//var stu6 = db.QueryOne<Student>(t => t.Name.Contains("m"));
//Console.WriteLine(db.IsFromCache);
//var c3 = db.QueryCount<Student>(t => t.Name.EndsWith("3"));
//Console.WriteLine(db.IsFromCache);
//var stu7 = db.QueryOne<Student>(t => t.Name.Contains("k"));
//Console.WriteLine(db.IsFromCache);
//var list2 = db.QueryListPaging<Student>(1, 2, t => t.GradeId, true);
//Console.WriteLine("paging " + db.IsFromCache);
}
});
Console.WriteLine();
Console.WriteLine($"QueryOne {i} sec：{result1.TotalMilliseconds} ms");
}
