關於 LinqConnect

用於資料庫的 LINQ 到 SQL 先進工具。

LinqConnect is a fast and easy-to-use ORM solution that supports SQL Server, Oracle, MySQL, PostgreSQL, and SQLite. It provides a powerful model designer tool with complete integration to Visual Studio - Entity Developer. 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.

LinqConnect Features

  • LINQ to SQL Compatible - LinqConnect was developed closely to LINQ to SQL and retains full compatibility with it. Interface of the LinqConnect classes is compatible with LINQ to SQL ones. If you are a LINQ to SQL developer, you don't need to learn much and can start developing with LinqConnect immediately. Unlike LINQ to SQL, LinqConnect is an actively developed and supported product, and it offers a number of benefits over LINQ to SQL. It supports more database servers, more development platforms, more LINQ features, more mapping kinds, provides better performance, etc.
  • Code-First, Database-First, Model-First - LinqConnect supports all the development approaches - Code-First, Database-First, Model-First, or mixing Database-First and Model-First. Its visual model designer Entity Developer allows you to quickly design your model and offers easy-to-use wizards for creating model from a database, database from a model, or synchronizing existing model and database in any direction. Entity Developer provides powerful and highly customizable template-based code generation, allowing you to configure code output redirection, generate partial classes, use custom attributes for your classes and members, etc.
  • Share Code - Share the same code for working with data on different platforms. LinqConnect is a database connectivity solution that works on different .NET-based frameworks, including Full .NET Framework, .NET Core, Silverlight, Mono, etc. In addition to LINQ data access, it offers you ADO.NET interfaces for Silverlight, Metro, and Windows Phone. Moreover, for these platforms, LinqConnect provides a managed embedded database engine from C# SQLite project for working with local SQLite databases.
  • Easy Integration with Different Microsoft Technologies - Use LinqConnect for data access in your Windows Forms, ASP.NET WebForms, WCF RIA Services, Dynamic Data, WPF, or other applications. LinqConnect offers wide data binding support for Windows Forms and WPF applications and LinqDataSource component for ASP.NET web applications and provides additional integration features for Dynamic Data projects and WCF RIA Services.
  • LINQ Support - While most ORMs use their own query language and LINQ support is just an additional feature, LinqConnect was designed as the LINQ provider, it has no extra layers between LINQ and SQL. Because of this LinqConnect has higher performance and better LINQ support.
  • Mapping Support - LinqConnect supports all the widely used mapping cases: complex types, many-to-many associations, TPT and TPH inheritances, mapping stored procedures returning cursors to methods, etc. And it's not bloated with support for exotic and needless mapping cases - it remains fast, simple, and easy-to-understand.
  • Rich Runtime Features - LinqConnect features smart change tracking, advanced error processing mechanisms, extensibility methods for customizing CRUD and other operations, POCO support, lazy and eager loading that can be customized on query level, etc.
  • Performance - LinqConnect performance is 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 performance, such as a compiled query cache or batch updates.

LinqConnect Standard Features

  • Visual schema modelling
  • Model-First approach support
  • Database-First approach support
  • Predefined templates
  • Custom templates
  • dbMonitor support
  • SQL Server support

LinqConnect Metro Features

  • Oracle support
  • MySQL support
  • PostgreSQL support
  • SQLite support
  • Visual schema modelling
  • Model-First approach support
  • Database-First approach support
  • Predefined templates
  • Custom templates
  • Windows Store Apps support

LinqConnect Silverlight Features

  • Oracle support
  • MySQL support
  • PostgreSQL support
  • SQLite support
  • Visual schema modelling
  • Model-First approach support
  • Database-First approach support
  • Predefined templates
  • Custom templates
  • Silverlight support

LinqConnect Windows Phone Features

  • Oracle support
  • MySQL support
  • PostgreSQL support
  • SQLite support
  • Visual schema modelling
  • Model-First approach support   
  • Database-First approach support
  • Predefined templates
  • Custom templates
  • Windows Phone support

LinqConnect Professional Features

  • Oracle support
  • MySQL support
  • PostgreSQL support
  • SQLite support
  • Visual schema modelling
  • Model-First approach support
  • Database-First approach support
  • Predefined templates
  • Custom templates
  • dbMonitor support
  • SQL Server support