Advanced Where Statements in Linq to Entity Framework
- by JimJams
Hi,
I am wanting to create a Where statement within my Linq statement, but have hit a bit of a stumbling block.
I would like to split a string value, and then search using each array item in the Where clause.
In my normal Sql statement I would simply loop through the string array, and build up there Where clause then either pass this to a stored procedure, or just execute the sql string. But am not sure how to do this with Linq to Entity?
( From o In db.TableName Where o.Field LIKE Stringvalue Select o ).ToList()
Hope you can help.
Thanks in advance!