BP58: Always check what T-SQL is generated by Entity Framework and that filters are applied correctly

Sometimes the Entity Framework does not convert your predicate to T-SQL and it does the filtering in memory after all data is retrieved from the database server.

Comments

Anonymous
Too many people are not doing it, too many people don't know about materialization.
SaltEchidna39
Everyone should be doing this. Is there anyone who is not?

Download Better Coder application to your phone and get unlimited access to the collection of enterprise best practices.

Get it on Google Play