convert sql query to entity framework

Question

Please i need someone to help convert this query entity(c#) form.

select * 
from incident 
where Details like'%Help%' 
and status = 'Resolved' 
or details like '%Help%' and Status = 'Closed'

See what I tried

incident = incident.Where(s => s.Details.ToUpper().Contains(SearchParam.ToUpper()));

Are you 100% clear on which conditions of your WHERE clause (in your SQL statement) get combined how? I have a feeling you might want something else than what you really get right now... — marc_s
– marc_s, Commented Jun 17, 2012 at 15:53
Incidentally, you're looking to express this query in LINQ. EF is just your persistence framework. Have you looked into LINQPad? — Dave Swersky
– Dave Swersky, Commented Jun 17, 2012 at 16:00
Why isn't your query WHERE Details LIKE '%Help%' AND [status] IN ('Resolved', 'Closed');? Mixing AND and OR can be quite confusing, and repeating the same clause multiple times is wasteful. IMHO. — Aaron Bertrand
– Aaron Bertrand, Commented Jun 17, 2012 at 16:11
What i want is a query that will extract all closed and resolved incident from the incident table based on the input criterial provided by the user. the input is the detail field. — demo.b
– demo.b, Commented Jun 17, 2012 at 16:14

Damith · Accepted Answer · 2012-06-17 15:57:46Z

2

incident = incident.Where(s => s.Details.ToUpper().Contains(SearchParam.ToUpper()) 
              && (s.Status == "Resolved" || s.Status == "Closed"));

answered Jun 17, 2012 at 15:57

Damith

63.2k13 gold badges105 silver badges154 bronze badges

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

Collectives™ on Stack Overflow

convert sql query to entity framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related