C# Class Northwind.Data.NorthwindEntities

Inheritance: DbContext
Afficher le fichier Open project: vladislav-karamfilov/TelerikAcademy Class Usage Examples

Méthodes publiques

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

Méthodes protégées

Méthode Description
OnModelCreating ( DbModelBuilder modelBuilder ) : void

Method Details

CustOrderHist() public méthode

public CustOrderHist ( string customerID ) : ObjectResult
customerID string
Résultat ObjectResult

CustOrdersDetail() public méthode

public CustOrdersDetail ( Nullable orderID ) : ObjectResult
orderID Nullable
Résultat ObjectResult

CustOrdersOrders() public méthode

public CustOrdersOrders ( string customerID ) : ObjectResult
customerID string
Résultat ObjectResult

Employee_Sales_by_Country() public méthode

public Employee_Sales_by_Country ( Nullable beginning_Date, Nullable ending_Date ) : ObjectResult
beginning_Date Nullable
ending_Date Nullable
Résultat ObjectResult

NorthwindEntities() public méthode

public NorthwindEntities ( ) : System
Résultat System

OnModelCreating() protected méthode

protected OnModelCreating ( DbModelBuilder modelBuilder ) : void
modelBuilder DbModelBuilder
Résultat void

SalesByCategory() public méthode

public SalesByCategory ( string categoryName, string ordYear ) : ObjectResult
categoryName string
ordYear string
Résultat ObjectResult

Sales_by_Year() public méthode

public Sales_by_Year ( Nullable beginning_Date, Nullable ending_Date ) : ObjectResult
beginning_Date Nullable
ending_Date Nullable
Résultat ObjectResult

Ten_Most_Expensive_Products() public méthode

public Ten_Most_Expensive_Products ( ) : ObjectResult
Résultat ObjectResult

sp_alterdiagram() public méthode

public sp_alterdiagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
diagramname string
owner_id Nullable
version Nullable
definition byte
Résultat int

sp_creatediagram() public méthode

public sp_creatediagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
diagramname string
owner_id Nullable
version Nullable
definition byte
Résultat int

sp_dropdiagram() public méthode

public sp_dropdiagram ( string diagramname, Nullable owner_id ) : int
diagramname string
owner_id Nullable
Résultat int

sp_helpdiagramdefinition() public méthode

public sp_helpdiagramdefinition ( string diagramname, Nullable owner_id ) : ObjectResult
diagramname string
owner_id Nullable
Résultat ObjectResult

sp_helpdiagrams() public méthode

public sp_helpdiagrams ( string diagramname, Nullable owner_id ) : ObjectResult
diagramname string
owner_id Nullable
Résultat ObjectResult

sp_renamediagram() public méthode

public sp_renamediagram ( string diagramname, Nullable owner_id, string new_diagramname ) : int
diagramname string
owner_id Nullable
new_diagramname string
Résultat int

sp_upgraddiagrams() public méthode

public sp_upgraddiagrams ( ) : int
Résultat int

usp_GetTotalIncomesBySupplierNameAndPeriod() public méthode

public usp_GetTotalIncomesBySupplierNameAndPeriod ( string supplierName, Nullable startDate, Nullable endDate ) : ObjectResult>
supplierName string
startDate Nullable
endDate Nullable
Résultat ObjectResult>