EntityFramework Core 6.0 MySql WebApi
Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.Design
Pomelo.EntityFrameworkCore.MySql
Microsoft.EntityFrameworkCore.Tools
------------------------------------------------------------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Model
{
public class Course
{
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public int CourseID { get; set; }
public string Title { get; set; }
public int Credits { get; set; }
public ICollection<Enrollment> Enrollments { get; set; }
}
}
---------------------------------------------------------------------------------------------------------------------------------------
using Microsoft.EntityFrameworkCore;
namespace Model
{
public class SchoolContext : DbContext
{
public SchoolContext(DbContextOptions<SchoolContext> options) : base(options)
{
}
public DbSet<Student> Students { get; set; }
public DbSet<Enrollment> Enrollments { get; set; }
public DbSet<Course> Courses { get; set; }
//protected override void OnModelCreating(ModelBuilder modelBuilder)
//{
// //modelBuilder.Entity<Course>().ToTable("Course");
// //modelBuilder.Entity<Enrollment>().ToTable("Enrollment");
// //modelBuilder.Entity<Student>().ToTable("Student");
//}
}
}
命令
Add-Migration
update-database