Is it possible to create an automatic table with fluentmigrator?

[suatsuphi]

Hi,

We have a sample table like below. Is it possible to create the following tables with migration? Is there a command that all indexes and constraints will be automatic? Isn't it very unnecessary to define them one by one for initial?

[MigrationVersion("2024-05-15 14:00:00", "Initial")]
internal class Initial : Migration
{
       if (!Schema.Table(nameof(Post)).Exists())
       {
              Create.Table(nameof(Post)).Automatic(Post);
       }
       if (!Schema.Table(nameof(Tag)).Exists())
       {
              Create.Table(nameof(Tag)).Automatic(Tag);
       }
       if (!Schema.Table(nameof(PostTag)).Exists())
       {
              Create.Table(nameof(PostTag)).Automatic(Post);
       }
}

using System.Collections.Generic;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel.DataAnnotations;

namespace Domain
{
    public class Post
    {
        public int Id { get; set; }

        [StringLength(400)]
        [Required]
        public string Name { get; set; }
        public List<PostTag> PostTags { get; } 
        public List<Tag> Tags { get; } 
    }

    public class Tag
    {
        public int Id { get; set; }

        [StringLength(400)]
        [Required]
        public string Name { get; set; }
        public List<PostTag> PostTags { get; } 
        public List<Post> Posts { get; } 
    }

    internal class PostTagMap : IEntityTypeConfiguration<PostTag>
    {
        public void Configure(EntityTypeBuilder<PostTag> builder)
        {
            builder
                .HasOne(a => a.Tag)
                .WithMany(a => a.PostTags)
                .HasForeignKey(c => c.PostsId)
                .OnDelete(DeleteBehavior.ClientSetNull);

            builder
               .HasOne(a => a.Tag)
               .WithMany(a => a.PostTags)
               .HasForeignKey(c => c.TagsId)
               .OnDelete(DeleteBehavior.ClientSetNull);
        }
    }

    [Index(nameof(PostsId), Name = "IX_PostTag_PostsId")]
    [Index(nameof(TagsId), Name = "IX_PostTag_PostsId")]
    [Index(nameof(DisplayOrder), Name = "IX_PostTag_PostsId")]
    [Index(nameof(PostsId), nameof(TagsId), IsUnique = true, Name = "IX_PostTag_PostsId_TagsId")]
    public class PostTag
    {
        public int Id { get; set; } 
        public int DisplayOrder { get; set; }
        public int PostsId { get; set; }
        public int TagsId { get; set; }
        public Post Post { get; set; } = null!;
        public Tag Tag { get; set; } = null!;
    }
}

[jzabroski]

If I understand your request, you want something similar to EF6 Automatic Migrations, since EFCore does not support Automatic Migrations. Is that right?

[suatsuphi]

Imagine that you write an additional project to an existing project, you are not the first to run the project. so you create additional tables with migration.

[jzabroski]

Sorry, I did not understand your two sentences. I think you are looking for something like Quentin Starin's EasyMigrator, though. It is linked in our third party library contributions, but it has not been kept up to date for .NET 5+.

[suatsuphi]

thanks I meant something like that EasyMigrator, but I mean exactly this Create.Table<Poco>(); should be enough. it would be great if these definitions could be made in the class....

[jzabroski]

@suatsuphi I suspect you didn't read the full readme for EasyMigrator. See: https://github.com/qstarin/EasyMigrator?tab=readme-ov-file#fluentmigrator