News

LLBLGen Pro v3.0 is here!

LLBLGen Pro v3.0 video

• Abbreviation support (example: convert 'Qty' into 'Quantity' during name construction)
  
• Flexible, framework specific settings
  
• Attribute definitions for various elements (so no requirement for buddy-classes or messing with generated code or templates)
  
• Retrieval of relational model data from a database
  
• Reverse engineering of tables into entities, automatically placed in groups
  
• Auto-creation of inheritance hierarchies
  
• Refactoring of entity fields into Value Type Definitions (DDD)
  
• Mapping a Typed view onto a stored procedure resultset
  
• Creation of a Typed list (definition of a query with a projection) on a set of related entities
  
• Validation and correction of found inconsistencies and errors
  
• Generating code using one of the pre-defined presets
  
• Illustration of the code in vs.net 2010

v3.0 pricing

.NET 4.0/VS.NET 2010 support added

v3.0 beta is here!

v3.0 QuickModel Video

Slightly updated roadmap

Additional downloads updated

v3.0 schedule

Additional downloads available for demo users

LLBLGen Pro v2.6 released!

Pricing changes

Trial issue fixed

LLBLGen Pro v2.5 is here!

LLBLGen Pro v2.5 beta released!

HnD has been released!

LLBLGen Pro 1.0.2005.1 Released!

Drivers

Changed

• All type enums are now public
• Firebird driver is now build against v1.7a of the Firebird.NET provider
• Sqlserver's driver now always reads the @@IDENTITY sequence as well, so users can set entity field sequences to @@IDENTITY instead of SCOPE_IDENTITY() if they want to. This is required for entities mapped onto views and which are used with instead-of triggers. The driver now also signals calling code that the user can select a sequence, so in the designer a user can now select a sequence for a field in an entity, this isn't disabled anymore for projects targeting SqlServer.

Added

• SqlServer driver: support for Xml types in SqlServer 2005
• Oracle drivers using ODP.NET: support for XMLType types in Oracle 9i/10g

Runtime Libraries

Changed

• Adapter: Catalog name overwriting at runtime has been reworked. You can now pass in a CatalogNameOverwriteHashtable which contains all the name value pairs and the setting what to use. Internally the DataAccessAdapter uses this setting as well. Name overwriting is now done by the DQE at fieldname construction, not when the fieldpersistenceinfos are retrieved. Wildcard can be used. SQLServer specific
• Structure of DQE's: they're now instance classes, no longer classes with static methods.
• Reworked recursive save pipeline using topology sorting of a directed graph: first queues are constructed, then the save actions are started on these queues. This both gives faster recursive saves, but also keeps the transaction shorter (in time), as it's started later (selfservicing has same starts, adapter starts the transaction later). Originally, the recursive save routine saved the entities while traversing/building the tree.
• UnitOfWork classes now use the new recursive save pipeline elements to construct first queues to process before starting the actions on these queues. When a unitofwork(2) object is serialized, it first determines the real elements to save, which makes serializing unitofwork(2) objects very efficient, as only the elements which will take part of a persistence action are serialized into the UnitOfWork(2) serialized data.
• Adapter: serialization / deserialization of entities is now much faster and the data produced is up to 60% smaller.
• Selfservicing: Multi-entity fetch logic now calls OnFetchComplete() after an entity was succesfully fetched and filled with data. Post-fetch initialization logic should be placed inside a method which overrides OnFetchComplete().

Added

• Inheritance support (3 types of inheritance)
• Multi entity on single target mapping
• Type converter technology for converting values transparently from one .NET type to the other .NET type and vice versa, to be used in Entity/View fields and predicates. For example, it offers the ability to map boolean fields directly on non-boolean/bit types in the database, or for example to map an XmlDocument object onto a string type.
• Ability to not map a field in a table / view to a field in an entity
• Polymorphic query support including filtering on entity type
• Compact framework .NET 1.1 support
• SQL CE support
• Prefetch path fetches in combination with paging
• Adapter: Schema name overwriting settings at runtime for multiple schema name overwrites. You can pass in a SchemaNameOverwriteHashtable which contains the from-to namepairs and the setting what to do. Wildcard can be used. SQLServer, Oracle, DB2 specific.
• MySql: Update entities directly with multi-entity filter has been added.
• FieldBetweenPredicate now also handles field BETWEEN value AND field, field BETWEEN field AND value, field BETWEEN field AND field
• ORMInheritanceInfoException exception, meant for errors determined during query execution, for example when the inheritance info data is out of sync with the data in the db, which occurs for example when the type has to be determined of the row retrieved from the db and the discriminatorvalue is unknown.
• Prefetch path optimization with a user definable threshold when to switch from one method to the other.
• Support for Cross joins.
• Overload to DataAccessAdapter.SaveEntity, which accepts recurse and refetchAfterSave but not a predicate.
• SelfServicing: EntityCollectionBase.DoNotPerformAddIfPresent flag to signal if EntityCollectionBase.Add() should check if the entity to add is already in the collection (default, true) or not (false).
• Adapter: New overloads for FetchTypedList and FetchTypedView which are simpler to use (e.g. accept a typedlist/typed view and don't require you to retrieve the fields info / relations info first.
• EntityCollectionBase(2) now has 2 properties (ConcurrencyPredicateFactoryToUse and EntityValidatorToUse) which will set these properties of any new entity created in a collection fetch to the values stored in these two properties. Also done when AddNew() is called in a databinding scenario.
• OnBeginEdit(), OnEndEdit(), OnCancelEdit(), OnTransactionCommit() and OnTransactionRollback() as protected virtual methods to EntityBase(2).
• Adapter specific constructor to EntityRelation class.
• SqlServer: inserts into a table with solely an identity field are now possible. (INSERT INTO table DEFAULT VALUES)
• Prefetch path optimization through caching of PK hashes.
• UnitOfWork(2) now offer a way to construct the insert/update queues prior to actually committing them. These queues aren't reset after a commit so can be used to fine-grained control over the elements participating in the unitofwork.
• Native .NET 2.0 builds for the ormsupport classes and various DQE's. The ORM support classes build doesn't use ICustomTypeDescriptor on the entity classes, which should enable design time databinding on .NET 2.0 for the time being. (winforms).
• Polymorphic prefetch paths: fetches of supertypes can be performed with prefetch paths which refer to related objects of subtypes and which will load only the subtype's related objects into the subtype instances (if available).
• SortClause.CaseSensitiveCollation. This flag will apply UPPER() (or db specific equivalent) to the field to sort on, to make case sensitive database installations be able to sort case insensitively.
• Adapter: OnBeforeTransactionCommit, OnAfterTransactionCommit, OnBeforeTransactionRollback and OnAfterTransactionRollback added to DataAccessAdapterBase as public virtual methods.
• Adapter: New constructor to RelationPredicateBucket which accepts an IPredicate to ease the construction of filters for Adapter.

Designer

Changed

• The regular color in the logviewer is now green instead of maroon. Errors are now much easier to spot.
• Custom entity relation editor: the checkbox for auto-detect m:n relations is now only checked if the refresher preference to hide m:n relations automatically is set to false.
• Custom entity relation editor: the name of the field mapped onto the relation to create is now initially set with the name of the related entity.
• Relation nodes of an entity are now sorted ascending in project explorer
• Fields mapped onto relation nodes of an entity are now sorted ascending in project explorer.
• It's now possible to select a sequence for a field which is in an entity mapped onto a view and mark it as identity for sqlserver.

Added

• New preference setting: AddNewFieldsAfterRefresh, which controls if newly found target fields are added as new fields or are added to the list of unmapped fields.
• New preference setting: HideManyToManyRelationsOnCreation, which controls if newly created m:n relations should be marked 'hidden' by default.
• Multiple entities can now be mapped on a single target.
• Entity list viewer for proper overview which entity is mapped onto which target.
• New preference setting: AutoAssignTypeConverterToNewField, which controls if a newly added field (for example in a new entity) gets a matching type converter assigned to it automatically, based on the type conversion definitions defined in the project.
• Plugin which toggles the hide flag on m:n relations. If a relation can't be made unhidden (because one of the two relations it's build on is hidden), it's not marked unhidden.
• Plugin which applies selected Type Conversion Definitions to selected elements, to quickly set type converters on existing projects.
• Option (ManuallySelectRenamedTargetsAfterRefresh) added which will cause the refresher to pop up a dialog (if not unattended) in which the user can select which target to select for a given entity, if the target couldn't be found by the refresher, for example in the case when the target has been renamed.
• Option (LazyLoadingWithoutResultReturnsNew) added to set the flags for the _entityReturnsNewIfNotFound flags in Selfservicing to a value specified in the designer. This makes it easy to set this flag once for all generated entities. Selfservicing specific.
• Context menu to Relations treeview in Entity Editor for easy removal of custom relations and toggle actions on relations.
• Typed list relations can now also have the join hint for a Cross join.
• Typed list designer now has 'Field index' in the column list of the fields in the select list. Use shift-click on the column headers to sort on multiple columns.
• Entities mapped onto views can now have nullable fields.
• Entity hierarchy visualizer.

Task performers

Added

• Lpt templates can now be bound to templateid's which are included in TDL templates. This greatly enhances the scope of the include templates as with lpt templates (with <% %> syntax and template code in C#/VB.NET) it's possible to access the complete project object graph. This is completely transparent, just bind a .lpt template to a template id which is included in a TDL template and it will be called.

Templates

Added

• Two new overloads to ResultsetFields.DefineField() for each typed view, which accept an alias for the field.
• New method in entity classes: TestCurrentFieldValueForNull(index), which returns true if the current value of a field represents null/undefined. This is for example the case for a field of a new entity which hasn't been changed, or a field in a non new entity which hasn't been changed or which has been set to null/Nothing.
• Support for partial classes in VS.NET 2005 scenario's: all classes are generated as partial classes (C#) if a VS.NET 2005 generator scenario is chosen. VB.NET 2005 classes can already be extended with partial classes without having the generated classes defined as 'Partial'.