C# 클래스 Northwind.Data.NorthwindEntities

상속: DbContext
파일 보기 프로젝트 열기: vladislav-karamfilov/TelerikAcademy 1 사용 예제들

공개 메소드들

메소드 설명
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>