Spatial constant functionality not implemented yet

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
michalw
Posts: 1
Joined: Wed 27 Jan 2016 12:37

Spatial constant functionality not implemented yet

Post by michalw » Wed 27 Jan 2016 14:51

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);

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Spatial constant functionality not implemented yet

Post by Shalex » Thu 28 Jan 2016 11:53

Thank you for your report. We will notify you when the spatial constant functionality is implemented.

smokeing
Posts: 23
Joined: Fri 09 Oct 2015 00:51

Re: Spatial constant functionality not implemented yet

Post by smokeing » Thu 04 Feb 2016 14:39

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?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Spatial constant functionality not implemented yet

Post by Shalex » Fri 05 Feb 2016 14:26

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).

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Spatial constant functionality not implemented yet

Post by Shalex » Tue 09 Feb 2016 10:54

The spatial constant functionality is implemented. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Spatial constant functionality not implemented yet

Post by Shalex » Thu 11 Feb 2016 15:24

The new build of dotConnect for Oracle 8.5.592 is available for download: http://forums.devart.com/viewtopic.php?f=1&t=33201.

Post Reply