how to create orselect with multi condition in linq

Question

0.00/5 (No votes)

See more:

Hi I want select data witch for example sensor="sen" or Area="aa"
i write this code:

C#

var listsegment2 = from ls1 in SMDB.SegmentInfos
where (ls1.Area == area || string.IsNullOrEmpty(area)) && (ls1.Sensor == sen||string.IsNullOrEmpty(sen)) && (ls1.System == sys || string.IsNullOrEmpty(sys)) && (ls1.Jbo == jbo || string.IsNullOrEmpty(jbo))
select new
{}

but this code return andconditions result
help me to correct code,please

Posted 23-Sep-14 7:39am

Member 11046620

Updated 23-Sep-14 8:05am

Kim Togo

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2014-09-23T07:58:00

Solution 1

If I understood the question correctly, you have used && where you should've used ||

So something like this:

C#

var listsegment2 = from ls1 in SMDB.SegmentInfos
                   where (  (ls1.Area == area || string.IsNullOrEmpty(area)) 
                         || (ls1.Sensor == sen || string.IsNullOrEmpty(sen))
                   )
                   && (ls1.System == sys || string.IsNullOrEmpty(sys)) 
                   && (ls1.Jbo == jbo || string.IsNullOrEmpty(jbo))
select new
{}

Posted 23-Sep-14 7:58am

Wendelius

Comments

Kim Togo 23-Sep-14 14:04pm

From OP: when i used || return all record and incorrect result

Wendelius 23-Sep-14 14:35pm

Thanks

Wendelius 23-Sep-14 14:36pm

Without seeing your data and what are your expected results I'd say it's quite hard to show what would be the correct query. Perhaps if you post some sample data and what you're after :)

Member 11046620 24-Sep-14 8:47am

iwant all condition in where
for examole all record where Area="AA" || Sensor="sen" || System="sys"||...

Wendelius 24-Sep-14 11:54am

In that case what's wrong with a query like:

var listsegment2 = from ls1 in SMDB.SegmentInfos
where ls1.Area == "AA"
|| ls1.Sensor == "sen"
|| ls1.System == "sys"
select ls1;

Kim Togo · Answer 2 · 2014-09-23T08:01:00

If Sensor and Area can be "sen" or "aa", then just use OR = "||"

string.Equals is a great method to compare strings.

C#

string sensor = "sen";
string area = "aa";
string system = "sys";

var listSegment2 = from ls1 in SMDB.SegmentInfos
                   where string.Equals(ls1.Area, area, StringComparison.InvariantCultureIgnoreCase)
                   || string.Equals(ls1.Sensor, sen, StringComparison.InvariantCultureIgnoreCase)
                   || string.Equals(ls1.System, system, StringComparison.InvariantCultureIgnoreCase)
                   select ls1;

foreach (var segment in listSegment2)
{
  Console.WriteLine("Segment - Area:" + segment.Area + ", Sensor:" + segment.Sensor);
}