MigSharp icon indicating copy to clipboard operation
MigSharp copied to clipboard

Published 20 hours ago • verified publisher icon dradovic

Support for XML Data Type

Open anishpateluk opened this issue 11 years ago • 3 comments

Cannot create columns of type DbType.Xml when using SqlServer2012 provider. The error message I get is:

System.InvalidOperationException: Cannot execute the migration(s) as there are validation errors: Migration 'Migrations.Migration9' uses the data type 'Xml' which is not supported by 'SqlServer2012'.

anishpateluk avatar May 30 '14 09:05 anishpateluk

Yes. Support for this data type has not been added yet. A primary design goal for Mig# was to provide a framework that enables you to painlessly switch database platforms with only have to write DAL code once. Using too specific platform features works against that. I assume, DbType.Xml is rather a SQL Server thing (correct me if I'm wrong) but I guess, support for it could be easily added.

dradovic avatar May 31 '14 10:05 dradovic

Feel free to issue a PR for this.

dradovic avatar Jul 01 '15 12:07 dradovic

Will do buddy

anishpateluk avatar Jul 01 '15 13:07 anishpateluk