LINQ to SQL：使用软删除过滤嵌套对象
我在我的数据库中使用软删除（
IsDeleted
AssociateWith
AssociateWith
DataLoadOptions loadOptions = new DataLoadOptions();
loadOption.LoadWith<User>(u = > u.Roles);
loadOption.AssociateWith<User>(u = > u.Roles.Where(r = > !r.IsDeleted));
Document
File
DataLoadOptions loadOptions = new DataLoadOptions();
loadOption.LoadWith<Document>(d = > d.File);
// the next certainly won't work
loadOption.AssociateWith<File>(f = > !f.IsDeleted);
没有找到相关结果
已邀请:
2 个回复
降女陷费券
// this may be a part of update method var file = document.File; if (file.IsDeleted) { // attach soft deleted file context.Files.Attach(file, true); // remove a file reference document.File = null; } // attach document entity and submit changes context.Documents.Attach(document, true); context.SubmitChanges();妒垮
这将为您提供null而不是IsDeleted为true的文件。