ASP.net C# VB.Net PHP
Swoole ASP/ADO/VBScript SQL语言 Python Python3 Diango C语言 Lua C++ Go语言 Revel Docker Ruby Perl Erlang R语言 Julia Apex OAuth 2.0 Arduino 编程经验 汇编语言 树莓派 游戏设计 MATLAB Elasticsearch Numpy F# Delphi HTCondor Rust 易语言 NSQ
用户登录
用户注册

分享至

LINQ Where in collection 子句

  • 作者: 低吊射滑友内含
  • 来源: 51数据库
  • 2022-12-13

问题描述

我一直在 google 上搜索，但没有找到任何对我有用的东西.

I've been looking on google but not finding anything that does the trick for me.

如您所知，SQL 有一个where x in (1,2,3)"子句，它允许您检查多个值.我正在使用 linq，但似乎找不到与上述语句相同的语法.

as you know SQL has a "where x in (1,2,3)" clause which allows you to check against multiple values. I'm using linq but I can't seem to find a piece of syntax that does the same as the above statement.

我有一个类别 ID(列表)的集合，我想根据这些集合进行检查

I have a collection of category id's (List) against which I would like to check

我发现了一些使用 .contains 方法的东西，但它甚至没有构建.

I found something that uses the .contains method but it doesn't even build.

推荐答案

你必须在你的 id 列表中使用 Contains 方法:

You have to use the Contains method on your id list:

var query = from t in db.Table
            where idList.Contains(t.Id)
            select t;
推荐阅读
热点文章

Copyright 2018 51数据库(www.51sjk.com)

软件
前端设计
程序设计
Java相关