Difference between && and where condition in entity framework query

c# entity-framework if-statement linq performance

Question

Difference between and condition and two where condition in entity framework query

Code 1

I have using two where condition in my query

 dbContext.Projects.Where(p=>p.ProjectId!=ProjectId).Where(p=>p.Name==Name)
 .SingleOrDefault();

code 2

I have using && condition without using two where condition 

  dbContext.Projects.Where(p=>p.ProjectId!=ProjectId &&  
  p.Name==Name).SingleOrDefault();
  • What is the difference between code1 and code2????

The both queries are return same value. but i don't know the differences. Please explain to me, which one is better. and why?

1
7
9/12/2016 11:22:14 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

If you open your query in LinqPad you will see that both queries

dbContext.Projects.Where(p=>p.ProjectId!=ProjectId).Where(p=>p.Name==Name)

dbContext.Projects.Where(p=>p.ProjectId!=ProjectId && p.Name==Name);

will result both in 

SELECT [...]
FROM [...]
WHERE p.ProjectId <> someId AND p.Name = 'something'

There is no difference neither in performance nor in SQL query structure.

11
5/6/2015 7:35:35 AM

Popular Answer

From the documentation

Return value:

An IEnumerable that contains elements from the input sequence that satisfy the condition.

So the second where will only be applied to the records surviging the first where - which is identical to the && expression you built in code 2.

See: https://msdn.microsoft.com/de-de/library/bb534803%28v=vs.110%29.aspx

Mario The Spoon

Related Questions

Using Entity Framework to implement if-not-exists-insert without race conditions

Using LINQ-to-Entities 4.0, is there a correct pattern or construct for safely implementing "if not exists then insert"?...For example, I currently have a table that tracks "user favorites" - users can add or remove articles from their list of favorites....The underlying table is not a true many-to-many relationship, but instead tracks some additio...
entity-framework insert linq-to-entities
asked by ShadowChaser

Avoiding the if-exists-update-else-insert race problem in Entity Framework

I've been reading other questions on how to implement if-exists-insert-else-update semantics in EF, but either I'm not understanding how the answers work, or they are in fact not addressing the issue. A common solution offered is to wrap the work in a transaction scope (eg: ...Implementing if-not-exists-insert using Entity Framework without race c...
.net entity-framework race-condition transactions
asked by Mike Chamberlain

Dynamically query entities from Entity Framework for association to primary Entity

We've had an in-depth discussion about how to get the ...metadata... out of the ...DbContext.... Here are a few links to get you started. And I'll add some specific comments. ...How I can read EF DbContext metadata programmatically?...A short summary (but you should check in there for more): ...using (var db = new MyDbContext()) { var objectC...
c# dynamic-queries entity-framework expression-trees reflection
asked by NSGaga-mostly-inactive

How to chain alternative conditions in where clause in Entity Framework

I'm trying to rewrite the following query as a separate statements:...var sql = Repository.Products.AsQueryable(); sql = sql.Where(x => x.Name == "aaaaa" || x.Name == "bbbbb"); ...If I do it like this:...sql = sql.Where(x => x.Name == "aaaaa"); sql = sql.Where(x => x.Name == "bbbbb"); ...then the resulting query is equal to:...sql = sql.Where(x =>...
.net c# entity-framework linq-to-entities
asked by dodbrian

Dynamic query with OR conditions in Entity Framework

I am creating a creating an application that searches the database and allows the user to dynamically add any criteria (around 50 possible), much like the following SO question: ...Creating dynamic queries with entity framework.... I currently have working a search that checks each criteria, and if it is not blank it adds it to the query. ...C#...
c# entity-framework linq linq-to-entities sql-server
asked by Ben Anderson

Entity Framework query ToString won't produce SQL query

If you do not need the SQL BEFORE it is executed against the DB you can do the following:...dbContext.Database.Log = s => Debug.WriteLine(s); ...This would print the SQL (and some additional data) to the debug output.... See the following link for details: ...http://msdn.microsoft.com/de-DE/data/dn469464...Also check, as martin_costello suggested, ...
c# entity-framework entity-framework-5 entity-framework-6
asked by Christoph Fink

Adding condition to mapping for child collection in Entity Framework 6 similar to NHibernate's "where"

You could add an "RootOutlineItems" property to the ReportOutline class that filters for you, then call that when you want just the 1st level:...public class ReportOutline { public long Id { get; set; } public string Title { get; set; } public string Author { get; set; } public virtual ICollection<OutlineItem> OutlineItems { get...
c# entity-framework entity-framework-6 nhibernate
asked by CJennings

Get max & min from Entity Framework, in one query and with best query possible

Try removing the ...let... statements - the below produces expected results:...var q = from d in db.Table where d.Id == 1 group d by d.Id into g select new { Id = g.Key, // shown for illustrative purposes ColumnMin = g.Min( gi => gi.Column ), ColumnMax = g.Max( gi => gi.Column ) ...
c# entity-framework generated-sql linq
asked by Moho

Client side query builder (jquery) to Entity Framework query

today i wanted to use jquery query builder with EF and i wrote this code for parsing filter to Expression. i hope it useful for others....rule data model :...public class Rule { public string Condition { get; set; } public List<Rule> Rules { get; set; } public string Id { get; set; } public string Field { get; set; } public stri...
c# entity-framework-6 linq repository-pattern unit-of-work
asked by Mahdi Farhani

OrderBy().FirstOrDefault(<condition>) vs. Where(<condition>).OrderBy().FirstOrDefault()

Im using EntitiyFramework 6.1.3 with SQL Server in a C# Project. I've two queries which basically should do the same....1....Exams.GroupBy(x=>x.SubjectID).Select(x => x.OrderBy(y => y.Level.NumericValue).FirstOrDefault(y => y.Date.Value > DateTime.Today)) ...2....Exams.GroupBy(x=>x.SubjectID).Select(x => x.Where(y => y.Date.Value > DateTime.Today)....
entity-framework-6 linq-to-sql sql-server
asked by Vanice

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow