Devart is glad to announce the release of dotConnect for Oracle 9.16 with the improvement of Entity Framework Core. New data types Uri, IPAddress, PhysicalAddress are supported and еру ability to translate LINQ queries into SQL is expanded. We have also expanded the support for Entity Framework Core Spatial Data functionality used to work with Oracle Spatial and Graph.
Here is the complete list of dotConnect for Oracle 9.16.1434 changes:
Entity Developer
- The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
- The SQL translation of the following class members used in the LINQ query is supported in EF Core 3, EF Core 5, EF Core 6:
- static method IsNullOrWhiteSpace() of the String class
- static property Today and instance property DayOfWeek of the DateTime class
- static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the Math class
- The SQL translation of the following class members used in LINQ query is supported in EF Core 5 and EF Core 6:
- static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the MathF class
- The SQL translation of the following class members used in LINQ query is supported in EF Core 6:
- static method Log2() of the Math and MathF classes
- Mapping of internet/intranet data type System.Uri to Oracle string data types is supported in EF Core 3, EF Core 5, EF Core 6
- Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to Oracle string data types is supported in EF Core 5 and EF Core 6
- Mapping of Oracle object types like MDSYS.SDO_GEOMETRY or Oracle user-defined object datatypes in a database to the OracleObject class in EF Core 3, EF Core 5, EF Core 6 is supported
- The config.SpatialOptions.PreferSpatialOperators configuration option is added (default value is False) to provide the possibility of using spatial operators instead of functions from the SDO_GEOM package
- The bug with auto savepoints enabled in EF Core 6 transactions is fixed
- The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
- The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
- The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed
http://www.devart.com/dotconnect/oracle/