Enabled ‘optimized For Ad Hoc’ When Using Orm Code Generation
Since the code generated from the ORM can frequently be ad hoc, ensure that the SQL Server instance has ‘Optimize for Ad Hoc’ enabled. This will store a plan...
Recent Posts
Lazy Load Vs A Single Database Hit
Watch out for lazy loading in ORMs. You shouldn’t lazy load any entities that could be retrieved with a single database hit.
Make Sure Paging Is Conducted At The Database Layer
When using grid UI controls (framework based, or 3rd party owned), you should carefully consider how paging is implemented. Many controls implement paging in...
Verify Parameter Size Versus Data Type Within The Table
Be sure your code is generating a parameter size equivalent to the data type defined within table in the database. Some ORM tools size the parameter to the s...
Orm Doesn’t Mean You Have To Abandon The Relational Storage Design
Avoid following the ‘Hello World’ examples provided with your ORM tool that turns it into an Object to Object Mapping. Database storage is not the same as ob...