메소드 | 설명 | |
---|---|---|
Main ( string args ) : void | ||
QueryFive ( ) : void |
Eager loading the email addresses in one server request SET Based operation
|
|
QueryFour ( ) : void |
Not a set based operation More like individual T-SQL Statements looking up each individual email address
|
|
QueryOne ( ) : void | ||
QuerySix ( ) : void |
Eager loading done properly With explicit join, server filtering and projection
|
|
QueryThree ( ) : void |
Using a projection to retrieve less data as possible from the server
|
|
QueryTwo ( ) : void |
Filter on the server in order to utilize the heavy mathematics and algorithms that work under the hood of SQL Server Also to retrieve less data from the server, because that is an unnecessary overhead
|