AND Operator cannot work with bool and string

Question

I have a LINQ2SQL statement where I am using two criteria:

var query1 = from r in dt.Test
                                where r.ID == 92 
                                && r.Status = '"I"
                                select r.ID && r.Status = "I"

But its giving me an err that AND (&&) operator cannot work with string and bool. Whats the turnaround for this?

I do not understand the question "Whats the turnaround for this?". By "turnaround" do you mean "explanation"? — Colin Mackay, May 16 '11 at 20:31
Are you mixing up equality and assignment with your equals operator? — Dan Diplo, May 16 '11 at 20:32
Thanks guys, it was a typo on my side. Appreciate all your answers! — RG-3, May 16 '11 at 20:39

Karl Nicoll · Accepted Answer · 2011-05-16T20:37:32.760

5

Try replacing your = signs with ==

var query1 = from r in dt.Test
                            where r.ID == 92 
                            && r.Status == "I"
                            select r.ID && r.Status == "I"

Remember that = in C# is the assignment operator, and == is the equality operator. As someone who regularly flips between C# and VB.NET, I often come unstuck here!

edited May 16 '11 at 20:37

answered May 16 '11 at 20:30

Karl Nicoll

16,090
3
51
65

1

I get flamed but "I" = r.Status would have caught this as a compile error – n8wrl May 16 '11 at 20:34
1

@kim9971 - Happy to help! Don't forget to choose an answer to your question by clicking the "tick" on the left :) – Karl Nicoll May 16 '11 at 20:45

score 1 · Answer 2 · answered May 16 '11 at 20:30

1

You have a single equals sign r.Status = '"I", should be r.Status == '"I"

answered May 16 '11 at 20:30

Chris Haas

53,986
12
141
274

Yeah, it was a typo from my side. – RG-3 May 16 '11 at 20:40

score 1 · Answer 3 · answered May 16 '11 at 20:31

You mean == in place of =; the assignment expression (as opposed to the equality operator) is confusing things; instead of returning a bool, the result of r.Status = "I" is a string... "I"

var query1 = from r in dt.Test
             where r.ID == 92 && r.Status == "I"
             select r.ID;

(not quite sure what to make of the last part of your select, so I omitted it)

score 1 · Answer 4 · edited May 23 '17 at 09:59

= is used for assignment and == is used for equality.
I am not sure what result you're expecting, but select r.ID && r.Status == "I" (even with 2 equal signs) is not valid in any case.

Depending on what you want to select, if the result is the amount of the rows qualifying for your search consider using Count(). If you want to select these two values, use a POCO class or an anonymous type:

var query1 = from r in dt.Test
             where r.ID == 92 && r.Status == "I"
             select new { ID = r.ID, Status = r.Status };

score 0 · Answer 5 · edited Aug 11 '12 at 11:39

0

var query1 = from r in dt.Test
             where r.ID == 92 && r.Status == "I"
             select r.ID && r.Status == "I";

edited Aug 11 '12 at 11:39

Adi Lester

24,731
12
95
110

answered May 16 '11 at 20:30

mbeckish

10,485
5
30
55

AND Operator cannot work with bool and string

5 Answers5

Linked