Support for XML Data Type

dradovic / MigSharp

Mig# (MigSharp) is a .NET framework for database migrations and versioning

Other

106 stars 34 forks source link

Support for XML Data Type #52

Open anishpateluk opened 10 years ago

anishpateluk commented 10 years ago

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'.

dradovic commented 10 years ago

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 commented 9 years ago

Feel free to issue a PR for this.

anishpateluk commented 9 years ago

Will do buddy