Multiple condition in Where clause of entity framework Using MODEL in MVC

Question

1.00/5 (1 vote)

See more:

i am using entity framework for data access from database. I want to fetch data from a table on the basis of two condition. e.g. "mobileNumber" and "Name" of user in a "Customer" table.
ViewBag.Customer=entity.Customers.Where(i=>i.MobileNumber==12321 && i=>i.Nmae=="abc").firstordefault();

But this is Not working, Can anybody answer how to check multiple condition in where clause of entity framework

Posted 22-Jan-13 18:12pm

Member 9583779

Updated 7-Aug-20 21:11pm

Add a Solution

4 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)

Abdul Quader Mamun · Answer 1 · 2013-01-22T18:22:00

Solution 1

You can follow the bellow example. And Firstly, you can check any record is available with your given condition in SQL Query analyzer and then you will try entity framework.

C#

var repo = new Repositories.Repository<listing>();
            var listings = repo.GetTable().Where(l => l.IsDeleted == false && l.IDListingStatus == 2 && (l.IDListingType == 1 || l.IDListingType == 2 || l.IDListingType == 3));</listing>

Thanks,

Posted 22-Jan-13 18:22pm

Abdul Quader Mamun

Comments

Member 9583779 23-Jan-13 6:47am

entity is object of my entity framework class.
Model.MyProject entity=new Model.Myproject();

and "Customer" is class build in this entity. from which i want to fetch data on the basis of Multiple condition.

ViewBag.CustomerList=entity.Customers.Where(i=>i.MobileNumber==12321 && i=>i.Nmae=="abc").firstordefault();

Jameel VM · Answer 2 · 2013-01-24T20:04:00

Solution 3

C#

ViewBag.Customer=entity.Customers.Where(i=>i.MobileNumber==12321 && i.Nmae=="abc").firstordefault();

Don't need to use again

C#

i=>i.Nmae=="abc"

Hope this helps.

Posted 24-Jan-13 20:04pm

Jameel VM

Updated 24-Jan-13 20:06pm

v2

thirupathiCst · Answer 3 · 2016-12-19T17:53:00

Solution 4

just check first condition after directly you access the columns by instance

(i=>i.tablecolumnname==column name && i.column==column) in this you get
after "i" is instance by this you access all column names in table

Posted 19-Dec-16 17:53pm

thirupathiCst

Member 12675979 · Answer 4 · 2020-08-07T21:11:00

Solution 5

Dont use x=>x. again after &&, query should be db.student.where(x=>x.roll='1121' && x.name=='NAME')

Posted 7-Aug-20 21:11pm

Member 12675979

Comments

Richard Deeming 10-Aug-20 6:40am

As already explained in Solution 3, back in 2013.