消除 LINQ 查询之间的冗余

发布于 2024-11-01 18:16:54 字数 1145 浏览 1 评论 0原文

我需要多次调用相同的 LINQ 查询，这些查询仅在“where”子句中具有不同的元素。我不想一遍又一遍地重复 LINQ 查询，而是想将元素传递到单个查询中，但我对如何执行此操作感到困惑。

现在，我的基本 LINQ 查询如下所示：

return from a in _repository.GetApps()
                       join set in _repository.GetSettings() on a.id equals set.application_id
                       join type in _repository.GetSettingsTypes() on set.setting_type_id equals type.id
                       join ent in _repository.GetEntities() on a.entity_id equals ent.id
                       where ent.ROW_ID == app && set.application_id == id && (set.setting_type_id==81 || set.setting_type_id==82 || set.setting_type_id==83)
                       orderby set.application_id, type.ordinal
                       select new Settings { app_name = a.name, data_type = type.data_type, setting_name = type.name, setting_description = type.description, setting_value = set.setting_value, entity_name = ent.name, entity_num = ent.ROW_ID };

“where”子句仅按 ID 列出设置类型。其他调用将简单地用更多或更少的设置 ID 替换“where”子句，然后返回到视图。如何动态替换“where”子句或设置 ID？我可以简单地将字符串或数组分配给第二个“&&”后面的设置列表吗（这似乎不起作用）？或者 Lambda 会在这里提供帮助吗（我也无法让它发挥作用）？谢谢！

原文

I need to call identical LINQ queries multiple times that only have differing elements in the "where" clause. Instead of repeating the LINQ query over and over again, I'd like to pass the elements into a single query instead, but I'm brain stuttering on how to do that.

Right now my base LINQ query looks like this:

return from a in _repository.GetApps()
                       join set in _repository.GetSettings() on a.id equals set.application_id
                       join type in _repository.GetSettingsTypes() on set.setting_type_id equals type.id
                       join ent in _repository.GetEntities() on a.entity_id equals ent.id
                       where ent.ROW_ID == app && set.application_id == id && (set.setting_type_id==81 || set.setting_type_id==82 || set.setting_type_id==83)
                       orderby set.application_id, type.ordinal
                       select new Settings { app_name = a.name, data_type = type.data_type, setting_name = type.name, setting_description = type.description, setting_value = set.setting_value, entity_name = ent.name, entity_num = ent.ROW_ID };

The "where" clause just lists setting types by IDs. The other calls will simply replace that "where" clause with more or fewer setting ids which then get returned to a view. How can I dynamically replace that "where" clause or the setting ids? Can I simply assign a string or array to the setting list following the second "&&" (this didn't seem to work)? Or would Lambdas help here (I also couldn't get that to work)? Thanks!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

月竹挽风 2024-11-08 18:16:54

您可以将数组与 Contains() 查询结合使用：

var settingTypeIds = new[] { 81, 82, 83 };

return from a in _repository.GetApps()
..
where ent.ROW_ID == app 
      && set.application_id == id 
      && settingTypeIds.Contains(set.setting_type_id)

You can use an array combined with a Contains() query:

var settingTypeIds = new[] { 81, 82, 83 };

return from a in _repository.GetApps()
..
where ent.ROW_ID == app 
      && set.application_id == id 
      && settingTypeIds.Contains(set.setting_type_id)

回复收藏 0 原文