Introduction

Kerosene ORM is a self-adaptive and configuration-less ORM library, specifically developed completely support POCO objects, and with a SQL-like syntax based on C# dynamics.

You don't have to use, write or maintain any configuration files: Kerosene ORM will dynamically adapt itself to whatever schema your database has or is returned from the database. Indeed, it does only assume that you have a minimal information about your database: basically the names of the tables and columns you are interested in. You don't even have to know what of those are your primary key columns, which, by the way, are not even required in Kerosene.

It has been specifically designed for complete support of POCO objects, so you don't have to modify your business classes with any database related stuff or to write any wrapper classes. Along with the above it provides a very resilient mechanism because as far as those table and column names don't change it doesn't matter what changes your database will experiment: your solution will continue to operate without problems.

And with a creative use of dynamic lambda expressions, it allows you to write your commands using a logic and syntax that closely resembles the SQL one. This feature open the door to very interesting tricks, as the ability to write your logic using a syntax that the C# compiler is not supposed to allow.

This documentation covers the following topics:

Installation

The download package comes with the source code for the Kerosene ORM library. You will need .NET 4.0 or later to compile it.

It also comes with some test programs. These examples are built for the Microsoft SQL Server adaptation that is also included in the package as an example. The scripts used to create the example database and some initial contents are also included.