How do I Query using mutiple strings in where statement in LINQ?

You can create the list before the query, that would make it easier to understand. Also you can do a join instead of looping on both tables List nickList=new List {"Ayuris" , "Crey" , "DjMofasa" , "esel" , "Firaxa" , "Kindleguy" , "Michigo" , "moiC" ,"Shibiz"}; var test = from a in db. PlasserLans join be in db.

Ulans on a. RegisteredNick equals b. Username where nickList.

Contains(a. Nick) orderby a. Nick select new { Nick = a.

Nick, Username = b. Username, Email = b. UserEMail, RealName = b.

UserRealname, }.

You can create the list before the query, that would make it easier to understand. Also you can do a join instead of looping on both tables. List nickList=new List {"Ayuris" , "Crey" , "DjMofasa" , "esel" , "Firaxa" , "Kindleguy" , "Michigo" , "moiC" ,"Shibiz"}; var test = from a in db.

PlasserLans join be in db. Ulans on a. RegisteredNick equals b.

Username where nickList. Contains(a. Nick) orderby a.

Nick select new { Nick = a. Nick, Username = b. Username, Email = b.

UserEMail, RealName = b. UserRealname, }.

In Linq-2-sql its just the other way around where .... && {"Ayuris" , "Crey" , "DjMofasa"}. Contains(a. Nick) This is by heart, not sure if the direct usage of {} works, but you need to checkout the .Contains() for linq-2-sql and it will work.

I had to make it a array first running it directly on the {} don't work. Got it to work using your way indirectly – Thomas Andreè Lian Nov 9 at 21:03 This example should be new {....} – cadrell0 Nov 9 at 21:09 Like I said, by heart and I missed the new but happy you got it working... – Pleun Nov 9 at 21:33.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions