Devart LinqConnect

LINQ to SQL Compatible ORM Solution.

Support for SQL Server, MySQL, Oracle, PostgreSQL, & SQLite & many other advanced features.

LINQ to SQL Compatible ORM Solution.

LinqConnect Features

LinqConnect is completely compatible with LINQ to SQL.
LINQ to SQL
LinqConnect models are created in its own visual designer.
Model Designer
SQL Server, MySQL, Oracle, PgSQL, and SQLite are supported.
Database Support
Support for advanced LINQ features not available in L2S.
Wide LINQ Support
Monitor and analyze all the LinqConnect database calls.
Monitor & Analyze
LinqConnect is completely compatible with LINQ to SQL.

LinqConnect is completely compatible with LINQ to SQL.

LinqConnect uses classes and interfaces completely compatible with Microsoft LINQ to SQL, so LINQ to SQL developers can easily get started to work with LinqConnect. It offers Migration Wizard that allows you to quickly convert your LINQ to SQL projects to LinqConnect. However, unlike LINQ to SQL, it is an actively developed and supported product, which offers many advanced features, not present in LINQ to SQL, so LinqConnect is a perfect LINQ to SQL replacement.

LinqConnect models are created in its own visual designer.

LinqConnect models are created in its own visual designer.

LinqConnect provides its own visual model designer – Entity Developer. With Entity Developer all model creating and editing tasks can be performed in a convenient GUI, thus greatly reducing the development and learning time. Entity Developer seamlessly integrates into Visual Studio allowing you to design LinqConnect models directly in the IDE. It supports both Model-First and Database-First approaches to design models, allows synchronizing model and database in any direction, and provides flexible and highly customizable T4-based code generation. After you have created your model, Entity Developer allows to test it with LINQ queries without the need to write a special test application.

SQL Server, MySQL, Oracle, PgSQL, and SQLite are supported.

SQL Server, MySQL, Oracle, PgSQL, and SQLite are supported.

Besides SQL Server and SQL Server Compact, LinqConnect works with MySQL, Oracle, PostgreSQL, and SQLite databases, and supports all their scalar data types. LinqConnect goes with bundled Express versions of dotConnect data providers for MySQL, Oracle, PostgreSQL, and SQLite, so you don't need to install additional software to create models for these databases.

Support for advanced LINQ features not available in L2S.

Support for advanced LINQ features not available in L2S.

With LinqConnect you can use the following mapping cases, not supported in LINQ to SQL: Table-Per-Type inheritances, many-to-many associations, complex types, etc. Separate LINQ queries can be tweaked for lazy/eager loading without changing settings for the whole DataContext.

Monitor and analyze all the LinqConnect database calls.

Monitor and analyze all the LinqConnect database calls.

Use the freeware dbMonitor tool to monitor and analyze all the database calls, made by LinqConnect components in your application. dbMonitor performs tracing of commits, rollbacks, SQL statement execution, etc. Additionally, LinqConnect allows you to log SQL statements to a file.