Parameter specification in entity framework lambda expression

Question

Is there a different between the two statements below, perhaps in terms of performance or readability, assuming you have a model named RateCountry with CountryCode as one of the properties. Of course in my project I will only have one return statement

public RateCountry GetRateCountry(string countryCode, int rateId)
{
    return _directConnectContext.RateCountries.FirstOrDefault(rc => rc.CountryCode == countryCode && rc.RateID == rateId);

    return _directConnectContext.RateCountries.Where(rc => rc.CountryCode == countryCode && rc.RateID == rateId).FirstOrDefault(); 
}

EF is an ORM. LINQ queries generate SQL queries in the end. Compare the generated SQL text. I suspect they'll be either identical or equivalent. There's only one way to write SELECT TOP 1 FROM X where ... after all — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Mar 19, 2018 at 11:20
As long as your are dealing with an IQueryable which if _directConnectContext is an EF DB context you are, then there is no difference. — Ashley Medway
– Ashley Medway, Commented Mar 19, 2018 at 11:21
@AshleyMedway wrong source. That's for Enumerable, not Queryable — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Mar 19, 2018 at 11:22
@AshleyMedway Queryable's source doesn't matter though, the generated SQL query does. That's done by the provider. It's easier to simply check the generated queries — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Mar 19, 2018 at 11:25
First statement is simply a shortcut for (a concise version of ) the second, hence performance should be the same. What about readability, it's a matter of personal preference, hence is opinion based. — Ivan Stoev
– Ivan Stoev, Commented Mar 19, 2018 at 11:30

Backs · Accepted Answer · 2018-03-19 11:32:49Z

1

Equality of LINQ statements is defined by equality of generated SQL code. If you look at generated SQL code of both queries, you will see that they are the same. So, answering your question - no, there is no difference.

answered Mar 19, 2018 at 11:32

Backs

25k5 gold badges66 silver badges92 bronze badges

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

Collectives™ on Stack Overflow

Parameter specification in entity framework lambda expression

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