C# Class Acme.Northwind.EFDAL.NorthwindEntities

Inheritance: System.Data.Objects.ObjectContext, Acme.Northwind.EFDAL.Interfaces.INorthwindEntities, nHydrate.EFCore.DataAccess.IContext

ファイルを表示 Open project: nHydrate/nHydrate Class Usage Examples

Protected Properties

Property	Type	Description
_alphabeticallistofproducts	System.Data.Objects.ObjectSet
_category	System.Data.Objects.ObjectSet
_categorysalesfor1997	System.Data.Objects.ObjectSet
_contextStartup	ContextStartup
_currentproductlist	System.Data.Objects.ObjectSet
_customer	System.Data.Objects.ObjectSet
_customerandsuppliersbycity	System.Data.Objects.ObjectSet
_customercustomerdemo	System.Data.Objects.ObjectSet
_customerdemographic	System.Data.Objects.ObjectSet
_employee	System.Data.Objects.ObjectSet
_employeeterritorie	System.Data.Objects.ObjectSet
_invoices	System.Data.Objects.ObjectSet
_order	System.Data.Objects.ObjectSet
_orderdetail	System.Data.Objects.ObjectSet
_orderdetailsextended	System.Data.Objects.ObjectSet
_ordersqry	System.Data.Objects.ObjectSet
_ordersubtotals	System.Data.Objects.ObjectSet
_product	System.Data.Objects.ObjectSet
_productsaboveaverageprice	System.Data.Objects.ObjectSet
_productsalesfor1997	System.Data.Objects.ObjectSet
_productsbycategory	System.Data.Objects.ObjectSet
_quarterlyorders	System.Data.Objects.ObjectSet
_region	System.Data.Objects.ObjectSet
_salesbycategory	System.Data.Objects.ObjectSet
_salestotalsbyamount	System.Data.Objects.ObjectSet
_shipper	System.Data.Objects.ObjectSet
_summaryofsalesbyquarter	System.Data.Objects.ObjectSet
_summaryofsalesbyyear	System.Data.Objects.ObjectSet
_supplier	System.Data.Objects.ObjectSet
_territory	System.Data.Objects.ObjectSet

Private Properties

Property	Type	Description
AddObject	void
DeleteObject	void
GetConnString	string
GetConnectionString	string
GetDatabaseExtendedProperty	string
OnContextCreated	void
SelectExtendedProperty	string
nHydrate	System.Enum
nHydrate	System.Type
nHydrate	object

Public Methods

Method	Description
AddItem ( Acme entity ) : void	Adds an entity of type 'Category' to the object context
CategorizedSales ( string categoryname, string ordyear ) : IEnumerable
CustOrderHist ( string customerid ) : IEnumerable
CustOrdersDetail ( int orderid ) : IEnumerable
CustOrdersOrders ( string customerid ) : IEnumerable
DeleteItem ( Acme entity ) : void	Deletes an entity of type 'Category'
EmployeeSalesbyCountry ( System.DateTime beginningDate, System.DateTime endingDate ) : IEnumerable
GetEntityFromField ( Enum field ) : EntityMappingConstants	Determines the entity from one of its fields
GetMetaData ( Acme table ) : Acme.Northwind.EFDAL.Interfaces.IMetadata	Gets the meta data object for an entity
GetNextSequntialGuid ( EntityMappingConstants entity, string key ) : System.Guid
IsValidConnection ( ) : bool	Determines if the API matches the database connection
IsValidConnection ( bool checkVersion ) : bool	Determines if the API matches the database connection
NorthwindEntities ( ) : System	Initializes a new NorthwindEntities object using the connection string found in the 'NorthwindEntities' section of the application configuration file.
NorthwindEntities ( ContextStartup contextStartup ) : System	Initialize a new NorthwindEntities object with an audit modifier.
NorthwindEntities ( ContextStartup contextStartup, string connectionString ) : System	Initialize a new NorthwindEntities object with an audit modifier.
NorthwindEntities ( System connection ) : System	Initialize a new NorthwindEntities object.
NorthwindEntities ( string connectionString ) : System	Initialize a new NorthwindEntities object.
ResetSequentialGuid ( EntityMappingConstants entity, string key, System.Guid seed ) : void
SalesbyYear ( System.DateTime beginningDate, System.DateTime endingDate ) : IEnumerable
SaveChanges ( SaveOptions options ) : int	Persists all updates to the data source and resets change tracking in the object context.
TenMostExpensiveProducts ( ) : IEnumerable

Protected Methods

Method	Description
Acme ( Acme entity ) : void	Deletes an entity of type 'Category'

Private Methods

Method	Description
AddObject ( string entitySetName, object entity ) : void
DeleteObject ( object entity ) : void
GetConnString ( ) : string
GetConnectionString ( ) : string
GetDatabaseExtendedProperty ( string connectionString, string propertyName ) : string
OnContextCreated ( ) : void
SelectExtendedProperty ( string connectionString, string property, string user, string table, string parameter ) : string
nHydrate ( Enum field ) : Enum
nHydrate ( Enum field ) : Type
nHydrate ( Enum entity ) : object

Method Details

Acme() protected method

Deletes an entity of type 'Category'

protected Acme ( Acme entity ) : void
entity	Acme	The entity to delete
return	void

AddItem() public method

Adds an entity of type 'Category' to the object context

public AddItem ( Acme entity ) : void
entity	Acme	The entity to add
return	void

CategorizedSales() public method

public CategorizedSales ( string categoryname, string ordyear ) : IEnumerable
categoryname	string
ordyear	string
return	IEnumerable

CustOrderHist() public method

public CustOrderHist ( string customerid ) : IEnumerable
customerid	string
return	IEnumerable

CustOrdersDetail() public method

public CustOrdersDetail ( int orderid ) : IEnumerable
orderid	int
return	IEnumerable

CustOrdersOrders() public method

public CustOrdersOrders ( string customerid ) : IEnumerable
customerid	string
return	IEnumerable

DeleteItem() public method

Deletes an entity of type 'Category'

public DeleteItem ( Acme entity ) : void
entity	Acme	The entity to delete
return	void

EmployeeSalesbyCountry() public method

public EmployeeSalesbyCountry ( System.DateTime beginningDate, System.DateTime endingDate ) : IEnumerable
beginningDate	System.DateTime
endingDate	System.DateTime
return	IEnumerable

GetEntityFromField() public static method

Determines the entity from one of its fields

public static GetEntityFromField ( Enum field ) : EntityMappingConstants
field	System.Enum
return	EntityMappingConstants

GetMetaData() public static method

Gets the meta data object for an entity

public static GetMetaData ( Acme table ) : Acme.Northwind.EFDAL.Interfaces.IMetadata
table	Acme
return	Acme.Northwind.EFDAL.Interfaces.IMetadata

GetNextSequntialGuid() public static method

public static GetNextSequntialGuid ( EntityMappingConstants entity, string key ) : System.Guid
entity	EntityMappingConstants
key	string
return	System.Guid

IsValidConnection() public method

Determines if the API matches the database connection

public IsValidConnection ( ) : bool
return	bool

IsValidConnection() public method

Determines if the API matches the database connection

public IsValidConnection ( bool checkVersion ) : bool
checkVersion	bool	Determines if the check also includes the exact version of the model
return	bool

NorthwindEntities() public method

Initializes a new NorthwindEntities object using the connection string found in the 'NorthwindEntities' section of the application configuration file.

public NorthwindEntities ( ) : System
return	System

NorthwindEntities() public method

Initialize a new NorthwindEntities object with an audit modifier.

public NorthwindEntities ( ContextStartup contextStartup ) : System
contextStartup	ContextStartup
return	System

NorthwindEntities() public method

Initialize a new NorthwindEntities object with an audit modifier.

public NorthwindEntities ( ContextStartup contextStartup, string connectionString ) : System
contextStartup	ContextStartup
connectionString	string
return	System

NorthwindEntities() public method

Initialize a new NorthwindEntities object.

public NorthwindEntities ( System connection ) : System
connection	System
return	System

NorthwindEntities() public method

Initialize a new NorthwindEntities object.

public NorthwindEntities ( string connectionString ) : System
connectionString	string
return	System

ResetSequentialGuid() public static method

public static ResetSequentialGuid ( EntityMappingConstants entity, string key, System.Guid seed ) : void
entity	EntityMappingConstants
key	string
seed	System.Guid
return	void

SalesbyYear() public method

public SalesbyYear ( System.DateTime beginningDate, System.DateTime endingDate ) : IEnumerable
beginningDate	System.DateTime
endingDate	System.DateTime
return	IEnumerable

SaveChanges() public method

Persists all updates to the data source and resets change tracking in the object context.

public SaveChanges ( SaveOptions options ) : int
options	SaveOptions
return	int

TenMostExpensiveProducts() public method

public TenMostExpensiveProducts ( ) : IEnumerable
return	IEnumerable

Property Details

_alphabeticallistofproducts protected_oe property

The internal reference variable for the 'Alphabeticallistofproducts' object set

protected System.Data.Objects.ObjectSet _alphabeticallistofproducts
return	System.Data.Objects.ObjectSet

_category protected_oe property

The internal reference variable for the 'Category' object set

protected System.Data.Objects.ObjectSet _category
return	System.Data.Objects.ObjectSet

_categorysalesfor1997 protected_oe property

The internal reference variable for the 'CategorySalesfor1997' object set

protected System.Data.Objects.ObjectSet _categorysalesfor1997
return	System.Data.Objects.ObjectSet

_contextStartup protected_oe property

The audit modifier used to mark database edits

protected ContextStartup,Acme.Northwind.EFDAL _contextStartup
return	ContextStartup

_currentproductlist protected_oe property

The internal reference variable for the 'CurrentProductList' object set

protected System.Data.Objects.ObjectSet _currentproductlist
return	System.Data.Objects.ObjectSet

_customer protected_oe property

The internal reference variable for the 'Customer' object set

protected System.Data.Objects.ObjectSet _customer
return	System.Data.Objects.ObjectSet

_customerandsuppliersbycity protected_oe property

The internal reference variable for the 'CustomerandSuppliersbyCity' object set

protected System.Data.Objects.ObjectSet _customerandsuppliersbycity
return	System.Data.Objects.ObjectSet

_customercustomerdemo protected_oe property

The internal reference variable for the 'CustomerCustomerDemo' object set

protected System.Data.Objects.ObjectSet _customercustomerdemo
return	System.Data.Objects.ObjectSet

_customerdemographic protected_oe property

The internal reference variable for the 'CustomerDemographic' object set

protected System.Data.Objects.ObjectSet _customerdemographic
return	System.Data.Objects.ObjectSet

_employee protected_oe property

The internal reference variable for the 'Employee' object set

protected System.Data.Objects.ObjectSet _employee
return	System.Data.Objects.ObjectSet

_employeeterritorie protected_oe property

The internal reference variable for the 'EmployeeTerritorie' object set

protected System.Data.Objects.ObjectSet _employeeterritorie
return	System.Data.Objects.ObjectSet

_invoices protected_oe property

The internal reference variable for the 'Invoices' object set

protected System.Data.Objects.ObjectSet _invoices
return	System.Data.Objects.ObjectSet

_order protected_oe property

The internal reference variable for the 'Order' object set

protected System.Data.Objects.ObjectSet _order
return	System.Data.Objects.ObjectSet

_orderdetail protected_oe property

The internal reference variable for the 'OrderDetail' object set

protected System.Data.Objects.ObjectSet _orderdetail
return	System.Data.Objects.ObjectSet

_orderdetailsextended protected_oe property

The internal reference variable for the 'OrderDetailsExtended' object set

protected System.Data.Objects.ObjectSet _orderdetailsextended
return	System.Data.Objects.ObjectSet

_ordersqry protected_oe property

The internal reference variable for the 'OrdersQry' object set

protected System.Data.Objects.ObjectSet _ordersqry
return	System.Data.Objects.ObjectSet

_ordersubtotals protected_oe property

The internal reference variable for the 'OrderSubtotals' object set

protected System.Data.Objects.ObjectSet _ordersubtotals
return	System.Data.Objects.ObjectSet

_product protected_oe property

The internal reference variable for the 'Product' object set

protected System.Data.Objects.ObjectSet _product
return	System.Data.Objects.ObjectSet

_productsaboveaverageprice protected_oe property

The internal reference variable for the 'ProductsAboveAveragePrice' object set

protected System.Data.Objects.ObjectSet _productsaboveaverageprice
return	System.Data.Objects.ObjectSet

_productsalesfor1997 protected_oe property

The internal reference variable for the 'ProductSalesfor1997' object set

protected System.Data.Objects.ObjectSet _productsalesfor1997
return	System.Data.Objects.ObjectSet

_productsbycategory protected_oe property

The internal reference variable for the 'ProductsbyCategory' object set

protected System.Data.Objects.ObjectSet _productsbycategory
return	System.Data.Objects.ObjectSet

_quarterlyorders protected_oe property

The internal reference variable for the 'QuarterlyOrders' object set

protected System.Data.Objects.ObjectSet _quarterlyorders
return	System.Data.Objects.ObjectSet

_region protected_oe property

The internal reference variable for the 'Region' object set

protected System.Data.Objects.ObjectSet _region
return	System.Data.Objects.ObjectSet

_salesbycategory protected_oe property

The internal reference variable for the 'SalesbyCategory' object set

protected System.Data.Objects.ObjectSet _salesbycategory
return	System.Data.Objects.ObjectSet

_salestotalsbyamount protected_oe property

The internal reference variable for the 'SalesTotalsbyAmount' object set

protected System.Data.Objects.ObjectSet _salestotalsbyamount
return	System.Data.Objects.ObjectSet

_shipper protected_oe property

The internal reference variable for the 'Shipper' object set

protected System.Data.Objects.ObjectSet _shipper
return	System.Data.Objects.ObjectSet

_summaryofsalesbyquarter protected_oe property

The internal reference variable for the 'SummaryofSalesbyQuarter' object set

protected System.Data.Objects.ObjectSet _summaryofsalesbyquarter
return	System.Data.Objects.ObjectSet

_summaryofsalesbyyear protected_oe property

The internal reference variable for the 'SummaryofSalesbyYear' object set

protected System.Data.Objects.ObjectSet _summaryofsalesbyyear
return	System.Data.Objects.ObjectSet

_supplier protected_oe property

The internal reference variable for the 'Supplier' object set

protected System.Data.Objects.ObjectSet _supplier
return	System.Data.Objects.ObjectSet

_territory protected_oe property

The internal reference variable for the 'Territory' object set

protected System.Data.Objects.ObjectSet _territory
return	System.Data.Objects.ObjectSet