sql - LinqConnect

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

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

Notas de la versión: 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 ...

Notas de la versión: Adds support for PostgreSQL 12. Added support for PostgreSQL 12. ...

Descripción: Herramienta avanzada de LINQ a SQL para bases de datos. 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 ...

Descripción: 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 ... 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 ...

Notas de la versión: Fixed bug with IndexOf() method overload, that accepts CurrentCultureIgnoreCase as an argument (Microsoft SQL Server). ...

Notas de la versión: Microsoft Visual Studio 2022 version 17.8 Preview is now supported. 0 ...

Notas de la versión: 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). ...

Notas de la versión: 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 ...

Notas de la versión: 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). ...

Notas de la versión: 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 ...

Notas de la versión: (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 ...

Notas de la versión: Updates in V4.4 SQL Server 2014 support. JSON data type support. ...

Notas de la versión: 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). ...

Notas de la versión: 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, ...

Notas de la versión: Added support for Contains(), StartsWith(), EndsWith(), IndexOf(), Equals(), Compare() method overloads, that accept StringComparison as an argument (SQL Server). Added support for Compare() method ...

Notas de la versión: 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 ...

Funciones: Use the freeware dbMonitor tool to monitor and analyze all the database calls, made by LinqConnect components in your application. dbMonitor performs tracing of commits, rollbacks, SQL statement ... execution, etc. Additionally, LinqConnect allows you to log SQL statements to a file. ...

Notas de la versión: 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 Now supports Identity columns in PostgreSQL 10. MethodAccessException thrown by.NET Standard provider ...