We are building a Web Portal, OurPortal. The IT Infrastructure includes a pair of Virtual Servers: AppSvr and DBSvr running Windows Server 2019. The database is on SQL Server 2019.
The database has been designed with many tables, PKs, and FKs.
The development team has chosen to use Entity Framework for development speed.
Here is a simple test case and my question:
Two Entities are Torganization and TContact
OurPortal issues a request to retrieve a subset of records from Tcontacts.
Select * from Tcontacts where (FirstName = ‘Bill’) or (LastName like ‘%son%’);
Three EDM variants for implementing the query:
The question: With each variant, which server is executing the query and applying the WHERE clause: AppSvr or DBSvr?