I have mentioned LLBLGen Pro as my favorite O/R Mapper several times.
It came out with a new release today and it's list of new features speaks volumes as to how much this product has grown in functionality since it first came out. Frans just added Microsoft Access support to the product in addition to its support for Oracle, SQL Server, and Firebird.
A lot of really cool features in this new version of LLBLGen Pro that are going to make my life easier. To mention my 3 newly added favorite features:
- Paging Support - Paging support for collections/typed lists/typed views. Paging support is added to the fetch routines and various overloads of these fetch routines. Specify the page size and page number to retrieve a subset of the entities to retrieve.
- Self-Joins - Entities can be joined with self. This is the result of the multiple times an entity can be joined to a join set.
- Prefetch Paths - Various fetch routines (and entity instantiation constructors (selfservicing)) support Prefetch paths. A prefetch path is a graph definition of related entities to fetch together with the actual entity / entities to fetch. Prefetch paths form an efficient way to pull related data out of the database without the requirement to create a query per entity. Prefetch paths support filtering, sorting and support limitation on the amount of objects to return per parent entity. Prefetch paths result in 1 query per entity type, so fetching all orders with their related customers, will result in 2 queries, which are merged by the runtime library code. All relation types are supported, intermediate entities are not prefetched.
Frans has a complete list of new features in his recent post.