After attempts to recreate my old blog I have decided to start over with a clean slate but will continue to migrate my older blog posts to this new host.
Additionally I will be posting here soon a technique I’ve used in the past to return broad and flexible database query results very quickly without using dynamic SQL. It’s worked to replace poor performing ORM queries where the ORM is reaching across the data model with the goal of providing a one stop shop for use search functionality. This will be designed around the AdventureWorks2022 SQL database and will document the steps to recreate this functionality to demonstrate its potential for your specific needs.