Mapping Oracle DataTypes to .Net DataTypes
Posted: Tue 16 Jan 2018 06:42
Hello,
When using Entity Framework 6.0 with Oracle, I did mapped several Oracle Number types to different .Net DataTypes. For example, by default Number(1) in Oracle generated as Bool in .net. I overcome this challenge by defining edmNumberMapping in app.config file. Example can be seen below.
What I need is mapping Oracle Number types to different dotnet dataTypes in .Net Core 2.0. I'm scaffolding entities of Oracle Database by following command in Package Manager Console.
How can we customize data mapping in dotConnect for Oracle with .net core 2.0 ?
Scaffold-DbContext "Server=SERVER_IP;Port=SERVER_PORT; Sid=DB_SID; UserId=USERNAME; Password=PWD; license key=LICENSE_KEY;Direct=true" Devart.Data.Oracle.Entity.EFCore -Schemas EXAMPLE_SCHEMA -Tables EXAMPLE_TABLE
When using Entity Framework 6.0 with Oracle, I did mapped several Oracle Number types to different .Net DataTypes. For example, by default Number(1) in Oracle generated as Bool in .net. I overcome this challenge by defining edmNumberMapping in app.config file. Example can be seen below.
Code: Select all
<oracle.manageddataaccess.client>
<version number="*">
<edmMappings>
<edmNumberMapping>
<add DBType="Number(1)" MinPrecision="1" MaxPrecision="1" NETType="Int16" />
<add DBType="Number" MinPrecision="1" MaxPrecision="1" NETType="Int16" />
<add DBType="Number" MinPrecision="1" MaxPrecision="2" NETType="Int16" />
<add DBType="Number" MinPrecision="3" MaxPrecision="10" NETType="Int32" />
<add DBType="Number" MinPrecision="11" MaxPrecision="19" NETType="Int64" />
</edmNumberMapping>
</edmMappings>
</version>
</oracle.manageddataaccess.client>
How can we customize data mapping in dotConnect for Oracle with .net core 2.0 ?
Scaffold-DbContext "Server=SERVER_IP;Port=SERVER_PORT; Sid=DB_SID; UserId=USERNAME; Password=PWD; license key=LICENSE_KEY;Direct=true" Devart.Data.Oracle.Entity.EFCore -Schemas EXAMPLE_SCHEMA -Tables EXAMPLE_TABLE