Knight Data Access Layer
IDataHelper Interface Members
Properties  Methods 

KellermanSoftware.NetDataAccessLayer Namespace : IDataHelper Interface

The following tables list the members exposed by IDataHelper.

Public Properties
 NameDescription
 Property Set to intercept an object after a record is deleted  
 Property Set to intercept an object after a record is inserted  
 Property Set to intercept an objet after it is read  
 Property Set to intercept an object after a record is updated  
 Property Set to intercept an object before a record is deleted  
 Property Set to intercept an object before a record is inserted  
 Property Set to intercept an object before a record is updated  
 PropertyGet a reference to the current connection  
 PropertyGet or set the Connection String of the Database Provider  
 Property Used for viewing the internal level of nested transactions. Each Begin Transaction adds 1. Each Commit Transaction subtracts 1.  
 PropertyIf true, properties such as CreateDate, UpdateDate, CreateUser will be automatically filled in before saving The default is true  
 PropertyTrue if the connection is open  
 Property Gets a value indicating whether the provider is file based database.  
 PropertyReturns true if we are in a transaction  
 Property The license key associated with a license. See the License Key on your receipt.  
 PropertyA list of the names maintenance fields that will be filled in automatically such as CreateDate, UpdateDate, CreateUser  
 PropertyMap objects, table names, and sql to database tables  
 Property When true, Inner Begin Transactions and Commit Transactions are allowed. Inner Commits do not actually commit until the outermost commit has occured. Default is false. Nested transactions are useful for rolling back integration tests.  
 PropertyGet or Set the Prefix used for Parameters  
 Property Get the type of the provider  
 PropertyIf true, defaults will be set in the object before it is sent to the database. The default is false  
 PropertyReturns true if the attached database provider supports identity columns  
 PropertyReturns true if the attached database provider supports stored procedures  
 PropertyGet a reference to the current transaction  
 Property The user name associated with a license. See the User Name on your receipt.  
Top
Public Methods
 NameDescription
 Method Adds the column to the passed in table  
 Method Adds the maintenance fields to the passed in table  
 MethodOverloaded.  Returns true if any records exist in a table  
 MethodBegin a new transaction  
 Method Change database  
 MethodOverloaded. Clear the file log  
 MethodClose the database connection  
 MethodCommit the current transaction  
 MethodOpens and closes the connection to ensure it is valid  
 Method Return the count of records in the table  
 Method Create classes for the current database in the passed in namespace  
 Method Create a C# class from a table  
 MethodOverloaded.  Create new database  
 Method Create an index  
 Method Create a LINQ query using an enhanced version of the IQToolkit  
 Method Create a table in the database based on the passed class  
 MethodOverloaded.  Create a table in the database for each class that is in the passed in namespace  
 Method Create a VB.NET class from a table  
 MethodOverloaded.  Check database existance  
 MethodOverloaded. Delete a record where all parameters are equal  
 Method Delete an object by the primary key  
 MethodOverloaded.  Delete an object by the primary key and all its children  
 MethodDisable all logging  
 MethodClose the connection on dispose  
 Method Drop (remove) a table's sequence from database  
 MethodOverloaded.  Drop a table associated with a class  
 Method Drop (remove) a sequence's trigger from database  
 MethodOverloaded. Log to the console  
 MethodOverloaded. Execute the passed query and return the number of affected records  
 MethodOverloaded. Execute the passed stored procedure and return the number of affected records  
 MethodOverloaded. Execute the passed query and return the first column of the first row  
 MethodOverloaded. Execute the passed stored procedure and return the first column of the first row  
 MethodOverloaded. Fill the passed data table with the passed query  
 Method Returns true if the Foreign Key Exists  
 MethodOverloaded.  Create the SQL needed to create all the tables for the namespace  
 Method Generate the SQL for creating the list of tables  
 MethodOverloaded.  Create the SQL needed to upgrade all the tables for the namespace  
 Method Generate SQL to upgrade a single table  
 Method Gets all foreign key constraints for a database  
 MethodGet a list of the databases or schemas on the database server. For providers that do not support multiple databases or schemas, the list will be empty.  
 MethodGet the date of the database server. For providers that do not have a database date, DateTime.Now is returned.  
 MethodGet a list of tables in the current database, sorted alphabetically  
 Method Get the database field type for the passed standard DbType. Used internally for creating tables. Can be also used externally for code generation.  
 MethodOverloaded.  Get a datatable from the passed query  
 Method Get the DbType for provided ClrType. Used internally for creating tables. Can be also used externally for code generation.  
 MethodGet the last identity that was inserted  
 MethodGet the SQL used to get the identity for the last inserted record  
 Method Gets the indexes for a table.  
 Method Load a child or a parent by the property name lambda  
 MethodOverloaded. Get the maximum value for a primary key.  
 Method Get the object map for the passed class. Useful for code generation or getting schema information.  
 Method Detect if an index exists  
 MethodOverloaded. Insert a record into the table  
 MethodOverloaded. Get a list of dictionary records using the passed SQL  
 MethodOverloaded. Load all the records from a table into a class list  
 MethodOverloaded.  Load all the records from a table and its children and parents into a class list  
 MethodLoad records based on a column into a class list  
 Method Same as LoadByColumn except it loads all children  
 MethodLoad a single record using the primary key  
 MethodOverloaded. Get a list of records using the passed Stored Procedure  
 MethodOverloaded.  Load a list of objects from a stored procedure with all children  
 MethodOverloaded. Return a list of items with the primary key and the first string column ordered by the first string column  
 MethodOverloaded. Get a single record for a table and a parameterized where clause and return a dictionary.  
 MethodOverloaded.  Load a page of records that are filtered by a where clause and ordered  
 MethodOverloaded.  Load a page of records with children that are filtered by a where clause and ordered  
 MethodOverloaded.  Get a limited number of records for a table  
 MethodOverloaded.  Load entities matching the passed in where clause  
 MethodOverloaded.  Load a record by the primary key with all parents and children  
 MethodOpen the database connection  
 MethodOverloaded. Returns true if the record exists  
 MethodPerform a rollback of the current transaction  
 MethodOverloaded. Inserts, Updates or Deletes a record in the table. If the primary key is zero or null, it is an insert otherwise an update. If IsDeleted is set, the record is deleted.  
 MethodOverloaded.  Save an object with its parent and children  
 MethodOverloaded. Search for records based on the passed in search object. If the value is null or the default value, then the item will not be part of the where clause.  
 Method Count the number of records for a search  
 Method Set the foreign primaryKey of the child object to the primaryKey of the parent object. This is done automatically for SaveWithChildren  
 MethodOverloaded.  Create the database if it does not exist. Create tables that do not exist. Create columns that do not exist.  
 MethodReturns true if the passed stored procedure exists in the database  
 MethodOverloaded.  Synchronize table structure for each class that is in the passed in namespace  
 Method Synchronize table structure with the specified by typeparam class  
 Method Create/Update a table and fill with values from an enum.  
 MethodOverloaded. Returns true if the passed table exists in the database  
 MethodOverloaded.  Delete all the records from a table  
 MethodOverloaded.  Update a record in the database by the primary key  
Top
See Also

Reference

IDataHelper Interface
KellermanSoftware.NetDataAccessLayer Namespace