C# Class Adventure.Works.LiveDemo.Startup

Show file Open project: TelerikAcademy/Databases

Public Methods

Method	Description
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

Method Details

Main() public static method

public static Main ( string args ) : void
args	string
return	void

QueryFive() public static method

Eager loading the email addresses in one server request SET Based operation

public static QueryFive ( ) : void
return	void

QueryFour() public static method

Not a set based operation More like individual T-SQL Statements looking up each individual email address

public static QueryFour ( ) : void
return	void

QueryOne() public static method

public static QueryOne ( ) : void
return	void

QuerySix() public static method

Eager loading done properly With explicit join, server filtering and projection

public static QuerySix ( ) : void
return	void

QueryThree() public static method

Using a projection to retrieve less data as possible from the server

public static QueryThree ( ) : void
return	void

QueryTwo() public static method

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

public static QueryTwo ( ) : void
return	void