Page 1 of 1

Spatial constant functionality not implemented yet

Posted: Wed 27 Jan 2016 14:51
by michalw
I have a problem with strange error "Spatial constant functionality not implemented yet." in Devart.Data.Oracle.Entity which occurs while building expression trees with DbGeometry type as constant. What it means? Is building expression with spatial types impossible yet? Or is there any workaround?

I currently use Devart.Data.Oracle.Entity 8.5.563

Code: Select all

public static IQueryable<TEntity> ReflectionAnyInteract<TEntity>(this IQueryable<TEntity> queryable, ParameterExpression param, Expression property, object value)
        {
            var expression = Expression.Lambda<Func<TEntity, bool>>(
                            Expression.Call(
                                property,
                                DbGeometryAnyInteract,
                                Expression.Constant(value)),
                        param);
            return queryable.Where(expression);
        }

MethodInfo DbGeometryAnyInteract = typeof(DbGeometry).GetMethods().First(m => m.Name == "Crosses" && m.GetParameters().Length == 1);

Re: Spatial constant functionality not implemented yet

Posted: Thu 28 Jan 2016 11:53
by Shalex
Thank you for your report. We will notify you when the spatial constant functionality is implemented.

Re: Spatial constant functionality not implemented yet

Posted: Thu 04 Feb 2016 14:39
by smokeing
I am also interested in this feature.

BTW.

Code: Select all

var query = Context.Plan.Where(c => c.Geom.Intersects(DbGeometry.FromText("POINT (394433.61 677532.21)")));
How would this code look like in Expression syntax?

Re: Spatial constant functionality not implemented yet

Posted: Fri 05 Feb 2016 14:26
by Shalex
michalw wrote:I have a problem with strange error "Spatial constant functionality not implemented yet." in Devart.Data.Oracle.Entity which occurs while building expression trees with DbGeometry type as constant.
smokeing wrote:I am also interested in this feature.
The feature is implemented. We will notify you when the corresponding build of dotConnect for Oracle is available for download.
smokeing wrote:BTW.

Code: Select all

var query = Context.Plan.Where(c => c.Geom.Intersects(DbGeometry.FromText("POINT (394433.61 677532.21)")));
How would this code look like in Expression syntax?
This question is not provider specific (exceeds the goals of our support).

Re: Spatial constant functionality not implemented yet

Posted: Tue 09 Feb 2016 10:54
by Shalex
The spatial constant functionality is implemented. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

Re: Spatial constant functionality not implemented yet

Posted: Thu 11 Feb 2016 15:24
by Shalex
The new build of dotConnect for Oracle 8.5.592 is available for download: http://forums.devart.com/viewtopic.php?f=1&t=33201.