Support for other native data types and user defined types
Well it has to be in the .NET Framework data types, not sure whether there would be any work to do in EF for this. Meanwhile there should be a provision to include the new data types in the backend. for e.g. Oracle can have it's own user defined types, SQLServer 2008 R2 has HierarchyID datat type which I am not sure to what datatype it would map to at the conceptual level
We should have provision for such types
12 comments
-
Brian
commented
Spatial Data!
-
Toby Harman
commented
All the SQL specific data types should be supported in EF if this is expected to be the ORM of choice.
SQLVariant, XML, Hierarchy
-
Murat BUDAK
commented
hierarchyid thumbup
-
Murat BUDAK
commented
hierarchyid is important for the many large application. I am not thinking that who is not use hierarchyid in their applications. All the peoples are using their homemade solutions for the hierarchy. We need standardisation.
-
Toby Harman
commented
Almost Aaron, except that this one includes HierarchyId as well
-
Aaron Shumaker
commented
-
Tony H.
commented
Currently, SQL Server spatial types can only be supported by some intermediate hacks (e.g. using Triggers to convert and save basic types to spatial types, etc.). One has to evaluate the benefits of leveraging the EF along with the overhead of these hacks or is the the proper solution is to create a custom Data Access Layer. EIther way there is some heavy lifting. Thanks.
-
Jean C. Nunez
commented
Will be perfect if they released it on the next version...
-
Courtney Mills
commented
Can't wait till geometry and geography are supported.
-
Rick Langel
commented
We need this.
-
alYsa
commented
HierarchyID is critical, because it would allow seamless mapping of hierarchies represented in sql server to hierarchy on .Net side. I guess it would be best if it maps HierarchyID column to a collection of elements on .Net side.
-
PAL
commented
HierarchyID