Smit Patel

Results 189 comments of Smit Patel
trafficstars

Same goes for FromSql where parameters are constant expression.

```C# context.Requests .Where(x => x.UserName == "test") // use || if there are multiple columns to match .Select(x => x.Id) .ToList(); ```

We should consider when and when not to use Task.CompletedTask. Skip should be only used for test which we intend to fix in future.

Looking at the query `ShippingUnitsWithComposites` There are 5 collections in the query. Looking at logs in readme file, EF6 split query generates 6 queries which is expected. But EF2 only...

That doesn't address my observation above. I am not sure if we are comparing exactly same query between EF2 vs EF6 here. In that case, no there is no way...

If the generated query count is not the same then they are not same. Comparing the perf of 2 DbComamnd vs 6 DbCommand, certainly the latter will likely to have...

What are the perf comparisons of EF2 query and EF6 split query?

Tagging @ajcvickers We have docs for EF 6.2/5.0/4.3.1 & SqlCompact for 6.2 only. (files here https://github.com/aspnet/EntityFramework.ApiDocs/tree/live/EF/xml/FrameworksIndex) From > Current locations which need to be redirected EF6 https://msdn.microsoft.com/library/dn223258(v=vs.113).aspx (our conceptual docs...

We don't really process `!NULL` as possible `NULL` we try to convert it to 2-value logic before applying `!` operator. @maumar will have better idea how null semantics interact with...

PR never got merged or updated.