BCD data type is not supported

Discussion of open issues, suggestions and bugs regarding EntityDAC
Post Reply
simon.thompson
Posts: 1
Joined: Thu 08 Feb 2018 14:49

BCD data type is not supported

Post by simon.thompson » Mon 12 Feb 2018 09:09

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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: BCD data type is not supported

Post by MaximG » Wed 14 Feb 2018 08:54

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

Post Reply