Top level namespace used for interacting with a database.
Classes
| Class | Description |
![Class](template/packages/core-dotnet/images/Class.png) | AutoMap |
Map objects, table names, and sql to database tables
|
![Class](template/packages/core-dotnet/images/Class.png) | BaseActiveRecord<T> |
Implements active record pattern for loading, saving and deleting records
|
![Class](template/packages/core-dotnet/images/Class.png) | BaseDatabaseProvider |
Base class that database providers must implement
|
![Class](template/packages/core-dotnet/images/Class.png) | BaseRepository<T> |
Implements Repository Pattern
|
![Class](template/packages/core-dotnet/images/Class.png) | BaseStoredProcedureProvider |
General methods for interacting with stored procedures
|
![Class](template/packages/core-dotnet/images/Class.png) | Compression |
LZO Compression Compatible with .NET, Silverlight and Windows Phone 7
|
![Class](template/packages/core-dotnet/images/Class.png) | CreateClassLogic |
Logic to create a C# class from a table
|
![Class](template/packages/core-dotnet/images/Class.png) | CreateVbClassLogic |
Logic to create VB Classes from a table
|
![Class](template/packages/core-dotnet/images/Class.png) | DataHelper |
The main Data Access Layer that interacts with everything else
|
![Class](template/packages/core-dotnet/images/Class.png) | Field |
Class representing a corresponding field for a column in a table
|
![Class](template/packages/core-dotnet/images/Class.png) | ForeignKeyConstraint |
Holds information about the a Foreign Constraint
|
![Class](template/packages/core-dotnet/images/Class.png) | Index |
Holds information about an index
|
![Class](template/packages/core-dotnet/images/Class.png) | IndexColumn |
Column for an index
|
![Class](template/packages/core-dotnet/images/Class.png) | MaintenanceField |
Information about maintenance fields such as CreateDate, UpdateDate etc.
|
![Class](template/packages/core-dotnet/images/Class.png) | MaintenanceFieldLogic |
Get a list of default maintenance fields
|
![Class](template/packages/core-dotnet/images/Class.png) | MappingException |
Occurs when a class cannot be mapped to a table
|
![Class](template/packages/core-dotnet/images/Class.png) | NetDataAccessLayerException |
Thrown when any exception occurs in the database
|
![Class](template/packages/core-dotnet/images/Class.png) | NullIdentity |
The provider does not implement Identity or Auto Increment Columns. Null Object design pattern.
|
![Class](template/packages/core-dotnet/images/Class.png) | NullStoredProcedureProvider |
The database provider cannot use stored procedures. Null Object design pattern.
|
![Class](template/packages/core-dotnet/images/Class.png) | ObjectCrud |
Create, Read, Update, Delete Methods for objects
|
![Class](template/packages/core-dotnet/images/Class.png) | OpenCloseWrapper |
Open the database connection when instantiated and close when disposed.
|
![Class](template/packages/core-dotnet/images/Class.png) | PagingParameters |
Specify the how the records should be retreived for a table
|
![Class](template/packages/core-dotnet/images/Class.png) | Pluralization |
Methods to make words plural or singular
|
![Class](template/packages/core-dotnet/images/Class.png) | PrimaryKeyHelper |
Methods for detecting primary and composite keys by the schema
|
![Class](template/packages/core-dotnet/images/Class.png) | ReflectionHelper |
Class used for Caching Reflection
|
![Class](template/packages/core-dotnet/images/Class.png) | SqlException |
Occurs when the SQL could not be executed for the current database provider
|
![Class](template/packages/core-dotnet/images/Class.png) | Table |
Class that represents a corresponding table in the database and the mapping to the class
|
![Class](template/packages/core-dotnet/images/Class.png) | TableCrud |
Create, Read, Update, Delete Methods to interact with Tables
|
![Class](template/packages/core-dotnet/images/Class.png) | UnitOfWork |
Wrap a series of actions in a transaction. On dispose the transaction is committed.
If the database connection is closed, it will be opened and closed automatically
If the database connection is already open, it will be left open
|
Interfaces
| Interface | Description |
![Interface](template/packages/core-dotnet/images/Interface.png) | IAutoMap |
Map objects, table names, and sql to database tables
|
![Interface](template/packages/core-dotnet/images/Interface.png) | IDatabaseProvider |
General methods for dealing with databases
|
![Interface](template/packages/core-dotnet/images/Interface.png) | IDataHelper |
Main interface for the Knight Data Access Layer
|
![Interface](template/packages/core-dotnet/images/Interface.png) | IIdentity |
The provider implements Identity or Auto Increment Columns
|
![Interface](template/packages/core-dotnet/images/Interface.png) | IIndexProvider |
The provider has the ability to create indexes
|
![Interface](template/packages/core-dotnet/images/Interface.png) | ILimitProvider |
Generate SQL for a limit clause
|
![Interface](template/packages/core-dotnet/images/Interface.png) | IObjectCrud |
Interface for the Object Crud Class
Documentation:
|
![Interface](template/packages/core-dotnet/images/Interface.png) | IPagingProvider |
Provide the ability to generate SQL that will get a page of records
|
![Interface](template/packages/core-dotnet/images/Interface.png) | IRecordHook |
Interface used for BeforeInsert, BeforeUpdate, BeforeDelete, AfterInsert, AfterUpdate, and AfterDelete events
|
![Interface](template/packages/core-dotnet/images/Interface.png) | ITableCrud |
Interface for the Table Crud Class
|
![Interface](template/packages/core-dotnet/images/Interface.png) | ITopProvider |
Providers that implement this interface can generate a top SQL clause or a first SQL Clause
|
Enumerations
| Enumeration | Description |
![Enumeration](template/packages/core-dotnet/images/Enumeration.png) | ForeignKeyAction |
The action taken when a user tries to delete or update a key to which existing foreign keys point
|
![Enumeration](template/packages/core-dotnet/images/Enumeration.png) | MaintenanceFieldType |
Determines how maintenance fields will be filled in
|
See Also