C# Класс Northwind.Data.NorthwindEntities

Наследование: DbContext
Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
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>

Защищенные методы

Метод Описание
OnModelCreating ( DbModelBuilder modelBuilder ) : void

Описание методов

CustOrderHist() публичный Метод

public CustOrderHist ( string customerID ) : ObjectResult
customerID string
Результат ObjectResult

CustOrdersDetail() публичный Метод

public CustOrdersDetail ( Nullable orderID ) : ObjectResult
orderID Nullable
Результат ObjectResult

CustOrdersOrders() публичный Метод

public CustOrdersOrders ( string customerID ) : ObjectResult
customerID string
Результат ObjectResult

Employee_Sales_by_Country() публичный Метод

public Employee_Sales_by_Country ( Nullable beginning_Date, Nullable ending_Date ) : ObjectResult
beginning_Date Nullable
ending_Date Nullable
Результат ObjectResult

NorthwindEntities() публичный Метод

public NorthwindEntities ( ) : System
Результат System

OnModelCreating() защищенный Метод

protected OnModelCreating ( DbModelBuilder modelBuilder ) : void
modelBuilder DbModelBuilder
Результат void

SalesByCategory() публичный Метод

public SalesByCategory ( string categoryName, string ordYear ) : ObjectResult
categoryName string
ordYear string
Результат ObjectResult

Sales_by_Year() публичный Метод

public Sales_by_Year ( Nullable beginning_Date, Nullable ending_Date ) : ObjectResult
beginning_Date Nullable
ending_Date Nullable
Результат ObjectResult

Ten_Most_Expensive_Products() публичный Метод

public Ten_Most_Expensive_Products ( ) : ObjectResult
Результат ObjectResult

sp_alterdiagram() публичный Метод

public sp_alterdiagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
diagramname string
owner_id Nullable
version Nullable
definition byte
Результат int

sp_creatediagram() публичный Метод

public sp_creatediagram ( string diagramname, Nullable owner_id, Nullable version, byte definition ) : int
diagramname string
owner_id Nullable
version Nullable
definition byte
Результат int

sp_dropdiagram() публичный Метод

public sp_dropdiagram ( string diagramname, Nullable owner_id ) : int
diagramname string
owner_id Nullable
Результат int

sp_helpdiagramdefinition() публичный Метод

public sp_helpdiagramdefinition ( string diagramname, Nullable owner_id ) : ObjectResult
diagramname string
owner_id Nullable
Результат ObjectResult

sp_helpdiagrams() публичный Метод

public sp_helpdiagrams ( string diagramname, Nullable owner_id ) : ObjectResult
diagramname string
owner_id Nullable
Результат ObjectResult

sp_renamediagram() публичный Метод

public sp_renamediagram ( string diagramname, Nullable owner_id, string new_diagramname ) : int
diagramname string
owner_id Nullable
new_diagramname string
Результат int

sp_upgraddiagrams() публичный Метод

public sp_upgraddiagrams ( ) : int
Результат int

usp_GetTotalIncomesBySupplierNameAndPeriod() публичный Метод

public usp_GetTotalIncomesBySupplierNameAndPeriod ( string supplierName, Nullable startDate, Nullable endDate ) : ObjectResult>
supplierName string
startDate Nullable
endDate Nullable
Результат ObjectResult>