Devart is glad to present the new version of LinqConnect 4.2 - an enhanced LINQ to SQL compatible ORM solution with extended functionality and support for SQL Server, Oracle, MySQL, PostgreSQL, and SQLite.
New version of LinqConnect offers a new version of Entity Developer 5.5 with a large number of improvements and LINQPad integration.
LINQPad Integration
New version of LinqConnect provides a LINQPad driver that allows performing queries against the corresponding databases using LinqConnect ORM models. Both static (for precompiled DataContext) and dynamic (for automatic generation of context and entity classes) drivers are supported. You can read more about LINQPad support on our LINQPad Support in LinqConnect page.
Code Generation Improvements
Entity Developer 5.5 offers the following new templates:
- MVC Controller and MVC View Advanced - templates designed for generating an ASP.NET MVC Controller and View for using entity classes in ASP.NET MVC applications. Our MVC View Advanced template offers significant advantages over the standard MVC Scaffolding template. It supports such advanced features as sorting, filtering, and paging.
- Data Annotations Metadata - generates Data Annotations metadata classes and decorate entity classes and properties with Data Annotations attributes that specify validation rules, data display settings, and define metadata for Windows Communication Foundation, Dynamic data, and WCF RIA Services.
- Data Transfer Objects - template, designed for generating Data Transfer Object (DTO) classes.
Model First Improvements
Entity Developer 5.5 provides a number of settings to ease the Model First development. It allows you to define a set of properties that will be present in all the new entities, and when you create a new entity, these predefined properties will be added to it automatically.
Model initialization settings now allow you to specify if the string properties should be mapped to columns of unicode data type by default, and to set default facets for all the numeric properties.
Attributes
Working with attributes is greatly improved. Now it is possible to edit attributes for several selected entities or properties at once. The Attributes page of the Model Settings dialog box has now the refresh button for refreshing the available attribute list for the selected assemblies.
Other Improvements
Generate Database Wizard now can generate DROP statements for database tables before CREATE statements. Update To Database Wizard offers a Recreate Database Tables setting to drop and recreate tables instead of altering them.
When adding a model object (a class, complex type, or enum) from Model Explorer to a diagram, or a table from Database Explorer to a diagram, now you can add them with all the related objects.
Here is the complete list of LinqConnect 4.2.222 features:
- LINQPad integration is supported
- The behaviour is changed: now, when trying to synchronize composite primary key after insert, the "Auto-sync of multiple key parameters is not supported for SQL Server" and SqlNullValueException exceptions are not thrown (SQL Server)
- The behaviour is changed: new database is created when using CreateDatabase method with createSchema = true (SQL Server)
- The behaviour is changed: now batch updates are disabled by default (SQLite)
- The bug related to the NullReferenceException on SubmitChanges() method when working with isVersion properties is fixed
- The bug with using blank fixed-length strings is fixed (Oracle)
- A new MVC Controller template, generating a ASP.NET MVC controller with data access code, is added
- A new MVC View Advanced template, generating an ASP.NET MVC view based in Twitter Bootstrap, is added
- A new Data Transfer Object template for DTO classes generation is implemented
- A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart LinqConnect model is added
- A new Data Annotation Metadata template, generating Data Annotation metadata classes and decorating classes and properties with data annotation attributes for validation, presentation and defining metadata, is added
- Add Template dialog box is improved
- The Namespace property of class, complex type, enum is implemented
- The capability for setting special rules for generating default names of database objects when using the Model First approach is implemented (a new Advanced page is added to the Synchronization->Database Naming section of the Model Settings dialog box)
- The capability to customize properties that are automatically added when creating a new entity, and options that are automatically set when creating a new property is added (a new Initialization page is added to the Model->General section of the Model Settings dialog box)
- The Refresh option in the Attributes tab of the Model Settings window is implemented; it updates the list of available attributes types in the referenced assemblies
- The capability to modify custom attributes for several selected entities or properties at the same time is implemented
- The capability to cancel metadata reading in wizards and Database Explorer is added
- The "Recreate Database Tables" check box, which allows to drop and recreate database tables, is added to the "Update To Database" wizard
- New setting "Detect Table Per Type inheritances", which enables automatic detection of TPT inheritances, is added for Create Model Wizard and model
- The "Include Drop" check box for including DROP commands for database objects to the generated script is added to Generate Database Script Wizard
- A new shortcut menu command "Include Related", which allows making a copy of the related objects in the specified diagram, is added
- A new shortcut menu command "Add To Model with Related", which allows adding tables, related to the selected one, to the model, is added to the shortcut menu of tables in Database Explorer
- A new shortcut menu command "Add On Diagram With Related", which allows creating an object and all the objects related to it on a diagram, is added to the shortcut menu of classes, complex types, and enums in Model Explorer
- The support for enums declared in external assemblies is implemented
- New "Simple" diagram skin is added for displaying a diagram in metro style
- The "Default Width" diagram property for specifying the default width for newly created diagram shapes (entities, complex types and enums) is added
- Class Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
- Type Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
- The "Rewrite connection string during regeneration" check box of Model Settings is implemented to determine whether to overwrite the connection string in the project config file with the one, currently set in Entity Developer for the model, each time when regenerating code for the model
- The user interface of Express Edition concerning availability of custom templates is improved
- The behaviour is changed: "Save connection string in App.Config as" check box in Model Settings dialog box is renamed to "Use connection string from App.Config as"
- The behaviour is changed: now, when creating a new TPH discriminator column in Inheritance Editor, it has the string type by default
- The behaviour is changed: the error is generated if the Abstract inheritance modifier is set for the class which is involved in the Table Per Type inheritance
- The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of class property without assigned value
- The bug with the database script generation for the 'Delete Rule' association property is fixed
http://www.devart.com/linqconnect/