Spatial constant functionality not implemented yet

Spatial constant functionality not implemented yet

Postby 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);
michalw
 
Posts: 1
Joined: Wed 27 Jan 2016 12:37

Re: Spatial constant functionality not implemented yet

Postby Shalex » Thu 28 Jan 2016 11:53

Thank you for your report. We will notify you when the spatial constant functionality is implemented.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: Spatial constant functionality not implemented yet

Postby 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?
smokeing
 
Posts: 23
Joined: Fri 09 Oct 2015 00:51

Re: Spatial constant functionality not implemented yet

Postby 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
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: Spatial constant functionality not implemented yet

Postby 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
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: Spatial constant functionality not implemented yet

Postby 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.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle