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