SQL Server - LinqConnect

Features: 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 ...

Release Notes: Fixed bug with IndexOf() method overload, that accepts CurrentCultureIgnoreCase as an argument (Microsoft SQL Server). ...

Release Notes: Updates in V4.4 SQL Server 2014 support. JSON data type support. ...

Release Notes: Entity Developer- Added support for graph tables in SQL Server 2019. Fixed bug with case insensitive comparison via string.Compare() (Oracle). Fixed bug returning generated value for property ... with Auto-Sync=OnInsert, which corresponds to non-Identity column (SQL Server). Entity Developer Behavior changed: columns with IsHidden=1 in SQL Server 2019 are ignored by Create Model Wizard (SQL Server). Fxied bug ... with non-default precision DATETIME2 and TIME data types by Update To Database / Generate Database Script wizards (SQL Server). Fixed bug detecting MySQL computed columns (MySQL). ...

Release Notes: in Microsoft Visual Studio 2013, 2015, 2017 and 2019 web projects. Fixed bug quoting SQL Server reserved keywords used as identifiers in Code-First mapping (SQL Server). Fixed bug creating a Date parameter ... for a property mapped to DbType="DATE" and when used in.WHERE() clauses in LINQ queries (SQL Server). ...

Release Notes: in Create Model Wizard and Model Settings in LinqConnect model. Added a new "Show System Schemas" (by default, False) option to Servers' Options-> SQL Server. If the "Show System ... Schemas" check box is selected, database objects from system schemas will be retrieved (SQL Server). Added a new "Retrieve Cross Schema Relations" (by default, True) option to Servers' ... Options-> SQL Server. If the "Retrieve Cross Schema Relations" check box is selected, foreign keys from different schemas will be retrieved. This can take some time (SQL Server). Fixed the bug ...

Release Notes: to the IInheritanceConfiguration interface. Bitwise And, Or, Xor, and Not operators are supported in LINQ queries for integer operands (SQL Server). Bitwise And, Or, and Xor operators are supported in LINQ queries for integer ...

Release Notes: Now supports Identity columns in PostgreSQL 10. Added support for the generation of CROSS JOIN LATERAL and LEFT JOIN LATERAL when connecting to a PostgreSQL Server (9.3 or higher). Entity Developer ...

Description: Advanced LINQ to SQL tool for databases. 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 ... 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 ... SQLite support Visual schema modelling Model-First approach support Database-First approach support Predefined templates Custom templates dbMonitor support SQL Server support ...

Release Notes: (Microsoft SQL Server). The bug with Microsoft Visual Studio 2019 integration, when both v16.7 RTM and v16.8 Preview are installed on the same computer has been fixed. The bug with using nullable numeric types ...

Release Notes: Added support for Contains(), StartsWith(), EndsWith(), IndexOf(), Equals(), Compare() method overloads, that accept StringComparison as an argument (SQL Server). Added support for Compare() method ...

Release Notes: for macaddr8 data type introduced in PostgreSQL 10. Improved performance generating complex queries. Generate CROSS JOIN LATERAL and LEFT JOIN LATERAL when connecting to PostgreSQL Server 9.3 or higher. ...

Features: 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. ...

Release Notes: Adds support for PostgreSQL 12. Added support for PostgreSQL 12. ...

Release Notes: Microsoft Visual Studio 2022 version 17.8 Preview is now supported. 0 ...

Release Notes: Added support for Microsoft Visual Studio 2022 version 17.7 Preview. Entity Developer The behavior has been changed: The primitive properties by default now have Inheritance Modifier = None. Entity Developer Fixed the bug with the detection of non-existent changes while updating a model from a ...

Release Notes: Added new methods IsNotDistinctFrom() and IsDistinctFrom() to the Devart.Data.Linq.SqlMethods class. Fixed the bug with using out parameters of a stored procedure, when Mapping Mode is set to File in Model Settings (Oracle). ...

Release Notes: Adds.NET 7 compatibility and support for Visual Studio 2022 version 17.5 Preview. Microsoft Visual Studio 2022 version 17.5 Preview is now supported. Added Microsoft.NET 7 compatibility. 0 ...

Release Notes: with SQL generation of explicit cast to FLOAT. Fixed a bug when subtracting a TimeSpan value from the DATETIME column. Entity Developer Fixed a bug when saving a new model, which has never been saved before, ...

Release Notes: Adds.NET 6 compatibility plus support for Windows 11. Added Microsoft.NET 6 compatibility. Added Microsoft Windows 11 support. Added Microsoft Visual Studio 2022 version 17.2 and 17.3 Preview support. Entity Developer Added 64-bit version of standalone Entity Developer application. Added 64-bit ...