LinqConnect Overview

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 provides a powerful model designer tool with complete integration to Visual Studio - Entity Developer.

What is LINQ?

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. This makes your data access layer safer, faster, and greatly more convenient to design.

Wide LINQ Support

LinqConnect provides wide support for LINQ queries. It provides advanced eager loading support, enhanced native SQL query handling, and generates better provider-specific SQL code.

Wide Database Support

LinqConnect works with SQL Server, SQL Server Compact, Oracle, MySQL, PostgreSQL, and SQLite databases, and supports all their scalar data types.

Compatibility

LinqConnect uses classes and interfaces completely compat­ible with LINQ to SQL, while extending its functi­onality, so LINQ to SQL developers can easily get started to work with LinqConnect.

Performance

High enough without lots of efforts on optimizing your code. Even higher if you bother to do so. LinqConnect contains a set of solutions for increasing per­formance, such as a compiled query cache or batch updates.

Visual Model Designer

With Entity Developer all model creating and editing tasks can be performed in a convenient GUI, completely eliminating the need of the manual XML editing, thus greatly reducing the devel­opment and learning time.

Database Providers

LinqConnect goes with bundled Express versions of dotConnect data providers for Oracle, MySQL, PostgreSQL, and SQLite, so you don't need to install additional software to create models.

Professional Team

LinqConnect is developed by a company having more than eight years of experience in development of the data access technologies in .NET. See our Company webpage to know more.

dbMonitor

Use our freeware dbMonitor tool to monitor and analyze all the database calls, made by LinqConnect components in your application. dbMonitor performs per-component trac­ing of commits, rollbacks, SQL statement execution, etc.

Support

We provide high-quality techn­ical support for our products. All your forum or e-mail questions will be an­swered in two bus­i­ness days. Visit our Support page to get aid with LinqConnect.

Feature Information

Documentation and Samples

LinqConnect is shipped with documentation that includes a set of topics that cover its usage and run time reference. There are several demo projects in C# and Visual Basic that can help you start using the technology. You can view the documentation online here.

Tutorials

Read our illustrated tutorials for:

• Oracle,
• MySQL,
• PostgreSQL,
• SQLite.