How to add Column in existing table in asp Boilerplate?

Question

As you know Boilerplate don't give the entity classes to add columns and I want to add column in table named ( AbpUser). I tried to make a class in Migrations like below

public partial class AddRatingMig : DbMigration
{
    public override void Up()
    {
        AddColumn("dbo.AbpUsers", "UserType", c => c.String());
    }

    public override void Down()
    {
        DropColumn("dbo.AbpUsers", "UserType");
    }
}

Then in Pm console run command Update-Database . But not successful. As you know Boilerplate don't give the entity classes to edit columns. Please Help Thanks in advance

Please read [ask] and learn about what is on-topic to ask here. Your question is very broad. It is expected that you've already made an attempt at solving your problem before asking here. I would look at some tutorials online and then if you have trouble implementing it, come back here and ask a more specific question with a [mcve], — Lexi, Aug 24 '17 at 12:43
I asked a simple question. Its about a specific framework, if you know about Boilerplate framework then guide please... — Mesam Mujtaba, Aug 24 '17 at 12:46
You did not ask a question that is within the guidelines on this site. If you read through the [help], you would have been aware of that. — Lexi, Aug 24 '17 at 12:46
Then you aren't likely to get an answer. If you aren't going to take the time to write a good question, why should a volunteer take the time to write a good answer to an off-topic question? — Lexi, Aug 24 '17 at 12:49
Check now @Lexi . I am not good in English but tried to explain my problem — Mesam Mujtaba, Aug 24 '17 at 12:59
The answer to this question is to Extend the AbpUser like this public class User : AbpUser { public string SpecialTitle { get; set; } } — Vince, Aug 24 '17 at 16:55
@Vince I did all which you are telling.. But got an error on running in browser — Mesam Mujtaba, Aug 25 '17 at 05:31
Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed. — Mesam Mujtaba, Aug 25 '17 at 05:31
@Vince after enabling Migrations and updating database. I found solution. Thanks man. Please write your above answer in answer pane so i can mark it true. Thanks again — Mesam Mujtaba, Aug 25 '17 at 05:44
there is no restriction to extend the user class. you can extend it by inheriting. [Table("AbpTenants")] public class MyUser : User { } — Alper Ebicoglu, Aug 25 '17 at 06:12
please read the document. it's explained very good in docs. https://aspnetboilerplate.com/Pages/Documents/Zero/installation?searchKey=user — Alper Ebicoglu, Aug 25 '17 at 06:13

score 5 · Accepted Answer · answered Aug 25 '17 at 12:48

5

The answer to this question is to Extend the AbpUser like this

public class User : AbpUser<User> 
{ 
    public string SpecialTitle { get; set; } 
}

and add-migration UpdatedUserWithSpecialTitle then update-database

answered Aug 25 '17 at 12:48

Vince

1,279
2
20
40

I have a new question... how to do search on database table in Boilerplate? it uses async methods – Mesam Mujtaba Aug 25 '17 at 12:54
and as i mention in first question Boilerplate does not provide entity classes – Mesam Mujtaba Aug 25 '17 at 12:55
I want to search on existing tables – Mesam Mujtaba Aug 25 '17 at 12:55
You should create a new question about it and I will answer it my best, because we need to keep this post on the question – Vince Aug 25 '17 at 13:00
Please check link https://stackoverflow.com/questions/45912587/asp-net-boilerplate-how-to-update-a-record-in-existing-tables-in-database-usi – Mesam Mujtaba Aug 28 '17 at 06:47

score 0 · Answer 2 · edited Aug 06 '18 at 19:32

Here is the correct way

public partial class AddRatingMig : DbMigration
 {
    public override void Up(MigrationBuilder migrationBuilder)
  {
    migrationBuilder.AddColumn<string>(
      name: "UserType",
      table:"AbpUsers",
      nullable:true
      );
  }

    public override void Down(MigrationBuilder migrationBuilder)
      {
        migrationBuilder.DropColumn(
        name:"UserType",
        table:"dbo.AbpUsers"
        );
      }
}

Hence update Database using code as: update-database

NOTE:

Make sure that you have properly added migrations as: add-migration migration_name

Behnam Ghasemi · Answer 3 · 2020-10-05T17:18:23.697

I had the same problem in abp.io framework, adding new property, "PICUstomerId" to AbpUser Entity and migrate it to database.

Here is the comments by abp.io:

Add your own properties here. Example:

public string MyProperty { get; set; }
If you add a property and using the EF Core, remember these;

Update PasargadInsuranceDbContext.OnModelCreating to configure the mapping for your new property
Update PasargadInsuranceEfCoreEntityExtensionMappings to extend the IdentityUser entity and add your new property to the migration.
Use the Add-Migration to add a new database migration.
Run the .DbMigrator project (or use the Update-Database command) to apply schema change to the database.

and finally add-migration to your solution and then update-database

1. Add your own properties here

2. Update PasargadInsuranceDbContext.OnModelCreating

3. Update PasargadInsuranceEfCoreEntityExtensionMappings to extend theIdentityUser entity

4. And finally after update-databse, I saw my new property in database