LinqConnect Express 4.3.355

ORM solution, developed closely to the Microsoft LINQ to SQL technology

LinqConnect Express is a powerful application developed closely to the Microsoft LINQ to SQL technology, and supporting SQL Server, Oracle, MySQL, PostgreSQL, and SQLite. LinqConnect Express was created to provide a powerful model designer with complete integration to Visual Studio.

LINQ stands for Language-Integrated Query, which means that data retrieval is no longer a separate language. The LINQ engine allows .NET applications to connect to databases without bothering much about columns and rows. The data you receive is automatically formed as objects ready to use by your business logic.

LINQ to Relational Data may be thought of as an object-relational mapping (ORM) tool. The type-safe LINQ queries get compiled into MSIL on the fly, and the query clauses are translated into SQL and sent to the SQL server for execution. The program is designed to make your data access layer as safer and faster as possible.

Here are some key features of "LinqConnect Express":

• Visual schema modelling
• Model-First approach support
• Database-First approach support
• Predefined templates
• dbMonitor support
• SQL Server support
• Oracle support
• MySQL support
• PostgreSQL support
• SQLite support
• Project size limit
• Free for use

Requirements:

• NET Framework 3.5
• Microsoft Visual Studio

Limitations:

• Does not allow customization of code templates
• Limited to 10 entities in the project

What's New in This Release:

• Oracle 12c is supported
• VARCHAR2/NVARCHAR2/RAW types with length increased to 32KB are supported for Oracle 12c
• Oracle 12c specific SQL generation for paging is supported
• The Collate method of the SqlMethods class is implemented
• The behaviour is changed: CreateDatabase functionality generates columns with the identity clause 'GENERATED AS IDENTITY' for primary key properties with 'IsDbGenerated=True' (only for Oracle 12c)
• The bug with ignoring 'IsDbGenerated = True' when using Attach(TEntity entity, bool asModified) method is fixed
• The bug with the compiled query cache when query contains parameters with the same values is fixed
• The bug related to working with LinqConnect for Metro in WinJS applications is fixed
• Entity Developer:
• The predefined templates are improved: new template setting, "Use Compiled Query Cache", is added
• The behaviour is changed: "Generate Database Script"/"Update Database From Model" wizards generate columns with the identit...

Publisher	:	Devart
License	:	Freeware
Size/OS:	:	43.6 MB / Windows 2K / XP / Vista / Vista 64 bit / 7 / 7 64 bit / 2003
Download	:	LinqConnect Express 4.3.355