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:
  • Kerosene Basics: A tutorial about the core mode of operation of Kerosene.
  • Kerosene Maps: Using the Kerosene's Entity Framework mechanism.
  • Kerosene WCF: Using Kerosene in WCF scenarios.
  • How to Expand Kerosene: Explains how to expand Kerosene to build support for other databases or specialized scenarios.
  • Kerosene Internals: For those of you that will appreciate a deep dive into the Kerosene internal details.


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.

Last edited Sep 24, 2012 at 5:44 PM by mbarbac, version 30


No comments yet.