WPF C# LINQ: Operator '&&' cannot be applied to operands of type 'string' and 'string' query

Question

I'm trying to execute this query but for some reason it doesn't like the fact that 2 strings are sitting beside each other, here's the query:

var FiveSecStatsQuery = from qai in connection.QuickAnalyzerInputs
                             join calP in connection.CalculatedPrices on qai.InputID equals calP.TradeID
                             where ***(qai.ClientName = clientName) && (qai.CurrencyPair = cur_pair)*** 
                             && (calP.Description = PriceDescriptions.FiveSeconds) && (calP.Outcome != null)
                             select new
                             {
                                 calP.Outcome
                             };

The error is : Operator '&&' cannot be applied to operands of type 'string' and 'string'

Why is it giving me this error? Both ClientName and CurrencyPair are of type string in the database. The error occurs where the asterisks are

Habib · Accepted Answer · 2014-02-07 15:40:21Z

16

You need double ==, not single = so your where clause should be:

where (qai.ClientName == clientName) && (qai.CurrencyPair == cur_pair)
&& (calP.Description == PriceDescriptions.FiveSeconds) && (calP.Outcome != null)

answered Feb 7, 2014 at 15:40

Habib

224k30 gold badges420 silver badges446 bronze badges

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

2 Comments

kknaguib Over a year ago

Wowww! thanks been staring at it for 15 min and I couldn't see that. Thanks again @Habib!

Moeez Over a year ago

Where(m=> (m.zdjh == msn).ToString() && (dt >= m.sjsj).ToString() this is my LINQ exp and I am getting operator && cannot be applied to operands of type 'string' and 'string' c#

Tamir Vered · Accepted Answer · 2014-02-07 15:40:47Z

4

Change (qai.ClientName = clientName) && (qai.CurrencyPair = cur_pair) to (qai.ClientName == clientName) && (qai.CurrencyPair == cur_pair) since its boolean operation not value assignment

answered Feb 7, 2014 at 15:40

Tamir Vered

10.3k5 gold badges48 silver badges57 bronze badges

Collectives™ on Stack Overflow

WPF C# LINQ: Operator '&&' cannot be applied to operands of type 'string' and 'string' query

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related