LINQ String Array Not IN

Question

using LINQ how do I get this query to return all states except for the ones in the string array?

string[] states = { "FL", "CA", "IN", "AL", "MI" };
var headers = (from h in db.Headers
               where h.State != states.Any()
               select new
               {
                   description = h.Description,
                   state = h.State
               });

Christo's answer is correct, Selman's will work too. But just to expound a bit, you should look at the return values of the LINQ extensions. For example, Any() returns type bool, you are trying to compare a h.State (probably a string) to a bool. — Evan L
– Evan L, Commented May 20, 2014 at 15:26

Christos · Accepted Answer · 2014-05-20 15:21:32Z

5

You could try this:

 var headers = (from h in db.Headers
                where !states.Contains(h.State)
                select new
                {
                    description = h.Description,
                    state = h.State
                });

answered May 20, 2014 at 15:21

Christos

54.1k9 gold badges82 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

scripter78 Over a year ago

I love and Hate you right now. Love you for answering this quickly and hate you for answering it so damn quickly, now I feel like a moron. LOL

Christos Over a year ago

@scripter78 you shouldn't feel like a moron. I suppose that you haven't used too much LINQ. If you had used a lot of LINQ, that would have been one of your first thoughts. You question is well formed and that you wanted is very clear, which both helped for your answer to be answered very quickly.

scripter78 Over a year ago

I knew it had something to do with Contains and did try that to begin with but how ever I had it which I can't recall at the moment, it would not work. and it was a lot more elaborate than your solution. That is the one thing I always go off of. If my solution gets too elaborate than I know I am doing something wrong. I do use Linq but I have never had to use it in the scenario here. Nonetheless thank you That saved me a ton of time and one hell of a headache

Selman Genç · Accepted Answer · 2014-05-20 15:29:21Z

1

Probably you should use Contains because it will be translated as NOT IN into SQL however this is how you can do it with Any, it should be translated as NOT EXISTS:

var headers = (from h in db.Headers
               where !states.Any(x => x == h.State)
               select new
                   {
                       description = h.Description,
                       state = h.State
                   });

edited May 20, 2014 at 15:29

answered May 20, 2014 at 15:23

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Collectives™ on Stack Overflow

LINQ String Array Not IN

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related