I am completely new to the product so I may have made a simple mistake but I am having this issue with my first attempt to use EntityDAC.
I am running through the getting started routine but using SQL Server and an existing table of my own.
I have an EntityConnection with provider name SDAC and dialect name SQL Server. The connection tests OK.
I have a decimal field in my table and it seems to be this that EntityDAC seems to be objecting to.
Does EntityDAC support decimal fields? If so, what do I need to do?
Are there any other restrictions to EntityDAC.
BCD data type is not supported
Re: BCD data type is not supported
Currently, EntityDAC does not support working with the BCD data type. We will add support for this type in one of the next builds of our product.
As a workaround, you can use another type when working with DECIMAL fields. For this, change the default value for the corresponding Type Mapping Rule:
- in EntityDeveloper, select the menu item "Tools"\"Options"
- go to the tab "Servers' Options"\"SQL Server"
- find the rule with Server Type = decimal and click the "Edit" button
As a workaround, you can use another type when working with DECIMAL fields. For this, change the default value for the corresponding Type Mapping Rule:
- in EntityDeveloper, select the menu item "Tools"\"Options"
- go to the tab "Servers' Options"\"SQL Server"
- find the rule with Server Type = decimal and click the "Edit" button