LinqConnect is a fast and easy-to-use ORM solution, developed closely to the Microsoft
LINQ to SQL technology, and supporting SQL Server, Oracle, MySQL, PostgreSQL, and
SQLite. It is completely compatible with LINQ to SQL. LinqConnect generates the
same classes as LINQ to SQL, and the interface of the LinqConnect DataContext class
is compatible with LINQ to SQL DataContext. If you are a LINQ to SQL developer,
you don't need to learn much and can start developing with LinqConnect immediately.
LinqConnect offers numerous extensions to LINQ to SQL functionality.
The Table Per Type hierarchy provides better data integrity and less redundant data.
With many-to-many associations you can reduce the number of entities
in your model and decrease the complexity of LINQ queries.
You can unite a scalar property set that is used in several entity classes into
a separate class.
LinqConnect allows multilevel tweaks of lazy/eager loading, which can reduce the
number of database calls.
Tweak eager loading for separate queries without changing settings for the DataContext
with the Include LINQ operator.
In addition to concurrency conflicts, LinqConnect allows you to process other database
errors, for example, constraint violations.
LinqConnect allows grouping several INSERT/UPDATE/DELETE statements into one SQL
block and merging their parameters, which substantially increases DataContext.SubmitChanges
performance since server calls are fewer.
LINQ queries need to be compiled before execution, and that can take substantial
time. LinqConnect has a global cache for recent queries, which can greatly increase
performance in case of reusing same queries, or using them in different DataContexts.
LinqConnect offers you a wizard for generating a database from a model. Later you
can also synchronize your database with recent model changes automatically.
With LinqConnect you can easily generate your model from a database with a convenient
wizard, and update your model from a database, retaining your custom changes where
With T4 templates, the code generation process becomes really flexible. You can
customize generated code in any way you like. Templates are edited in a convenient
editor with syntax highlighting and intellisense.
Use our monitoring tool to monitor and analyze all the database calls, made by LinqConnect.
With it you may monitor your application remotely, and view database calls with
error and parameter information.
LinqConnect includes a visualizer for DataQuery objects that allows you to view
a generated SQL command for the LINQ statement in a dialog box. SQL syntax highlighting
provides more comfortable reading.
LinqConnect supports SQL Server, Oracle, MySQL, PostgreSQL, and SQLite. You can
easily switch to any of these database servers. LinqConnect goes bundled with its
own database providers for supported databases, so you don't need to buy additional
Unlike LINQ to SQL, LinqConnect is an actively developed and supported ORM. We continue
to add new features taking user feedback into account. New builds of LinqConnect
with bug fixes and new features are released every few weeks.
Just right-click the LINQ to SQL model in Solution Explorer, and then click Migrate
to LinqConnect, and your project will be migrated automatically.
".. you can choose with Devart's components, if you wish to develop Linq to (any
ADO.NET based database) like: Linq to MySQL, Linq to MSSQL, Linq to Oracle, Linq
to Postgres..." >>
You might be also interested in:
ORM-enabled ADO.NET providers:
T4 Template Editor for Visual Studio: