Renaming ASP.NET SQL tables

Question

Im working with an ASP.NET boilerplate and would like to rename the sql tables it uses

I believe the relevant code is

public AlbumViewerContext(DbContextOptions options) : base(options)
    {         
    }

    public DbSet<Album> Albums { get; set; }
    public DbSet<Artist> Artists { get; set; }
    public DbSet<Track> Tracks { get; set; }
    public DbSet<User> Users { get; set;  }

It also includes models for Albums, Artists, Tracks and Users

How would i go about changing the SQL table names?

H_H · Accepted Answer · 2019-08-01 13:38:06Z

1

Add Table attribute on your Model. like as

[Table("Album")]
public class Album
{
 public string Title { get; set; }
}

answered Aug 1, 2019 at 13:38

H_H

1,6304 gold badges19 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ChrisM Over a year ago

Id like the Album table renamed Report so how does that affect the code?

H_H Over a year ago

If you change your model name then you have to change the code as well. otherwise, there will be no issue.

ChrisM Over a year ago

So all i have to do is add your code and change table name?

Nasr · Accepted Answer · 2019-08-01 13:33:19Z

0

.Net Core solution:

protected override void Up(MigrationBuilder migrationBuilder)
{
    migrationBuilder.RenameTable(name: "OldTableName", schema: "dbo", newName: "NewTableName", newSchema: "dbo");
}

protected override void Down(MigrationBuilder migrationBuilder)
{
    migrationBuilder.RenameTable(name: "NewTableName", schema: "dbo", newName: "OldTableName", newSchema: "dbo");
}

answered Aug 1, 2019 at 13:33

Nasr

651 silver badge12 bronze badges

Collectives™ on Stack Overflow

Renaming ASP.NET SQL tables

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related