How can we create non-clustered indexes for column using abp suite #766

4 Answer(s)

• 

  1

  liangshiwei created 5 years ago

  Fullstack Developer

  Hi,

  Open your <YourProjectName>DbContextModelCreatingExtensions.cs class and use HasIndex to configure your entity.

  Example:

  builder.Entity<MyTest>(b =>
  {
      b.ToTable(qaConsts.DbTablePrefix + "MyTests", qaConsts.DbSchema);
      b.ConfigureByConvention();
      b.Property(x => x.Name).HasColumnName(nameof(MyTest.Name));
  
      // add this
      // specify name as an index
      b.HasIndex(x => x.Name);
  });
  

  Use the add-migration <migration file name> command to add migration file and run the DbMigrator project apply migration.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  safi created 5 years ago

  Hi

  I added above lines in specified file but If I am trying to add migration getting dept.json file not exist error.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 5 years ago

  Fullstack Developer

  Can you share some screenshots？

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  safi created 5 years ago

  It's done now...Thanks @liangshiwei

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel