I'm currently attempting to migrate from 4.6 to 5.0. As the the DB well pre-dates DO, we use DomainUpgradeMode.LegacyValidate, but have a substantial portion of the DB that the ORM is not concerned with at all. Unfortunately, after moving to 5.0 TypeMappingRegistry throws System.NotSupportedException: Type 'Unknown' is not supported. due to the existence of columns that use SQL Server's Money type. Is there any easy way to just get these columns to map to Decimal without having to re-implement the whole sql server driver?

Additionally, I've looked for but been unable to find a 5.0 migration guide, can you point me towards one?

asked Aug 29 '16 at 13:22

GigMastersTech's gravatar image


One Answer:

Hello GigMestersTech,

If there is a part of DB which ORM shouldn't be responsible for, it may be ignored by DO. Certain columns or even tables may be ignored. You also can define a prefix for tables which should be ignored by DO. You can add your rules to DomainConfiguration.IgnoreRules collection.

If you need to include money columns to DO class model, unfortunately, you can't do it - DO doesn't support it for now. As far as I know, Money type is based on Decimal type but has some difference. If it doesn't meter for you then use decimal. You will need to migrate data from money columns to decimal columns manually one time.

Migration process depends on each solution so there is no silver bullet. I answer the questions quite quickly, especially questions from Ultimate license owners. Anyway you can send me a question personally.

answered Aug 30 '16 at 05:28

Alexey%20Kulakov's gravatar image

Alexey Kulakov

Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

powered by OSQA