Error when using multiple .Include()

[avalor]

I'm using dotConnect for Oracle 8.3.125 and EF6.1 and I'm getting an error when trying to run this query:

Code: Select all

var res = db.PROPIEDADVALOR
    .Include(x => x.COORDENADA)
    .Include(x => x.PROPIEDAD.COMPOSICION)
    .Include(x => x.PROPIEDADVALORCOMPOSICION)
    .Include(x => x.USUARIO)
    .Where(x => x.PROPIEDADID == id &&
       x.COORDENADA.Any(c => c.FECHAHORAPDA >= fecha && c.FECHAHORAPDA < DbFunctions.AddDays(fecha, 1).Value && c.LATITUD != 0 && c.LONGITUD != 0));

The error says: 'System.Data.Entity.Core.EntityCommandCompilationException - An error occurred while preparing the command definition. See the inner exception for details.
System.NotSupportedException - Casting to 'r' is not supported.'

If I comment the first or the second .Include(), it works well, also if I comment two of the Includes.

[Shalex]

Could you please send us a small test project with the corresponding DDL/DML script for reproducing the issue in our environment?

[avalor]

OK. I'll try to reproduce it on next monday

[avalor]

Hi!
I've just sent you a small test project reproducing the issue.

[Shalex]

Thank you for the test project. We are investigating the issue.

[Shalex]

The bug with using multiple .Include() with spatial columns is fixed. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

[Shalex]

New build of dotConnect for Oracle 8.3.135 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=29348.

[avalor]

I can confirm that the fix works perfectly.

Thank you so much