.net Core使用EF简单版:
一、Nuget导入EF库
二、写实体Model (个人喜欢DBFirst,但是Core里不能直接导入库,所以手写吧)
三、写 DBContxt
四、验证是否成功
一:SQLServer/MySQL导入的库
二、实体类
1 using System; 2 using System.Collections.Generic; 3 using System.ComponentModel.DataAnnotations.Schema; 4 5 [Table("t_errorlog")] 6 public partial class t_errorlog 7 { 8 public System.Guid Id { get; set; } 9 public Nullable<System.Guid> UserId { get; set; } 10 public string Location { get; set; } 11 public string Content { get; set; } 12 public System.DateTime CreateTime { get; set; } 13 }
三、写 DBContxt
public class DataModelContext:DbContext { public DataModelContext() { } public DataModelContext(DbContextOptions<DataModelContext> options) : base(options) { } private IConfiguration _IConfiguration = null; public DataModelContext(IConfiguration configuration) { this._IConfiguration = configuration; } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<t_errorlog>().ToTable("t_errorlog").HasKey("Id"); } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { //SQL Server optionsBuilder.UseSqlServer(Configuration.GetConnectionString("DbConnection")); //MySQL // optionsBuilder.UseMySql(Configuration.GetConnectionString("DbConnection") ); }
public virtual DbSet<t_errorlog> t_errorlog { get; set; } }
四、验证是否成功
using (Model.DataModelContext _context = new Model.DataModelContext()) { ViewBag.logCount = _context.t_errorlog.Count(); }