如何使用“where in” Linq中的sql子句 [英] How to use "where in" clause of sql in Linq
问题描述
Hi Every One
我是Linq的新手,我想使用linq实现Sql的where in。
要求如下
我有一个列表< int>,现在我想查询提供给我的所有
行,其中id在列表中。
img id是我的列表,其中包含int值。
linq代码如下
var db = new CarDataContext();
var deleteImages = 来自 deletimg db.tbl_Car_Images
其中 imgId.Contains(delete.Car_Id)
select deletimg;
先谢谢
尝试这样的事情
var q = from item in listItems where item.Contains( id)选择项目;
或更短的版本
var q = itemsList.Where((item)= > item.Contains( id));
这假设id是一个字符串值。为了给出一个正确的例子,你应该说明列表中的项目类以及你想要检查的属性。
使用简单的Contains方法。 http://www.dotnetlines.com/forum/ tabid / 86 / forumid / 2 /线程ID / 289 /范围/帖/ Default.aspx的
Hi Every One
I am new to Linq, I want to implement "where in" of Sql using linq.
Requirements are as under
I have a list<int>, Now i want to query the table that provide me all the
rows where "id" is in the list.
img id is my list having int values.
The linq code is as under
var db = new CarDataContext();
var deleteImages = from deletimg in db.tbl_Car_Images
where imgId.Contains(delete.Car_Id)
select deletimg;
Thanks in Advance
try something like this
var q = from item in listItems where item.Contains("id") select item;
or a shorter version
var q = itemsList.Where((item) => item.Contains("id"));
This assumes that id is a string value. To give a proper example you should state the class of item in the list as well as the property you wish to check.
Use simple Contains method. http://www.dotnetlines.com/forum/tabid/86/forumid/2/threadid/289/scope/posts/Default.aspx
这篇关于如何使用“where in” Linq中的sql子句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!