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 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
odelete the sub-rule for unsigned tinyint(1), that maps it to bool;
odelete the sub-rule for bit(1), and reset the general rule for bit mapping from Int64 to Boolean;
odelete the sub-rule for binary(1), that maps it to Byte;
odelete the sub-rule for varbinary(1), that maps it to Byte;
oadd a sub-rule for binary(16), that will map it to Guid;
oadd a sub-rule for char(36), that will map it to Guid.

 

Npgsql
ochange the rule for timestamptz, to map this type to DateTimeOffset, not to DateTime.

note Note

Note that the set of types supported by Devart is larger

 

System.Data.SQLite
odelete all sub-rules for INTEGER, and reset the general rule for INTEGER mapping from Int32 to Int64;
odelete all sub-rules for INT;
ochange the rule for REAL, to map this type to Single, not to Double.

note Note

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

 

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

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

ExpandedToggleIcon        See Also


Send feedback on this topic

© 2008 - 2024 Devart. All rights reserved.