Print Page | Close Window

mapping Oracle spatial data

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2009
Forum Discription: For .NET 3.5
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1620
Printed Date: 17-Apr-2025 at 10:16pm


Topic: mapping Oracle spatial data
Posted By: erturkcevik
Subject: mapping Oracle spatial data
Date Posted: 20-Jan-2010 at 11:47pm
How can I using Oracle spatial data to Devforce Winclient?
 
Regards
 


Replies:
Posted By: davidklitzke
Date Posted: 21-Jan-2010 at 9:03am
This would depend upon the provider that you would be using. If the provider supports this feature within the Microsoft Entity Framework, it should also work with DevForce.
 
The one Oracle provider that I am aware of for the Entity Framework comes from Devart.

Posted By: erturkcevik
Date Posted: 28-Jan-2010 at 1:47am
Hi;
This sample code using spatial data with ODP.NET
 
[OracleCustomTypeMappingAttribute("MDSYS.SDO_POINT_TYPE")]
02.public class SdoPoint : OracleCustomTypeBase<SdoPoint>
03.{
04.    public decimal? X { get; set; }
05.    public decimal? Y { get; set; }
06.    public decimal? Z { get; set; }
07.  
08.    /* ... details omitted for clarity  */
09.}
10.  
11.[OracleCustomTypeMappingAttribute("MDSYS.SDO_GEOMETRY")]
12.public class SdoGeometry : OracleCustomTypeBase<SdoGeometry>
13.{
14.    public decimal? Sdo_Gtype { get; set; }
15.    public decimal? Sdo_Srid { get; set; }
16.    public SdoPoint Point { get; set; }
17.    public decimal[] ElemAray { get; set; }
18.    public decimal[] OrdinatesArray { get; set; }
19.      
20.    /* ... details omitted for clarity  */
 
Please writing me how can I can using Oracle Spatial data with DevForce?
For Example how can I setting to field type of the SDO_GEOMETRY?
 
Regards
 
 
 

Posted By: davidklitzke
Date Posted: 28-Jan-2010 at 9:33am

To my knowledge, ODP.NET is not an Entity Framework compatible provider for Oracle.  Do you have evidence to the contrary?

As I mentioned in my previous post, Devart does have an Entity Framework compatible Oracle provider, and you can try it for free for 90 days.

Posted By: erturkcevik
Date Posted: 28-Jan-2010 at 9:38am

Ok, Thanks


Print Page | Close Window