Search found 9854 matches
- Tue 08 Feb 2022 16:28
- Forum: Entity Framework support
- Topic: Spartial mapping exception
- Replies: 2
- Views: 14763
Re: Spartial mapping exception
Thank you for your report. We have reproduced the issue and will notify you about the results of our investigation.
- Tue 08 Feb 2022 16:28
- Forum: Entity Framework support
- Topic: Spartial mapping exception
- Replies: 3
- Views: 24099
Re: Spartial mapping exception
Thank you for your report. We have reproduced the issue and will notify you about the results of our investigation.
- Wed 02 Feb 2022 10:06
- Forum: dotConnect for Oracle
- Topic: Object reference not set to an instance of an object.
- Replies: 2
- Views: 5621
Re: Object reference not set to an instance of an object.
1. Have you installed dotConnect for Oracle v9.16.1434 25-Jan-22 successfully?
2. Please tell us how we should modify this DDL script to reproduce the issue with lost FK to a materialized view?
FK is detected by Entity Developer in our environment: https://prnt.sc/26nc3u0.
2. Please tell us how we should modify this DDL script to reproduce the issue with lost FK to a materialized view?
Code: Select all
CREATE TABLE T1(
ID NUMBER PRIMARY KEY,
NAME VARCHAR2(100)
);
CREATE MATERIALIZED VIEW T1_MV AS SELECT * FROM T1;
CREATE TABLE T2(
ID NUMBER PRIMARY KEY,
NAME VARCHAR2(100),
ID_T2 NUMBER,
CONSTRAINT T1_MV_FK FOREIGN KEY (ID_T2) REFERENCES T1_MV (ID)
);
- Fri 28 Jan 2022 14:38
- Forum: dotConnect for PostgreSQL
- Topic: Postgresql Driver to connect Nhibernate
- Replies: 1
- Views: 12862
Re: Postgresql Driver to connect Nhibernate
Please follow this walkthrough: viewtopic.php?t=28844#p98534.
- Fri 28 Jan 2022 14:37
- Forum: dotConnect for PostgreSQL
- Topic: Unable to load dotConnect ADO.NET provider for NHibernate
- Replies: 3
- Views: 15521
Re: Unable to load dotConnect ADO.NET provider for NHibernate
The name of the provider is dotConnect for PostgreSQL Professional Edition. Please follow this walkthrough: viewtopic.php?t=28844#p98534.
- Thu 27 Jan 2022 17:06
- Forum: dotConnect for Oracle
- Topic: Exception while creating migration sql file
- Replies: 3
- Views: 14385
Re: Exception while creating migration sql file
The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed in dotConnect for Oracle v9.16.1434.
- Thu 27 Jan 2022 16:47
- Forum: dotConnect for Oracle
- Topic: Error with 9.14.1369 - Unable to cast object of type 'Devart.Common.Entity.db' to type 'Devart.Common.Entity.a6'
- Replies: 2
- Views: 10392
Re: Error with 9.14.1369 - Unable to cast object of type 'Devart.Common.Entity.db' to type 'Devart.Common.Entity.a6'
The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed in dotConnect for Oracle v9.16: viewtopic.php?f=1&t=53190.
- Thu 27 Jan 2022 16:41
- Forum: dotConnect for Oracle
- Topic: Spatial linq queries not working
- Replies: 9
- Views: 23256
Re: Spatial linq queries not working
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.
Refer to viewtopic.php?f=1&t=53190.
Refer to viewtopic.php?f=1&t=53190.
- Thu 27 Jan 2022 16:40
- Forum: dotConnect for Oracle
- Topic: How to force the use of the SDO_RELATE spatial operator
- Replies: 1
- Views: 13510
Re: How to force the use of the SDO_RELATE spatial operator
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.
Refer to viewtopic.php?f=1&t=53190.
Refer to viewtopic.php?f=1&t=53190.
- Thu 27 Jan 2022 16:31
- Forum: dotConnect for MySQL
- Topic: Filter and aggregation on JSON columns
- Replies: 2
- Views: 29696
Re: Filter and aggregation on JSON columns
The new methods ExtractAsByte(), ExtractAsSByte(), ExtractAsInt16(), ExtractAsInt32(), ExtractAsInt64(), ExtractAsSingle(), ExtractAsDouble(), ExtractAsDecimal(), ExtractAsDateTime() are added to the MySqlJsonFunctions class for working with the JSON data type in LINQ to Entities queries.
Refer to viewtopic.php?f=2&t=53186.
Refer to viewtopic.php?f=2&t=53186.
- Thu 27 Jan 2022 16:12
- Forum: dotConnect for Oracle
- Topic: Devart.Data.Oracle.EFCore v9.15.1410 'ORA-00911: invalid character' when using transaction
- Replies: 4
- Views: 10599
Re: Devart.Data.Oracle.EFCore v9.15.1410 'ORA-00911: invalid character' when using transaction
dotConnect for Oracle 9.16 is released: viewtopic.php?f=1&t=53190.
- Thu 27 Jan 2022 16:10
- Forum: Entity Framework support
- Topic: OracleException: ORA-00933: SQL command not properly ended
- Replies: 2
- Views: 15355
Re: OracleException: ORA-00933: SQL command not properly ended
dotConnect for Oracle 9.16 is released: viewtopic.php?f=1&t=53190.
- Thu 27 Jan 2022 16:02
- Forum: dotConnect for Oracle
- Topic: Unable te retrieve geometries with circular arcs
- Replies: 1
- Views: 11516
Re: Unable te retrieve geometries with circular arcs
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 in dotConnect for Oracle v9.16.
Please upgrade and make sure that:
1) UseNetTopologySuite() is not used in options
2) mapping includes column type
Please upgrade and make sure that:
1) UseNetTopologySuite() is not used in options
2) mapping includes column type
Code: Select all
protected override void OnModelCreating(ModelBuilder modelBuilder) {
modelBuilder.Entity<Region>()
.Property(x => x.Geometry)
.HasColumnType(@"SDO_GEOMETRY");
}
- Wed 26 Jan 2022 18:01
- Forum: dotConnect for MySQL
- Topic: EntityDeveloper not working
- Replies: 8
- Views: 27937
Re: EntityDeveloper not working
The new build dotConnect for MySQL v8.21.2066 includes the following improvements:
* C:\Program Files (x86)\Devart\dotConnect\MySQL\NET4\Devart.Data.dll
* C:\Program Files (x86)\Devart\dotConnect\MySQL\NET4\Devart.Data.MySql.dll
* C:\Program Files (x86)\Devart\dotConnect\MySQL\Entity\EF5\net47\Devart.Data.MySql.Entity.EF5.dll
- The new \Entity\EF5\net47\Devart.Data.MySql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
- The behavior is changed: Devart.Data.MySql.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models
* C:\Program Files (x86)\Devart\dotConnect\MySQL\NET4\Devart.Data.dll
* C:\Program Files (x86)\Devart\dotConnect\MySQL\NET4\Devart.Data.MySql.dll
* C:\Program Files (x86)\Devart\dotConnect\MySQL\Entity\EF5\net47\Devart.Data.MySql.Entity.EF5.dll
- Tue 25 Jan 2022 11:13
- Forum: Entity Framework support
- Topic: OracleException: ORA-00933: SQL command not properly ended
- Replies: 2
- Views: 15355
Re: OracleException: ORA-00933: SQL command not properly ended
The bug with auto savepoints enabled in EF Core 6 transactions is fixed. We will notify you when a new public build of dotConnect for Oracle is available for download.
The internal build with the fix can be downloaded from http://download.devart.com/nuget_oracle_9_15_1419.zip.
The internal build with the fix can be downloaded from http://download.devart.com/nuget_oracle_9_15_1419.zip.