Hello guys,
I tryed to find a topic related to this subject but I had no success.
When I execute a query on SQL Server on a UNIQUEIDENTIFIER field it returns a System.Guid type. I guess it is the provider that maps the value to the .Net Guid structure. right?
In Oracle case, a Raw(16) field returns a System.Byte[] type. My question is: the Devart Oracle provider maps to Guid automaticaly? Or do I have to map by myself? Or is there another way to mapping/cast it clear to the engine (return a Guid)?
Thanks in advance.
Fernando Mello
Oracle vs Guid
This is a designed behaviour.luizao.fernando wrote:In Oracle case, a Raw(16) field returns a System.Byte[] type.
No.luizao.fernando wrote:My question is: the Devart Oracle provider maps to Guid automaticaly?
There is no such possibility because connection level mapping is implemented only for the numeric data types.luizao.fernando wrote:Or do I have to map by myself?
1. You can retrieve Guid from database using OracleDataReader.GetGuid().luizao.fernando wrote:Or is there another way to mapping/cast it clear to the engine (return a Guid)?
2. By default, RAW(16) in our Entity Framework and LinqConnect implementations is mapped to System.Guid.
-
- Posts: 2
- Joined: Wed 11 May 2011 14:56