LLBLGen Pro by Solutions Design

Features

Productivity
Powerful code generation framework
LLBLGen Pro has a task-based code generator framework, which uses task-performing assemblies to perform task definitions, called task performers.

Written with performance in mind
The generated code is set up to be performing well in every scenario due to its merely stateless nature. The generated code has full support for connection pooling and connection control.

Legacy system friendly
LLBLGen Pro starts from the relational model / schema. This is ideal for creating a .NET layer for a legacy database already in use in your organization.

Custom Properties support
Custom properties are name-value pairs (both strings) which are generated as a static hashtable into the code and which can be defined on: Project, Entity, Entity field, Typed List, Typed List field, Typed View, Typed View field and stored procedure.

Relational model friendly
LLBLGen Pro doesn't require any special constructs in your relational model nor extra tables or columns. No locks are hold/set at runtime or during a transaction, other than the locks set by the RDBMS itself.

Mapping related
Four building blocks for your code: Entities, Typed Lists, Typed Views and Stored Procedure calls.
Entities, which are elements mapped onto tables or views in your catalog(s)/schema set.
Typed Lists are read-only lists based on a subset of fields from one or more entities which have a relation (1:1, 1:n or m:1).
Typed Views are read-only view definitions which are 1:1 mapped on views in the catalog/schema set.
Stored Procedure calls are call definitions to existing stored procedures.

Fields mapped on related fields
The LLBLGen Pro designer allows you to map fields on entity fields of related entities, if that entity has one or more 1:1 or m:1 relations with another entity (or itself).

All database data types are supported
All database types made available by the databases currently supported are usable with LLBLGen Pro. An exception are the user defined types in Oracle and DB2, due to a restriction in ADO.NET.

Ability to specify abbreviations to full word sets
Per project, you can specify abbreviations to full word sets, so names constructed for entities, entity fields, typedviews, typed view fields, stored procedure calls and stored procedure call parameters will now take into account any abbreviation - full word pairs specified.

True database independent code: Type Converters
LLBLGen Pro supports powerful .NET type conversion capabilities. Using type converters, you can map a field using any .NET type onto any database type. The conversion of data is done behind the scenes, transparently.

Constraint transparency
LLBLGen Pro migrates unique constraints to methods for fetching data using these constraints and migrates all found foreign key constraints to relations between entities (1:1, 1:n, m:n, m:1), fully automatically. It can find any m:n relation available in your database model, even relations you haven't thought of.

Full XML serialization support
Entity object hierarchies can be saved as XML (even with cyclic references) and be fully re-instantiated from XML. LLBLGen Pro supports both compact XML (without type information) and verbose XML (with type information) and various other options to control the XML serialization.

Full XML Webservice / WCF support
Entity object hierarchies and single objects can be returned from and passed to an XML webservice or WCF service, all XML production/consumption is being taken care of by the LLBLGen Pro runtime code. Please read the documentation for more details on this feature.

Full binary serialization support
All objects are serializable, which means they can be used in any remoting scenario.
You can use normal serialization based on the .NET BinaryFormatter logic or LLBLGen Pro's own, super fast and compact serialization logic.

Database driver architecture (provider model)
Each database type is targeted using a custom driver, so that LLBLGen Pro can work with each database without knowing details about that database.

Full support for all relation types
Full support for 1:1, 1:n, m:1 and m:n relations. All relations are auto-detected. You can add your own in the designer, hide auto-detected relations you don't need.