Habanero is an object-relational mapping (ORM) architecture for .Net that maps object-oriented code to relational databases. It persists data to and from the database and generates user interfaces to edit the object's properties. Habanero can read class design from the database and generate code for the business objects to be mapped.

Features:

- Uses one XML file to map database tables to objects
- Support for MySQL, SQL Server, Access, Oracle, PostgreSQL
- Ability to set load criteria
- Choice between raw SQL and controlled object-based equivalent
- Support for object inheritance and relationships
- Support for nullable types and generic collections
- Choice between single or composite primary keys
- Migration support to upgrade databases of outdated client installations
- Validation/property rules
- FireStarter GUI application to manage class definitions XML
- Generation of UI grids and forms to edit data and persist changes
- Reverse engineer class definitions from an existing database
- Code generation from class definitions
- Dynamic generation of lookup lists from the database