C# Class Acme.Northwind.EFDAL.NorthwindEntities

Inheritance: System.Data.Objects.ObjectContext, Acme.Northwind.EFDAL.Interfaces.INorthwindEntities, nHydrate.EFCore.DataAccess.IContext
Datei anzeigen 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