Knight Data Access Layer Specifications


"Take the shortcut to data access, saves you hours (or even days) of work and with the assurance of compile time data type checking, no more runtime errors!"

Martin Hart
Memory Soft

Knight Data Access Layer is the swiss army knife of Object Relational Mapping, Data Access, and LINQ. A key differentiator is the ability to automatically map from classes to tables without any mapping files, attributes, visual models, or convention definitions. The auto mapper can also map SQL and stored procedure results to classes without any mapping definition. When properties and database columns are named differently; mapping can be defined using attributes, code, or XML Mapping files. Auto increment primary keys, GUID primary keys, and composite keys are supported. Mappings can even be overridden at run time.

Knight Data Access Layer is compatible with SQL Server, Oracle, MySQL Firebird, SQLite, VistaDB, Microsoft Access or any ODBC or OLEDB compliant database. Custom database providers can be easily implemented.

There is no need to revert to ADO.NET as everything can be executed within the library. Typical operations are supported such as creating databases, creating tables, executing stored procedures, truncating tables, and executing straight SQL.

LINQ is fully supported for any select operations including: aggregate, union, skip, take and much more. Knight Data Access Layer supports LINQ to SQL Server, LINQ to Oracle, LINQ to MySql, LINQ to Sqlite, LINQ to VistaDb, LINQ to Firebird, and LINQ to Microsoft Access.

Code First Approach, Database First Approach, and No Approach (DataTables and Dictionaries) are all supported. Several generation features are included such as creating classes from tables, creating tables from classes, synchronizing namespaces to a database, generating table scripts, and generating upgrade scripts.

Knight Data Access Layer is SDLC Environmental friendly. Mappings for Schema/Owner plus table names can be switched on the fly at run time. This is useful for switching to a different test environment, switching to use staging tables, or switching to use archive versions of tables.

Common patterns are built in such as Unit of Work Pattern, Active Record Pattern, Repository Pattern, and Session Factory

Download the full list of features.

While it can be purchased separately, this product is also included in the Gold Suite. Gold Suite subscribers receive all product updates and all new products as part of a yearly subscription. It is the best value in the industry.

Buy Now Download

Business Benefits
Benefit Description
Saves Time Easily store and retrieve items to databases. Development takes less time than any other data access framework.
Saves Money 90% of the cost of most projects is maintenance. Developers that use Knight Data Access Layer will write less code. Less code to maintain means greater productivity.
Flexible A variety of options allows Knight Data Access Layer to interact with your database how your developers want to work.
High Performance Knight Data Access Layer supports servers with multiple CPUS and cores. It creates clean, high performance SQL that interacts with your database.
It will work in your environment Knight Data Access Layer can easily switch from Development, Test, User Acceptance Testing, and Production environments.
Documentation Industry standard formatted help and an easy to use demo is included.
Royalty Free Distribution Include with any .NET project royalty free.
1 Year Free Upgrades Purchase today and all upgrades are free for the next year.
60 Day Money Back Guarantee At Kellerman Software, we want you to be totally satisfied with your purchase. Receive a refund within 60 days when ordering from Source code versions are non-refundable due to their nature.
Lifetime Support Lifetime E-mail technical support is included.