C# efcore 控制台实例

public class DefaultDbContext : DbContext
{
public DefaultDbContext()
{
}
public DbSet<User> Users { set; get; }
public DbSet<UserDetail> UserDetails { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
string sqlConnection = "server=127.0.0.1;port=3306;user=root;password=123456;database=efcoredemo";
optionsBuilder.UseMySql(sqlConnection);
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.ApplyConfiguration<User>(new UserConfiguration());
modelBuilder.ApplyConfiguration<UserDetail>(new UserDetailConfiguration());
base.OnModelCreating(modelBuilder);
}
}
public class UserConfiguration : IEntityTypeConfiguration<User>
{
public UserConfiguration()
{
}
public void Configure(EntityTypeBuilder<User> builder)
{
builder.ToTable("user");
builder.HasIndex(q => q.IdCard).IsUnique();
builder.HasOne(q => q.UserDetail).WithOne(q=>q.User).HasForeignKey<User>(q => q.userDetailId);
}
}
public class UserDetailConfiguration : IEntityTypeConfiguration<UserDetail>
{
public UserDetailConfiguration()
{
}
public void Configure(EntityTypeBuilder<UserDetail> builder)
{
builder.ToTable("userdetail");
builder.Property(q => q.Work).HasMaxLength(500);
}
}
[Table("user")]
public class User
{
[Key]
public int Id { set; get; }
[Required]
public string IdCard { get; set; }
[Column("sex")]
public bool Sex { get; set; }
[Column("name")]
public string Name { set; get; }
[Column("createTime")]
public DateTime CreateTime { set; get; } = DateTime.Now;
[Column("modifyTime")]
public DateTime ModifyTime { set; get; } = DateTime.Now;
[Column("userDetailId")]
public int userDetailId { get; set; }
public UserDetail UserDetail { get; set; }
}
[Table("userdetail")]
public class UserDetail
{
[Key]
public int Id { get; set; }
[Column("email")]
[StringLength(50)]
public string Email { get; set; }
[Column("phone")]
[StringLength(20)]
public string Phone { get; set; }
[Column("note")]
[StringLength(200)]
public string Note { get; set; }
[Column("lastLoginTime")]
public DateTime LastLoginTime { get; set; }
[Column("work")]
public string Work { get; set; }
public User User { get; set; }
}
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
using (DefaultDbContext db = new DefaultDbContext())
{
//db.Database.MigrateAsync();
//db.Database.EnsureCreated();
var list = db.Database.GetPendingMigrations();
if (list.Count() > 0)
{
db.Database.MigrateAsync();
}
//var user = new User { Name = "张三", Sex = false, IdCard = "513701199109121331" };
//db.Users.Add(user);
//db.SaveChanges();
//System.Console.Write(db.Users.ToList());
Console.ReadKey();
}
}
}