Third-party providers support

In Entity Developer for Entity Framework server mapping types are oriented to Devart products, therefore models created in Entity Developer using third-party providers can differ from models created using the same providers but in ADO.NET Entity Data Model Designer. In order to eliminate these differences, identical type mapping rules should be set.

If necessary, to avoid differences and incorrect operation, make changes to type mapping rules as described below.

For this, do the following:

1. From the application’s main menu, select Tools and then select Options.

Note

If you are using Entity Developer as an add-in to Microsoft Visual Studio, to access this functionality, select Tools –> Options and then, in the navigation pane of the Options dialog box, select Entity Developer –> Servers’ Options.

2. Change the corresponding type mapping rules:

MySQL Connector/Net

  • delete the sub-rule for unsigned tinyint(1), that maps it to bool;
  • delete the sub-rule for bit(1), and reset the general rule for bit mapping from Int64 to Boolean;
  • delete the sub-rule for binary(1), that maps it to Byte;
  • delete the sub-rule for varbinary(1), that maps it to Byte;
  • add a sub-rule for binary(16), that will map it to Guid;
  • add a sub-rule for char(36), that will map it to Guid.

Npgsql

  • change the rule for timestamptz, to map this type to DateTimeOffset, not to DateTime.

Note

Note that the set of types supported by Devart is larger.

System.Data.SQLite

  • delete all sub-rules for INTEGER, and reset the general rule for INTEGER mapping from Int32 to Int64;
  • delete all sub-rules for INT;
  • change the rule for REAL, to map this type to Single, not to Double.

Note

Note that the set of types supported by Devart is significantly larger.

ODP.NET

  • change the rule for INTERVAL YEAR TO MONTH, to map this type to Decimal, not to String;
  • change the rule for INTERVAL DAY TO SECOND, to map this type to Decimal, not to Time;
  • delete all sub-rules for NUMBER and set the following ones:
    • NUMBER(0-5) - Int16;
    • NUMBER(6-10) - Int32;
    • NUMBER(11-19) - Int64;
  • delete the sub-rules for FLOAT(1-10), that maps it to Single.

For details on the Options dialog box refer to the Servers’ options section.

See also

Servers’ options