select top(20) p.Id, p.Name from Product p inner join ProjectProduct j on p.Id=j.ProductId and j.ProjectId ='1' order by p.Id desc
public class Project { public int Id { get; set; } public string Name { get; set; } public List<Product> Product { get; set; } } public class Product { public int Id { get; set; } public string Name { get; set; } public List<Project> Project { get; set; } } public class ProjectProduct { public int ProjectId { get; set; } public int ProductId { get; set; } }
var products = await _ctx.Project .Where(p => p.Id == id) .Select ( p => p.Product ) .FirstOrDefaultAsync();
var products = await _ctx.Project .Where(p => p.Id == id) .SelectMany(p => p.Product) .OrderByDescending(p => p.Id) .Take(20) .ToListAsync();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)