C# Class Northwind.Data.NorthwindEntities

Inheritance: DbContext

ファイルを表示 Open project: vladislav-karamfilov/TelerikAcademy Class Usage Examples

Public Methods

Method	Description
CustOrderHist ( string customerID ) : ObjectResult
CustOrdersDetail ( Nullable orderID ) : ObjectResult
CustOrdersOrders ( string customerID ) : ObjectResult
Employee_Sales_by_Country ( Nullable beginning_Date, Nullable ending_Date ) : ObjectResult
NorthwindEntities ( ) : System
SalesByCategory ( string categoryName, string ordYear ) : ObjectResult
Sales_by_Year ( Nullable beginning_Date, Nullable ending_Date ) : ObjectResult
Ten_Most_Expensive_Products ( ) : ObjectResult
sp_alterdiagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
sp_creatediagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
sp_dropdiagram ( string diagramname, Nullable owner_id ) : int
sp_helpdiagramdefinition ( string diagramname, Nullable owner_id ) : ObjectResult
sp_helpdiagrams ( string diagramname, Nullable owner_id ) : ObjectResult
sp_renamediagram ( string diagramname, Nullable owner_id, string new_diagramname ) : int
sp_upgraddiagrams ( ) : int
usp_GetTotalIncomesBySupplierNameAndPeriod ( string supplierName, Nullable startDate, Nullable endDate ) : ObjectResult>

Protected Methods

Method	Description
OnModelCreating ( DbModelBuilder modelBuilder ) : void

Method Details

CustOrderHist() public method

public CustOrderHist ( string customerID ) : ObjectResult
customerID	string
return	ObjectResult

CustOrdersDetail() public method

public CustOrdersDetail ( Nullable orderID ) : ObjectResult
orderID	Nullable
return	ObjectResult

CustOrdersOrders() public method

public CustOrdersOrders ( string customerID ) : ObjectResult
customerID	string
return	ObjectResult

Employee_Sales_by_Country() public method

public Employee_Sales_by_Country ( Nullable beginning_Date, Nullable ending_Date ) : ObjectResult
beginning_Date	Nullable
ending_Date	Nullable
return	ObjectResult

NorthwindEntities() public method

public NorthwindEntities ( ) : System
return	System

OnModelCreating() protected method

protected OnModelCreating ( DbModelBuilder modelBuilder ) : void
modelBuilder	DbModelBuilder
return	void

SalesByCategory() public method

public SalesByCategory ( string categoryName, string ordYear ) : ObjectResult
categoryName	string
ordYear	string
return	ObjectResult

Sales_by_Year() public method

public Sales_by_Year ( Nullable beginning_Date, Nullable ending_Date ) : ObjectResult
beginning_Date	Nullable
ending_Date	Nullable
return	ObjectResult

Ten_Most_Expensive_Products() public method

public Ten_Most_Expensive_Products ( ) : ObjectResult
return	ObjectResult

sp_alterdiagram() public method

public sp_alterdiagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
diagramname	string
owner_id	Nullable
version	Nullable
definition	byte
return	int

sp_creatediagram() public method

public sp_creatediagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
diagramname	string
owner_id	Nullable
version	Nullable
definition	byte
return	int

sp_dropdiagram() public method

public sp_dropdiagram ( string diagramname, Nullable owner_id ) : int
diagramname	string
owner_id	Nullable
return	int

sp_helpdiagramdefinition() public method

public sp_helpdiagramdefinition ( string diagramname, Nullable owner_id ) : ObjectResult
diagramname	string
owner_id	Nullable
return	ObjectResult

sp_helpdiagrams() public method

public sp_helpdiagrams ( string diagramname, Nullable owner_id ) : ObjectResult
diagramname	string
owner_id	Nullable
return	ObjectResult

sp_renamediagram() public method

public sp_renamediagram ( string diagramname, Nullable owner_id, string new_diagramname ) : int
diagramname	string
owner_id	Nullable
new_diagramname	string
return	int

sp_upgraddiagrams() public method

public sp_upgraddiagrams ( ) : int
return	int

usp_GetTotalIncomesBySupplierNameAndPeriod() public method

public usp_GetTotalIncomesBySupplierNameAndPeriod ( string supplierName, Nullable startDate, Nullable endDate ) : ObjectResult>
supplierName	string
startDate	Nullable
endDate	Nullable
return	ObjectResult>