database connectivity - dotConnect for Oracle

Notes de publication : Updates in V6.30 Oracle Workflow Instance Store implemented Support for the Oracle TimesTen database implemented DbTransactionBase class added TransactionStateChanging and TransactionStateChanged ...

Notes de publication : queries in Direct mode. Fixed bug opening database connection when OS user name includes special symbols, in Direct mode. Fixed bug loading Int32 value into a NUMBER column using OracleLoader via Oracle ...

Notes de publication : Database Wizard. LinqConnect (formerly known as LINQ to Oracle) Fixed "Could not find element type in model" bug when loading XML mapping in Microsoft.NET Standard LinqConnect assemblies. Fixed bug ... the BINARY(16) column mapped to the byte[] class property, when "Binary As Guid=True;" is set in the connection string, in EF Core. ...

Description : for developing Oracle-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications. dotConnect ... tracing of database events with a free dbMonitor application. Security- Supports various encryption algorithms, OS authentication, Proxy authentication, Oracle Data Integrity, etc. The Standard Edition ... Edition combines the whole featureset with including dbForge Fusion for Oracle Standard Edition, an advanced add-in for designing databases and easily managing data and schema objects from your IDE. ...

Notes de publication : is now supported. Changed behavior: No additional connection is opened to the database before the first query in EF Core when config.Workarounds.ProviderManifestToken is set explicitly. Fixed the error ... by the UseOracle(DbConnection connection) extension method of DbContextOptionsBuilder in EF Core 6 and EF Core 7. Fixed the bug using custom converters in mapping in EF Core 3 and higher. Fixed the bug using ...

Compatibilité : dotConnect for Oracle also supports Oracle Database Cloud- a Database as a Service (DBaaS) solution from Oracle. For Entity Framework and LinqConnect dotConnect for Oracle supports Oracle servers 9i ...

Notes de publication : arguments at the end of argument list instead of actual position in method signature by Update From Database Wizard has been fixed. The bug with placing procedure with no parameters in the Procedures node ... instead of being enlisted in its package's node of Update From Database Wizard tree in the case of Oracle 18c and higher has been fixed. Entity Framework support The bug with generating invalid SQL, ... when the sdo_geometry column is part of a subquery, in Entity Framework Core 3 has been fixed. The bug with using another context's connection in DbContextOptionsBuilder.UseOracle(connection ...

Notes de publication : in the schema of the table to which the index belongs. Fixed the bug with blocking thread during retrieving a connection from the pool, when connections from the same pool are used in several threads. Fixed ...

Notes de publication : Model, when Entity Framework Core version=EF Core 1 in Model Settings. Fixed the bug with throwing System.NullReferenceException when saving the changed value of the "Save connection to" option ... by update-database-script when config.CodeFirstOptions.DropConstraintsByColumns=true in Entity Framework 6.4.4. Fixed the bug with throwing ORA-00920 by the GeometryCollection.Intersects method when using NetTopologySuite ...

Spécifications : Framework   Supported Databases           Oracle   Included Classes           Native data types classes and structures DataLink class Common ADO.NET classes OracleAlerter class OracleDatabase class ... Advanced Visual Studio Integration ASP.NET providers support DataSet Manager and Editor DataSet Wizard dbForge Fusion for Oracle Standard Edition dbMonitor support Design-time Features Direct mode to connect ...

Notes de publication : Adds support for Microsoft.NET 6.0. Added support for Microsoft.NET 6.0. Entity Developer Changed behavior: Turning off the "Save connection to" option in Model Settings of Entity ... Framework Core Model wipes out connection string literal from the generated code. Entity Framework support The SQL translation of the following class members used in LINQ query is now supported in Entity ... supported in Entity Framework Core 5 and 6. Mapping of Oracle object types like MDSYS.SDO_GEOMETRY or Oracle user-defined object datatypes in a database to the OracleObject class in Entity Framework Core 3, 5 ...

Notes de publication : Fixed bug with wrong Metadata Artifact Processing setting for Web Site projects in Entity Framework models Entity Framework support Microsoft Generate Database from Model Wizard: Changed Date type ...

Notes de publication : with the detection of non-existent changes while updating a model from a database. Fixed the bug with creating Devart Entity Model in Visual Studio 2022. Fixed the bug with missing model context namespace ...

Notes de publication : even when its type is different, in TPH inheritance of Entity Framework Core Model. Entity Framework support Fixed the bug with incomplete SQL generation by update-database-script in Entity Framework ...

Notes de publication : attributes. Fixed the bug with string conversion by OracleTimeStamp.ToString(), when.ToString() includes FF fractional seconds format and the database column is TIMESTAMP(0). Fixed the bug with throwing ...

Notes de publication : in Association Editor to the Generate Database Script functionality in Entity Framework Core Model. Fixed bug reading settings from *.edps by console Entity Developer. Entity Framework support Fixed bug ...

Notes de publication : to UserStore class. Database server version added to generated Code-First Migrations scripts. OracleDataAdapter and OracleDataTable class performance improved. Parameter performace improved. Reading and writing ...

Notes de publication : Updates in dotConnect for PostgreSQL V5.0, dotConnect for MySQL V5.0 and dotConnect for Oracle V6.0 Added the 'Validate Connection' connection string parameter to validate a connection ...

Notes de publication : Added support for Microsoft.NET 8. Microsoft Visual Studio 2022 version 17.9 Preview is now supported. Added support for connecting to servers with enabled Security Banners in Direct mode. Entity ...

Notes de publication : 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. Microsoft Entity Framework support Entity Framework Core 7.0.2 is now supported. Entity Framework Core 6.0.13 is ...