.netTiers are CodeSmith templates for object-relational mapping that takes an existing SQLServer database and automatically generates a personnalized Data Tiers application block to use in your .Net applications.
Core features include:
- Generates ready to use Visual Studio projects and solution.
- Fully integrate with Entreprise Library application blocks architecture. Shipped with it's own plugin, so you can configure your application directly from the entlib configuration console.
- Generate business entities with a 1:1 mapping ( an entity for each table or view, with a property for each column).
- Serializable
- trigger events
- Implements an IEntity interface, which contains the columns that are present in every table
- Specific support for enums.
- Each object has a concrete and a base class which it inherit from. The concrete class is generated just once, so you have can use it to add you custom code.
- Generate Data Access Layer Components (DALC) for tables and views , with following database operations :
- upport for basic CRUD: UPDATE, DELETE, INSERT, SELECT ALL, PAGED SELECT, FIND
- Support for queries using primary key
- Support for queries using foreign key
- Support for queries using keys that are part of an index
- Support for queries using keys that are part of a junction table
- Support for user defined Methods, generated from queries that are detected throught a very simple naming rule (_TableName_MyMethodName)
- Support for Deep loading and saving, with children type selection and optional recursivity.
- Support for find methods, with paging and sorting. (builded with the datagrid in mind :-)
- NEW: Support for SqlView.
- NEW: Select between stored procedure or xml embedded queries.
- Generate strongly-typed collections for entities and repositories.
- Implement CollectionBase , IBindingList, IList and ICloneable
- Sortable, even Unsortable ;-)
- bindable to datagrid, or any winform or asp.net controls
- It creates ASP.NET webservice for distributed programming.
- Create the stored procedures script and can automatically install them on the server.
- Generates a complete nAnt build file, to compile, test and generate chm/html API documentation.
- A full set of nUnit tests.
- the code is fully nDoc commented (it use to Description extended properties of the data table and column) and follow the microsoft naming guidelines.
- Open source ! You can modify the templates and contribute (http://www.nettiers.com/)