July 25, 2008 10:56am pdt

Member Login

Top Experts

Yearly

1naspinski 33,850
2CarlVerret 17,064
3sjturner2 14,250
4Fernando... 8,700
5Ceiled 6,500
6CMYScott 5,750
7TheLearn... 5,172
8Praesidium 4,664
9GreenGho... 4,150
10emoreau 3,050
11gardavis 3,000
11Dhaest 3,000
13ZachSmith 2,600
14mark_wills 2,500
15IndianOcean 2,000
15dstanley9 2,000
15JimFive 2,000
15SwissKnife 2,000
15VBRocks 2,000
15p_davis 2,000
15vs1784 2,000
15irps20001 2,000
15Koocurrent 2,000
15Smart_Man 2,000
15Rahu_ket... 2,000
15primeMov... 2,000
15renjurdevan 2,000
15cottsak 2,000
15REA_AN... 2,000
15vb_jonas 2,000

null

	[x] Attachment Details

Linq Select IN() Query?

Zones: Language Integrated Query - LINQ, Microsoft Visual Basic.Net

Tags: linq, select

How would I replicate the following in Linq, a select in statement:
SELECT * FROM Products WHERE Products.ProductID IN(5,7,8,12)

Anyone?

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.4

Question Stats

Zone: Programming

Question Asked By: alivemedia

Solution Provided By: sjturner2

Participating Experts: 4

Solution Grade: A

Translate:

Loading Advertisement...

Open Discussion

null

Comment by Ceiled

I know this question's already been accepted, but I just wanted to point out that the "IN" keyword actually is supported in LINQ. I don't have Visual Basic installed here so I can't test it there, but the solution in C# is:

from p in db.Products
where
new int[] { 5, 7, 8, 12 }.Contains(p.ProductID)
select p

The SQL generated for this query is:
SELECT [t0].[ProductID]
FROM [dbo].[Product] AS [t0]
WHERE ([t0].[ProductID]) IN (@p0, @p1, @p2, @p3)

Hope this helps.

null

Comment by coyotee

Ceiled!

Your query is valid. How would you do a general query like;

select Field1 from Table1 where Table1.Field1 not in (select Fieldx from Tablex) and Table1.Field1 not in (select FieldY from TableY)

null

Comment by Ceiled

Well, this doesn't generate quite the same query, but it should be equivalent...

from p in data.Products
where
(from tablex in data.Tablex select tablex.Fieldx).Contains(p.ProductID.Value)
select p).CommandText

This generates the following query:

SELECT [t0].[ProductID]
FROM [dbo].[Product] AS [t0]
WHERE NOT (EXISTS(
SELECT NULL AS [EMPTY]
FROM [dbo].[Tablex] AS [t1]
WHERE [t1].[Fieldx] = ([t0].[ProductID])
))

NOT (EXISTS( SELECT...)) should be equivalent to your original query, so I suspect this will do the trick for you. Note that I'm not looking any of this up, I'm just reading your original query and thinking about how I would represent it in C#...LINQ is really extremely intuitive in this way. In C#, you use the Contains() method to find out if one value belongs to a collection of other values -- if you want to find out if it is NOT in that collection, you check !Contains(). If you want to append multiple clauses together, you use "&&" -- the same applies here.

20080723-EE-VQP-34 / EE_QW_2_20070628