So i have set up a migration which seems to work fine, the only issues is that my datetimeoffset becomes a timespan in the database.

And i cannot seem to figure out why, any help would be usefull.

Here is my complete code.

My Schema

public class ArticleLikeSchema
    {
        [PrimaryKeyColumn(AutoIncrement = true, IdentitySeed = 1)]
        [Column("Id")]
        public int Id { get; set; }

        [Column("Liked")]
        public bool Liked { get; set; }

        [Column("UmbracoPageId")]
        public int UmbracoPageId { get; set; }

        [Column("UserID")]
        public string UserID { get; set; }

        [Column("Created")]
        public DateTimeOffset Created { get; set; }
    }

My Migration

public class AddArticleLikesTable : MigrationBase
    {
        private readonly ILogger logger;

        public AddArticleLikesTable(IMigrationContext context, ILogger logger) : base(context)
        {
            this.logger = logger;
        }
        public override void Migrate()
        {
            logger.Debug<AddArticleLikesTable>("Running migration {MigrationStep}", "AddArticleCommentsTable");

            // Lots of methods available in the MigrationBase class - discover with this.
            if (TableExists("ArticleLikes") == false)
            {
                Create.Table<ArticleLikeSchema>().Do();
            }
            else
            {
                logger.Debug<AddArticleLikesTable>("The database table {DbTable} already exists, skipping", "ArticleComments");
            }
        }
    }

And my Component

public class ArticleLikeMigrationComponent : IComponent
    {
        private readonly ILogger logger;
        private readonly IScopeProvider scopeProvider;
        private readonly IMigrationBuilder migrationBuilder;
        private readonly IKeyValueService keyValueService;

        public ArticleLikeMigrationComponent(ILogger logger, IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService)
        {
            this.logger = logger;
            this.scopeProvider = scopeProvider;
            this.migrationBuilder = migrationBuilder;
            this.keyValueService = keyValueService;
        }

        public void Initialize()
        {
            // Create a migration plan for a specific project/feature
            // We can then track that latest migration state/step for this project/feature
            var likesMigrationPlan = new MigrationPlan("ArticleLikes");

            // This is the steps we need to take
            // Each step in the migration adds a unique value

            likesMigrationPlan.From(string.Empty)
                .To<AddArticleLikesTable>("Article-Like-migration");

            // Go and upgrade our site (Will check if it needs to do the work or not)
            // Based on the current/latest step

            var upgrader2 = new Upgrader(likesMigrationPlan);
            upgrader2.Execute(scopeProvider, migrationBuilder, keyValueService, logger);
        }

        public void Terminate()
        {
        }
    }