Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

.Net EntityFrameworkCore selecting area from Geometry datatype

user-meuswMay 16 2023

Hi,

I'm trying to convert from using in line sql to EF core.

Part of the original sql returns as one of the selected values are the area and perimeter of each geometry object.

This uses:

sdo_geom.sdo_area( os.geometry, 0.005 ) area
and sdo_geom.sdo_length( os.geometry, 0.005 ) perimeter

I cannot find any references on line as how to do this. I see Devart does things with NetTopologySuite but I don't have a license for that.

Doesn't Oracle's EntityFramework core nuget package support Geometry data types and functions?

Any help would be greatly appreciated.

This post has been answered by Alex Keh-Oracle on May 16 2023
Jump to Answer
Comments
Post Details
Added on May 16 2023
2 comments
200 views