LINQ Advanced Check:
String:
Fuzzy check (Included): Con.car.Where (r = r.name.contains (name)). ToList ();
Start with: Con.car.Where (r = R.name.startswith (name)). ToList ();
End With: Con.car.Where (r = R.name.endswith (name)). ToList ();
Numerical:
Number:. Count ()
Maximum value: Con.car.Max (r = r.price);
Minimum value: con.car.Min (r = r.price);
Average: con.car.Average (r = r.price);
Sum: Con.car.Sum (r = r.price);
Sort:
Ascending: Con.car.OrderBy (r = r.price). ToList ();
Descending: con.car.OrderByDescending (r = r.oil). ToList ();
Paging: Con.car.Skip (Count * (number-1)). Take (count). ToList ();
Combination query:
Intersection of sets
Example:
var all = con. Users.asenumerable ();//Query All
var unamelist = con. Users.where (r = R.username.contains (yonghuming. Text.trim ()));//fuzzy query user name
all = All.intersect (unamelist);//Query out the intersection, query the fuzzy user name of the data
Webform (LINQ Advanced Search, paging, combined query)