Potential fix for nvarchar/ntext Umbraco bug for Teacommerce

FixNvarcharContentInstallTask.cs

public class FixNvarcharContentInstallTask : AUmbracoDbInstallTask
    {
        public override void Install()
        {
            // Get all property types using the datatype
            var datatype = ApplicationContext.Current.Services.DataTypeService.GetDataTypeDefinitionByPropertyEditorAlias(
                "TeaCommerce.VariantEditor").FirstOrDefault();
            var allContentTypes = ApplicationContext.Current.Services.ContentTypeService.GetAllContentTypes();
            var hasVariantPicker = allContentTypes.Where(ct => ct.PropertyTypes.Any(prop => prop.DataTypeDefinitionId == datatype.Id));
            var propIds = hasVariantPicker.SelectMany(ct => ct.PropertyTypes)
                                          .Where(pt => pt.DataTypeDefinitionId == datatype.Id)
                                          .Select(pt => pt.Id);
            using (var db = ApplicationContext.Current.DatabaseContext.Database)
            {
                using (var ctx = db.GetTransaction())
                {
                    var query = "UPDATE cmsPropertyData SET dataNtext = dataNvarchar, dataNvarchar = NULL WHERE propertytypeid IN (@0)";
                    var queryParam = string.Join(",", propIds);
                    db.Execute(new Sql(query, queryParam));
                    ctx.Complete();
                }
            }
        }

        public override void Uninstall()
        {
            // Do nothing
        }
    }