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: [ read full changelog ]
· Support for Silverlight 4 and higher and Windows Phone 7 is added
· References to System.Data.Linq are removed; now LinqConnect uses only its own classes
· Upgrade wizard for upgrading projects to the new version of LinqConnect automatically is added
· The possibility to choose cache mode (classic mode for cases when DataContext is used as a unit of work, and self-cleaning mode for cases when DataContext is a long-lived object) is added
· The possibility to map stored procedure out parameters of the CURSOR type to IEnumerable parameters of the corresponding methods is added
· Tracking of complex object graphs with chains of parent-child objects is optimized
· Number of database calls required for managing objects with a many-to-many association is reduced
· Delete rule performance is improved
· Compilation performance is improved
· Materialization performance is improved
· Compiled query cache is improved
Entity Developer:
· The sticker notes for adding comments to diagrams are i...