I have a question about creating a new table in ASP.NET Core MVC application. I've created it with "Individual User Accounts" so I have Identity tables in DB.
How can I create my own tables in this DB? Should I create a new DB Context?
For example: I want to create a tables for students and questions(and their answers).
Since you already said you used the Individual User Accounts Identity template, you can just add your custom models on it, something like:
public class ApplicationDbContext : IdentityDbContext<ApplicationUser, ApplicationRole, Guid>
{
public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
: base(options)
{
}
protected override void OnModelCreating(ModelBuilder builder)
{
base.OnModelCreating(builder);
//....
}
public DbSet<Student> Students{ get; set; }
public DbSet<Question> Questions { get; set; }
public DbSet<Answer> Answers { get; set; }
//....
}
To add/run migrations after the new changes -- From the Tools Menu locate Package Console Manager under Nuget Console Manager. Select the project with your ApplicationDbContext and run the commands as shown in the screenshot.
Create Your Models:
suppose you have the following model:
public class Post{
public int Id {get; set;}
public string Name {get; set;}
}
in the root directory, create a folder called Persistence (or you can call it whatever you want)
Inside Persistence folder add a class like this
public class MyDbContext : DbContext {
public DbSet<Post> Posts {get; set;}
public MyDbContext((DbContextOptions<MyDbContext> options)
: base (options)
{
}
}
Now in the Startup.cs, add this line to the ConfigureServices function:
services.AddDbContext<MyDbContext>(options => options.UseSqlServer("connStr"));
Now the Time to create your first migration, by using dotnet cli
dotnet ef migrations add AddPostsTable --context MyDbContext
Find More At: docs here
