/// <summary>
/// 拉姆达测试
/// </summary>
/// <param name="p"></param>
/// <param name="db"></param>
private void Exp(Student2 p, SqlSugarClient db)
{
//解析拉姆达各种情况组合
//基本
var t1 = db.Queryable<Student>().Where(it => it.id == 1).ToList();
var t2 = db.Queryable<Student>().Where(it => it.id == p.id).ToList();
var t3 = db.Queryable<Student>().Where(it => it.id == _p.id).ToList();
var t4 = db.Queryable<Student>().Where(it => it.id == Getp().id).ToList();
var t5 = db.Queryable<Student>().Where(it => it.id == MyCost.p.id).ToList();
//BOOL
var t11 = db.Queryable<Student2>("Student").Where(it => it.isOk).ToList();
var t21 = db.Queryable<Student2>("Student").Where(it => it.isOk == MyCost.p.isOk).ToList();
var t31 = db.Queryable<Student2>("Student").Where(it => !it.isOk).ToList();
var t41 = db.Queryable<Student2>("Student").Where(it => it.isOk == true).ToList();
var t51 = db.Queryable<Student2>("Student").Where(it => it.isOk == false).ToList();
var t61 = db.Queryable<Student2>("Student").Where(it => it.isOk == _p.isOk).ToList();
var t71 = db.Queryable<Student2>("Student").Where(it => !it.isOk && !p.isOk == it.isOk).ToList();
var t91 = db.Queryable<Student2>("Student").Where(it => _p.isOk == false).ToList();
var t81 = db.Queryable<Student>().Where(it => it.isOk == false).ToList();
var t111 = db.Queryable<Student2>("Student").Where(it => it.isOk && false).ToList();
//length
var c1 = db.Queryable<Student>().Where(c => c.name.Length > 4).ToList();
var c2 = db.Queryable<Student>().Where(c => c.name.Length > _p.name.Length).ToList();
var c3 = db.Queryable<Student>().Where(c => c.name.Length > "aa".Length).ToList();
var c4 = db.Queryable<Student>().Where(c => c.name.Length > Getp().id).ToList();
//Equals
var a1 = db.Queryable<Student>().Where(c => c.name.Equals(null)).ToList();
var x = new InsertTest() { };
var x1 = db.Queryable<Student>().Where(c => c.name.Equals(x.int1)).ToList();
var a2 = db.Queryable<Student>().Where(c => c.name.Equals(p.name)).ToList();
var a4 = db.Queryable<Student>().Where(c => c.name.Equals(Getp().name)).ToList();
//Contains
var s = db.Queryable<Student>().Where(c => c.name.Contains(null)).ToList();
var s0 = new InsertTest() { };
var s1 = db.Queryable<Student>().Where(c => c.name.Contains(x.v1)).ToList();
var s3 = db.Queryable<Student>().Where(c => c.name.Contains(p.name)).ToList();
var s4 = db.Queryable<Student>().Where(c => c.name.Contains(Getp().name)).ToList();
var s5 = db.Queryable<Student>().Where(c => c.name.StartsWith(Getp().name)).ToList();
var s6 = db.Queryable<Student>().Where(c => c.name.EndsWith(Getp().name)).ToList();
//异常处理测试,防止程序中出现未知错误
try
{
var e6 = db.Queryable<Student>().Where(c => Getp().name.StartsWith(c.name)).ToList();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
try
{
var e6 = db.Queryable<Student>().Where(c => Getp().name.Equals(c.name)).ToList();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
try
{
var e6 = db.Queryable<Student>().Where(c => c.name.First() != null).ToList();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
//组合测试
var z = db.Queryable<Student>().Where(c => (c.name.Equals(Getp().name) || c.name == p.name) && true && c.id > 1).ToList();
var z23 = db.Queryable<Student>().Where(c => !string.IsNullOrEmpty(c.name) || (c.id == 1 || c.name.Contains(p.name))).ToList();
var z2 = db.Queryable<Student>().Where(c => !string.IsNullOrEmpty(c.name) || !string.IsNullOrEmpty(c.name)).ToList();
}
