How do I append a 'where' clause using VB.NET and LINQ?

vb.net linq where-clause
sugarcrum picture sugarcrum · Apr 23, 2009 · Viewed 96.9k times · Source

I am pretty new to VB.NET and am having a bit of trouble here with something I thought should be simple.

Keeping it simple, let's say I have a Document table with "Name" that I want to search on (in reality there are several other tables, joins, etc. ..). I need to be able to build the query using a where clause based on string values passed in.

Example - the user may pass in "ABC", "ABC DEF", "ABC DEF GHI".

The final query would be (the syntax is not correct, I know):

Select * from Documents Where Name Like %ABC% AND Name Like %DEF% AND Name like %GHI%

So, I thought I could do something like this.

Dim query = From document In _context.Documents

<< loop based on number of strings passed in >>
query = query.Where( ... what goes here?? )

For some reason, being brain-dead or something, I can't figure out how to make this work in VB.NET, or if I'm doing it correctly.

Answer

Jimmie R. Houts picture Jimmie R. Houts · Apr 23, 2009

I believe this is how you would do it in VB (I'm a C# developer):

query = query.where(Function(s) s = "ABC")

See LINQ - Sample Queries for some examples.

Related questions

Select distinct rows from datatable in Linq

I am trying to get distinct rows based on multiple columns (attribute1_name, attribute2_name) and get datarows from datatable using Linq-to-Dataset. I want results like this attribute1_name attribute2_name -------------- --------------- Age State Age weekend_percent Age statebreaklaw …

Read More
Case insensitive string compare in LINQ-to-SQL

I've read that it's unwise to use ToUpper and ToLower to perform case-insensitive string comparisons, but I see no alternative when it comes to LINQ-to-SQL. The ignoreCase and CompareOptions arguments of String.Compare are ignored by LINQ-to-SQL (if you're using …

Read More
Linq to Sql: Multiple left outer joins

I'm having some trouble figuring out how to use more than one left outer join using LINQ to SQL. I understand how to use one left outer join. I'm using VB.NET. Below is my SQL syntax. T-SQL SELECT o.…

Read More