C# Class Adventure.Works.LiveDemo.Startup

Afficher le fichier Open project: TelerikAcademy/Databases

Méthodes publiques

Méthode	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 méthode

public static Main ( string args ) : void
args	string
Résultat	void

QueryFive() public static méthode

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

public static QueryFive ( ) : void
Résultat	void

QueryFour() public static méthode

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

public static QueryFour ( ) : void
Résultat	void

QueryOne() public static méthode

public static QueryOne ( ) : void
Résultat	void

QuerySix() public static méthode

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

public static QuerySix ( ) : void
Résultat	void

QueryThree() public static méthode

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

public static QueryThree ( ) : void
Résultat	void

QueryTwo() public static méthode

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
Résultat	void