I have try to use number mapping settings for one column (TEST_NUMB1 in example) in our Oracle12 Database. I was map NUMBER(1) oracle type to Int16 .NET type. But mapping is allways generated with bool .NET type.
See:
http://blog.devart.com/new-features-of- ... erMappings
This configuration can I see in *.edps file:
Code: Select all
<Connection ConnectionString="User Id=54353N;Password=***;Server=TEST;Direct=True;Sid=ORCL12c;Persist Security Info=True;Number Mappings=(NUMBER,1,1,System.Int16)" Provider="Devart.Data.Oracle" />
Code: Select all
CREATE TABLE IDENTITY_TEST_TAB
(
ID NUMBER GENERATED ALWAYS AS IDENTITY,
DESCRIPTION VARCHAR2(30 BYTE),
TEST_NUMB1 NUMBER(1),
TEST_VCHAR1 VARCHAR2(1)
);
Code: Select all
<!-- SSDL content -->
<edmx:StorageModels>
<Schema Namespace="MyModel.Store" Alias="Self" Provider="Devart.Data.Oracle" ProviderManifestToken="Oracle, 12.1.0.1" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:devart="http://devart.com/schemas/edml/StorageSchemaExtensions/1.0" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
<EntityContainer Name="MyEntitiesStoreContainer">
<EntitySet Name="IDENTITY_TEST_TABs" EntityType="MyModel.Store.IDENTITY_TEST_TAB" store:Type="Tables" Schema="54353N" Table="IDENTITY_TEST_TAB" />
</EntityContainer>
<EntityType Name="IDENTITY_TEST_TAB">
<Key>
<PropertyRef Name="ID" />
</Key>
<Property Name="ID" Type="decimal" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="DESCRIPTION" Type="VARCHAR2" MaxLength="30" />
<Property Name="TEST_NUMB1" Type="bool" />
<Property Name="TEST_VCHAR1" Type="VARCHAR2" MaxLength="1" />
</EntityType>
</Schema>
</edmx:StorageModels>
Thank’s for any idea!
Best regards
Jaroslav