给你个简单的参考:
var query = dataContext.User.OrderByDescending(o => o.UserID).Take(10).Where(m=> m.IsChina == true);
你可以参考下如下例子:
using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace OrderOperation { public class Products { public int Id { get; set; } public int CategoryId { get; set; } public string Name { get; set; } public double Price { get; set; } public DateTime CreateTime { get; set; } } class Program { static void Main(string[] args) { // 初始化数据 List<Products> listProduct = new List<Products>() { new Products(){Id=1, CategoryId=1, Name="C#高级编程第10版", Price=100.67, CreateTime=DateTime.Now}, new Products(){Id=2, CategoryId=1, Name="Redis开发和运维", Price=69.9, CreateTime=DateTime.Now.AddDays(-19)}, new Products(){Id=3, CategoryId=1, Name="ASP.NET Core", Price=57, CreateTime=DateTime.Now.AddMonths(-3)}, new Products(){Id=4, CategoryId=1, Name="Entity Framework 6.x", Price=97, CreateTime=DateTime.Now.AddMonths(-1)} }; Console.WriteLine("方法语法"); // 1、查询方法,返回匿名类 var list = listProduct.OrderByDescending(p => p.CreateTime).Select(p => new { id = p.Id, ProductName = p.Name, ProductPrice = p.Price, PublishTime = p.CreateTime }).ToList(); foreach (var item in list) { Console.WriteLine("item:{0}", item); } Console.WriteLine("查询表达式"); // 2、查询表达式,返回匿名类 var listExpress = from p in listProduct orderby p.CreateTime descending select new { id = p.Id, ProductName = p.Name, ProductPrice = p.Price, PublishTime = p.CreateTime }; foreach (var item in listExpress) { Console.WriteLine("item:{0}", item); } Console.ReadKey(); } } }
给你个简单的参考:
你可以参考下如下例子: