Create an index on the column - .NET Core
/// <summary> /// Configures the entity framework mappings for the Modal entity. /// </summary> public class ModalConfiguration : IEntityTypeConfiguration<Modal> { /// <summary> /// Configures the entity properties and constraints for the Modal entity. /// </summary> /// <param name="builder">The entity type builder for Modal.</param> public void Configure(EntityTypeBuilder<Modal> builder) { // Create an index on the column builder.HasIndex(x => x.Column); } }