MyDetail public Guid Id { get; set; } public bool IsDeleted{ get; set; }我想选择某些类别中的所有主记录,以及未标记为已删除的详细信息。基本上,我想运行这样简单的选择:inner join MyDetail d on m.Id = d.MasterId and d.IsDeleted= 0
where
MyDbContext context = new MyDbContext();Var list = Entities.ToList();// Those should be excluded 我以一种非常糟糕的方式做到了这一点:
varx.GetType().GetProperty("IsDeleted
这是我的LINQ查询。
var query = dbContext.Variations.Where(o => o.IsDeleted != true || ![IsDeleted] IS NULL OR ([v].[IsDeleted] IS NOT NULL AND ([v].[IsDeleted] = 0))) AND ((([v].[IsDeleted] <> 1) OR [v].[IsDeleted] IS NULL) OR