给定以下模型
public class ApiImageModel
{
public int ID { get; set; }
...
public List<TagModel> Tags { get; set; } = new();
}
and
public class TagModel
{
public int ID { get; set; }
...
public string Name { get; set; }
public List<ApiImageModel> Images { get; set; } = new();
}
如何使用 Linq 基于给定的一组 TagModel 查询 ApiImageModel 列表?
我现在在这个问题上挣扎了一段时间,我当然错过了一些基本的东西,但我无法确定它。
我为 EF6 尝试过这种方法:EF6如何查询children包含列表所有值的位置 https://stackoverflow.com/questions/32004712/ef6-how-to-query-where-children-contains-all-values-of-a-list
像这样,将所有 TagModel-ID 保存在数组“tagIDs”中:
int[] tagIDs;
...
IQueryable<ApiImageModel> images = context.Images.Where(image => tagIDs.All(id => image.Tags.Any(tag => tag.ID == id)));
但视觉工作室奖励我一个“InvalidOperationException”:
The LINQ expression 'DbSet<ApiImageModel>()
.Where(a => __tagIDs_0
.All(id => DbSet<Dictionary<string, object>>("ApiImageModelTagModel")
.Where(a0 => EF.Property<Nullable<int>>(a, "ID") != null && object.Equals(
objA: (object)EF.Property<Nullable<int>>(a, "ID"),
objB: (object)EF.Property<Nullable<int>>(a0, "ImagesID")))
.Join(
inner: DbSet<TagModel>(),
outerKeySelector: a0 => EF.Property<Nullable<int>>(a0, "TagsID"),
innerKeySelector: t => EF.Property<Nullable<int>>(t, "ID"),
resultSelector: (a0, t) => new TransparentIdentifier<Dictionary<string, object>, TagModel>(
Outer = a0,
Inner = t
))
.Any(ti => ti.Inner.ID == id)))' could not be translated.
我很高兴获得一些帮助:)