1. Create a class model in the Entity Developer, standalone program.
2. Add primary key and prosperities as you normally would, add a column "myitem" with data type int32.
3. Copy "myitem" to "sku"
4. change "sku" to data type string.
5. Generate the class model code and you will find the data type is incorrect.
If you have a look inside the efml you will find entity developer saved this xml with the wrong sql-type
Code: Select all
<property name="Sku" type="String" p1:nullable="True" p1:ValidateRequired="false" p1:Guid="5236fc66-aaea-4f6f-8ca7-fa132b9e841b">
<column name="" not-null="False" sql-type="int4" p1:unicode="False" />
</property>
Code: Select all
<property name="Sku" type="String" p1:nullable="True" p1:ValidateRequired="false" p1:Guid="5236fc66-aaea-4f6f-8ca7-fa132b9e841b">
<column name="" not-null="False" sql-type="varchar" p1:unicode="False" />
</property>