/Pazyn.EntityFrameworkCore.ExtendedProperties

Extended Properties for Entity Framework

Primary LanguageC#

Pazyn.EntityFrameworkCore.ExtendedProperties

Pazyn.EntityFrameworkCore.ExtendedProperties is library that simplifies usage of Sql Sever's extended properties. You can store it with the domain classes and synchronize using migrations.

Minimal working example

public class Entity
{
    public Int32 EntityId { get; set; }
    public Int32 Name { get; set; }
}

public class ExampleDbContext : DbContext
{
    public DbSet<Entity> Entities { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        base.OnConfiguring(optionsBuilder);
        optionsBuilder.UseSqlServer("Data Source=(localdb)\\mssqllocaldb;Initial Catalog=Pazyn.EntityFrameworkCore.ExtendedProperties;Integrated Security=True");
        optionsBuilder.AddExtendedProperties();
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        var entityTypeBuilder = modelBuilder.Entity<Entity>();
        var propertyBuilder = entityTypeBuilder.Property(x => x.Name);

        entityTypeBuilder.HasExtendedProperty("Key1", nameof(EntityTypeBuilder));
        propertyBuilder.HasExtendedProperty("Key2", nameof(PropertyBuilder));
    }
}