LinqConnect ORM

Model-First

Generate a database directly from your model using a dedicated wizard, and automatically keep the database synchronized with any changes you make to the model.

Database-First

Create your model from an existing database using an intuitive visual wizard, and update the model as the database evolves, preserving custom modifications.

T4 Templates with Designer

T4 templates make code generation more straightforward and more flexible. You can customize the generated code and modify templates using an editor with syntax highlighting and IntelliSense support.

Table-per-type support

The Table-per-type (TPT) hierarchy helps you improve data integrity and eliminate redundant data.

Many-to-many associations

Many-to-many associations reduce the number of entities in your model and simplify LINQ queries.

Complex types (value types)

LinqConnect lets you combine common scalar properties used across multiple entity classes into a separate reusable class.

Recursive support in load options

LinqConnect allows you to fine-tune lazy and eager loading across multiple levels as it reduces the number of database calls.

Query level load options

Use the Include LINQ operator to configure eager loading for individual queries, without changing the default DataContext settings.

Extended error processing for SubmitChanges

LinqConnect efficiently handles concurrency conflicts. In addition, it can process other database errors, such as constraint violations.

Batch updates

LinqConnect allows you to group multiple INSERT, UPDATE, and DELETE statements into a single SQL block and merge their parameters. Therefore, the DataContext.SubmitChanges performance is improved by reducing the number of server calls.

Compiled query cache

Because LINQ queries must be compiled before execution, they can cause overhead. LinqConnect uses a global cache for recently compiled queries, boosting performance when the same queries are reused or executed across different DataContext instances.

Powerful monitoring tool

Monitor and analyze all database calls made by LinqConnect using the built-in monitoring tool. It also allows remote monitoring and displays detailed information about errors and parameters.

Visual Studio Debugger visualizer

LinqConnect includes a visualizer for DataQuery objects that lets you view the generated SQL command for a LINQ statement directly in a dialog box, with SQL syntax highlighting for easier readability.