New Posts New Posts RSS Feed: mapping Oracle spatial data
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

mapping Oracle spatial data
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
erturkcevik View Drop Down
Groupie
Groupie


Joined: 14-Jun-2007
Location: Turkey
Posts: 40 		Post Options Post Options   Quote erturkcevik Quote  Post ReplyReply Direct Link To This Post Topic: mapping Oracle spatial data
    Posted: 20-Jan-2010 at 11:47pm
How can I using Oracle spatial data to Devforce Winclient?
 
Regards
 
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
erturkcevik View Drop Down
Groupie
Groupie


Joined: 14-Jun-2007
Location: Turkey
Posts: 40 		Post Options Post Options   Quote erturkcevik Quote  Post ReplyReply Direct Link To This Post 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
 
 
 
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
erturkcevik View Drop Down
Groupie
Groupie


Joined: 14-Jun-2007
Location: Turkey
Posts: 40 		Post Options Post Options   Quote erturkcevik Quote  Post ReplyReply Direct Link To This Post Posted: 28-Jan-2010 at 9:38am

Ok, Thanks
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down