Devart is glad to present the new version of LinqConnect 3.0 - an enhanced LINQ to SQL compatible ORM solution with extended functionality, support for SQL Server, Oracle, MySQL, PostgreSQL, and SQLite. New version of LinqConnect offers you fluent mapping support.
Fluent mapping provides the following advantages over XML and attribute mapping:
- Unlike attribute mapping, fluent mapping does not modify entity classes, allowing them not to be persistence-aware.
- Application code performs mapping, so mapping is always checked for errors during compilation.
- Mapping can be easily modified at run-time. For example, different DBMS can be used for persistence depending on the application settings.
Entity Developer Improvements
LinqConnect does not limit the use of the fluent mapping to the Code First approach. If you want to use a legacy database, or you already have an existing model, there is no need to write the mapping code manually. Entity Developer includes Fluent mapping code generation templates, which allow you to utilize all the advantages of the fluent mapping together with benefits of visual model design and Model First/Database First design approaches. Design the model the way you like, and Entity Developer will generate both entity classes and the fluent mapping code for you.
Entity Developer for LinqConnect fully supports the newly introduced enum types by providing a new Enum node in its Model Explorer window. For an easier use of this type, the application provides the drag-and-drop mechanism allowing to move enum types from the Model Explorer window on to the diagram's surface, and the Find in diagrams function that enables the user to easily locate enum types on the diagram.
Properties of the Enum types as well as those of their members can be conveniently set and modified in the new Enum Type Editor, provided in this latest version. Subsequently, these properties are displayed in the Properties windows and can be edited directly in that window.
Major improvements in the usability and user-friendliness of the application include entity shape coloring, selection-driven highlighting, application and diagram skins.
The entity shape coloring function allows the user to define a custom coloring for any entity present on the diagram by changing its Shape Color property.
The selection-driven functionality is intended to improve the readability of complex diagrams by visually indicating various interrelations between different entities present on a particular diagram.
The general look and feel of the application is further modernized with sets of skins for the application itself (available only in the standalone version) and for the diagram.
Here is the complete list of LinqConnect 3.0.4 features:
- Fluent mapping is supported
- The bug with inserting a TPT 'child' entity in case its primary key column names differ from the 'parent' entity ones is fixed
- The bug with deleting dependent entities when other changes were made is fixed
- The bug with entity materialization for queries with multiple eager loading options is fixed
- The bug with saving (inserting or updating) System.Data.Linq.Binary objects is fixed
- The bug with long sequence of IN operator arguments is fixed (Oracle)
- The bug with null comparison for DateTime properties is fixed (Oracle)
- The bug with SQL generation for Skip/Take methods is fixed (SQL Server)
- The bug with creating foreign keys in SQLite databases on DataContext.CreateDatabase is fixed
- Fluent Mapping template is added
- Support for enumerated types ("enums") is implemented
- New skins to improve the apllication appearance are implemented
- Selection driven highlighting is implemented
- Capability for changing the shape color for entities, complex types and enums is implemented
- Capability for selecting the diagram skin type is implemented
- Changed behaviour: when the FirstLetterUpperCase / FirstLetterLowerCase option is enabled in Naming rules, each letter after underscore will be capital/lower
- The bug with setting foreign keys to tables located in non-default schema via the Create Database wizard is fixed (SQL Server)
- The bug with changing property names ("Index was outside the bounds of the array") is fixed