Creating successful SQL indexes is an art. I was reminded of this recently when I was looking at the indexing of a set of reporting tables, with each table expected to accommodate 100 million record.
How do you unit test something that has a dependency on Entity Framework? I ran into a situation recently when the code I wanted to test was loading a set of rules from a database that dictated the what functionality a web site had.
Swashbuckle and Swagger generates useful documentation for Web APIs. It can also allow you to call the API from your browser.
Long story short - be careful when using Linq that you don’t include calculated fields in your where clauses, or if you do make sure you know how the query is being executed.