Re: throw exception when insert data with entityframeworkcore

[George Wu]

public class MyContext : DbContext
{
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseMySQL("Server=localhost;Port=3306;Database=study;Uid=root;Pwd=so@123456;SslMode=None");
}

public virtual DbSet<SuperForm> SuperForm { get; set; }

public virtual DbSet<Employee> Employee { get; set; }
}

And this is how I insert data:
using (var context = new MyContext())
{
var data = new Employee
{
Id = Guid.NewGuid(),
Name = "George",
Age = 30,
Department = "IT"
};

context.Employee.Add(data);
Console.WriteLine(context.SaveChanges());
}

I've also tried to use attribute "Table" to specify table name for my entity, but not work.

Query data is fine with this code:
using (var context = new MyContext())
{
var data = context.Employee.ToList();
foreach (var employee in data)
{
Console.WriteLine(employee.Department);
}
}