Page 1 of 1

Data type mapping when creating a function import

Posted: Fri 25 Jun 2010 12:58
by JSkibisky
When bringing an Oracle stored procedure into the entity model, number and integer types are mapped to type decimal. This is problematic when attempting to map a stored procedures for INSERT, UPDATE, etc. functions on an entity. It makes it impossible to designate a column as the "Rows Affected" parameter as the designer will only recognize integer types for that purpose. Manually changing the types in the XML causes issues with the designer. Are there any ways to control, or otherwise modify, data types once a function import has been established?

Posted: Tue 29 Jun 2010 15:42
by Shalex
Please refer to the Entity Framework Data Type Mapping article. If the problem persists, specify the exact types that are mapped not correctly.