C# Class Acme.Northwind.EFDAL.NorthwindEntities

Inheritance: System.Data.Objects.ObjectContext, Acme.Northwind.EFDAL.Interfaces.INorthwindEntities, nHydrate.EFCore.DataAccess.IContext
Afficher le fichier Open project: nHydrate/nHydrate Class Usage Examples

Protected Properties

Свойство 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

Свойство Type Description
AddObject void
DeleteObject void
GetConnString string
GetConnectionString string
GetDatabaseExtendedProperty string
OnContextCreated void
SelectExtendedProperty string
nHydrate System.Enum
nHydrate System.Type
nHydrate object

Méthodes publiques

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

Méthodes protégées

Méthode Description
Acme ( Acme entity ) : void

Deletes an entity of type 'Category'

Private Methods

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

Deletes an entity of type 'Category'
protected Acme ( Acme entity ) : void
entity Acme The entity to delete
Résultat void

AddItem() public méthode

Adds an entity of type 'Category' to the object context
public AddItem ( Acme entity ) : void
entity Acme The entity to add
Résultat void

CategorizedSales() public méthode

public CategorizedSales ( string categoryname, string ordyear ) : IEnumerable
categoryname string
ordyear string
Résultat IEnumerable

CustOrderHist() public méthode

public CustOrderHist ( string customerid ) : IEnumerable
customerid string
Résultat IEnumerable

CustOrdersDetail() public méthode

public CustOrdersDetail ( int orderid ) : IEnumerable
orderid int
Résultat IEnumerable

CustOrdersOrders() public méthode

public CustOrdersOrders ( string customerid ) : IEnumerable
customerid string
Résultat IEnumerable

DeleteItem() public méthode

Deletes an entity of type 'Category'
public DeleteItem ( Acme entity ) : void
entity Acme The entity to delete
Résultat void

EmployeeSalesbyCountry() public méthode

public EmployeeSalesbyCountry ( System.DateTime beginningDate, System.DateTime endingDate ) : IEnumerable
beginningDate System.DateTime
endingDate System.DateTime
Résultat IEnumerable

GetEntityFromField() public static méthode

Determines the entity from one of its fields
public static GetEntityFromField ( Enum field ) : EntityMappingConstants
field System.Enum
Résultat EntityMappingConstants

GetMetaData() public static méthode

Gets the meta data object for an entity
public static GetMetaData ( Acme table ) : Acme.Northwind.EFDAL.Interfaces.IMetadata
table Acme
Résultat Acme.Northwind.EFDAL.Interfaces.IMetadata

GetNextSequntialGuid() public static méthode

public static GetNextSequntialGuid ( EntityMappingConstants entity, string key ) : System.Guid
entity EntityMappingConstants
key string
Résultat System.Guid

IsValidConnection() public méthode

Determines if the API matches the database connection
public IsValidConnection ( ) : bool
Résultat bool

IsValidConnection() public méthode

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
Résultat bool

NorthwindEntities() public méthode

Initializes a new NorthwindEntities object using the connection string found in the 'NorthwindEntities' section of the application configuration file.
public NorthwindEntities ( ) : System
Résultat System

NorthwindEntities() public méthode

Initialize a new NorthwindEntities object with an audit modifier.
public NorthwindEntities ( ContextStartup contextStartup ) : System
contextStartup ContextStartup
Résultat System

NorthwindEntities() public méthode

Initialize a new NorthwindEntities object with an audit modifier.
public NorthwindEntities ( ContextStartup contextStartup, string connectionString ) : System
contextStartup ContextStartup
connectionString string
Résultat System

NorthwindEntities() public méthode

Initialize a new NorthwindEntities object.
public NorthwindEntities ( System connection ) : System
connection System
Résultat System

NorthwindEntities() public méthode

Initialize a new NorthwindEntities object.
public NorthwindEntities ( string connectionString ) : System
connectionString string
Résultat System

ResetSequentialGuid() public static méthode

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

SalesbyYear() public méthode

public SalesbyYear ( System.DateTime beginningDate, System.DateTime endingDate ) : IEnumerable
beginningDate System.DateTime
endingDate System.DateTime
Résultat IEnumerable

SaveChanges() public méthode

Persists all updates to the data source and resets change tracking in the object context.
public SaveChanges ( SaveOptions options ) : int
options SaveOptions
Résultat int

TenMostExpensiveProducts() public méthode

public TenMostExpensiveProducts ( ) : IEnumerable
Résultat IEnumerable

Property Details

_alphabeticallistofproducts protected_oe property

The internal reference variable for the 'Alphabeticallistofproducts' object set
protected System.Data.Objects.ObjectSet _alphabeticallistofproducts
Résultat System.Data.Objects.ObjectSet

_category protected_oe property

The internal reference variable for the 'Category' object set
protected System.Data.Objects.ObjectSet _category
Résultat System.Data.Objects.ObjectSet

_categorysalesfor1997 protected_oe property

The internal reference variable for the 'CategorySalesfor1997' object set
protected System.Data.Objects.ObjectSet _categorysalesfor1997
Résultat System.Data.Objects.ObjectSet

_contextStartup protected_oe property

The audit modifier used to mark database edits
protected ContextStartup,Acme.Northwind.EFDAL _contextStartup
Résultat ContextStartup

_currentproductlist protected_oe property

The internal reference variable for the 'CurrentProductList' object set
protected System.Data.Objects.ObjectSet _currentproductlist
Résultat System.Data.Objects.ObjectSet

_customer protected_oe property

The internal reference variable for the 'Customer' object set
protected System.Data.Objects.ObjectSet _customer
Résultat System.Data.Objects.ObjectSet

_customerandsuppliersbycity protected_oe property

The internal reference variable for the 'CustomerandSuppliersbyCity' object set
protected System.Data.Objects.ObjectSet _customerandsuppliersbycity
Résultat System.Data.Objects.ObjectSet

_customercustomerdemo protected_oe property

The internal reference variable for the 'CustomerCustomerDemo' object set
protected System.Data.Objects.ObjectSet _customercustomerdemo
Résultat System.Data.Objects.ObjectSet

_customerdemographic protected_oe property

The internal reference variable for the 'CustomerDemographic' object set
protected System.Data.Objects.ObjectSet _customerdemographic
Résultat System.Data.Objects.ObjectSet

_employee protected_oe property

The internal reference variable for the 'Employee' object set
protected System.Data.Objects.ObjectSet _employee
Résultat System.Data.Objects.ObjectSet

_employeeterritorie protected_oe property

The internal reference variable for the 'EmployeeTerritorie' object set
protected System.Data.Objects.ObjectSet _employeeterritorie
Résultat System.Data.Objects.ObjectSet

_invoices protected_oe property

The internal reference variable for the 'Invoices' object set
protected System.Data.Objects.ObjectSet _invoices
Résultat System.Data.Objects.ObjectSet

_order protected_oe property

The internal reference variable for the 'Order' object set
protected System.Data.Objects.ObjectSet _order
Résultat System.Data.Objects.ObjectSet

_orderdetail protected_oe property

The internal reference variable for the 'OrderDetail' object set
protected System.Data.Objects.ObjectSet _orderdetail
Résultat System.Data.Objects.ObjectSet

_orderdetailsextended protected_oe property

The internal reference variable for the 'OrderDetailsExtended' object set
protected System.Data.Objects.ObjectSet _orderdetailsextended
Résultat System.Data.Objects.ObjectSet

_ordersqry protected_oe property

The internal reference variable for the 'OrdersQry' object set
protected System.Data.Objects.ObjectSet _ordersqry
Résultat System.Data.Objects.ObjectSet

_ordersubtotals protected_oe property

The internal reference variable for the 'OrderSubtotals' object set
protected System.Data.Objects.ObjectSet _ordersubtotals
Résultat System.Data.Objects.ObjectSet

_product protected_oe property

The internal reference variable for the 'Product' object set
protected System.Data.Objects.ObjectSet _product
Résultat System.Data.Objects.ObjectSet

_productsaboveaverageprice protected_oe property

The internal reference variable for the 'ProductsAboveAveragePrice' object set
protected System.Data.Objects.ObjectSet _productsaboveaverageprice
Résultat System.Data.Objects.ObjectSet

_productsalesfor1997 protected_oe property

The internal reference variable for the 'ProductSalesfor1997' object set
protected System.Data.Objects.ObjectSet _productsalesfor1997
Résultat System.Data.Objects.ObjectSet

_productsbycategory protected_oe property

The internal reference variable for the 'ProductsbyCategory' object set
protected System.Data.Objects.ObjectSet _productsbycategory
Résultat System.Data.Objects.ObjectSet

_quarterlyorders protected_oe property

The internal reference variable for the 'QuarterlyOrders' object set
protected System.Data.Objects.ObjectSet _quarterlyorders
Résultat System.Data.Objects.ObjectSet

_region protected_oe property

The internal reference variable for the 'Region' object set
protected System.Data.Objects.ObjectSet _region
Résultat System.Data.Objects.ObjectSet

_salesbycategory protected_oe property

The internal reference variable for the 'SalesbyCategory' object set
protected System.Data.Objects.ObjectSet _salesbycategory
Résultat System.Data.Objects.ObjectSet

_salestotalsbyamount protected_oe property

The internal reference variable for the 'SalesTotalsbyAmount' object set
protected System.Data.Objects.ObjectSet _salestotalsbyamount
Résultat System.Data.Objects.ObjectSet

_shipper protected_oe property

The internal reference variable for the 'Shipper' object set
protected System.Data.Objects.ObjectSet _shipper
Résultat System.Data.Objects.ObjectSet

_summaryofsalesbyquarter protected_oe property

The internal reference variable for the 'SummaryofSalesbyQuarter' object set
protected System.Data.Objects.ObjectSet _summaryofsalesbyquarter
Résultat System.Data.Objects.ObjectSet

_summaryofsalesbyyear protected_oe property

The internal reference variable for the 'SummaryofSalesbyYear' object set
protected System.Data.Objects.ObjectSet _summaryofsalesbyyear
Résultat System.Data.Objects.ObjectSet

_supplier protected_oe property

The internal reference variable for the 'Supplier' object set
protected System.Data.Objects.ObjectSet _supplier
Résultat System.Data.Objects.ObjectSet

_territory protected_oe property

The internal reference variable for the 'Territory' object set
protected System.Data.Objects.ObjectSet _territory
Résultat System.Data.Objects.ObjectSet