首页 > 数据库技术 > 详细

.net core ef mysql 的使用

时间:2017-01-14 17:07:35      阅读:891      评论:0      收藏:0      [点我收藏+]

第一步,安装运行环境

PM> Install-Package Pomelo.EntityFrameworkCore.MySql

PM> Install-Package Microsoft.EntityFrameworkCore.Tools –Pre

 

Pomelo的链接已经在.NET CORE官方网站出现,是官方推荐的

 

第二步,创建DBContext

public class MyContext: DbContext
    {
        public DbSet<ts_weiba> ts_weibas { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
            => optionsBuilder
                .UseMySql(@"server=127.0.0.1;uid=root;pwd=123456;database=coresns;charset=utf8;");
    }

  

/// <summary>
    /// ts_weiba Entity Model
    /// </summary>    
    public class ts_weiba
    {
        /// <summary>
        /// 微吧ID
        /// </summary>
        [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int weiba_id { get; set; }
    
        /// <summary>
        /// 
        /// </summary>
        public int cid { get; set; }
    
        /// <summary>
        /// 
        /// </summary>
        public string weiba_name { get; set; }
    
        /// <summary>
        /// 创建者ID
        /// </summary>
        public int uid { get; set; }
    
        /// <summary>
        /// 创建时间
        /// </summary>
        public int ctime { get; set; }
    
        /// <summary>
        /// 微吧logo
        /// </summary>
        public string logo { get; set; }
    
        /// <summary>
        /// 微吧简介
        /// </summary>
        public string intro { get; set; }
    
        /// <summary>
        /// 发帖权限 0-所有人 1-仅成员
        /// </summary>
        public int who_can_post { get; set; }
    
        /// <summary>
        /// 回帖权限 0-所有人 1-仅成员
        /// </summary>
        public int who_can_reply { get; set; }
    
        /// <summary>
        /// 成员数
        /// </summary>
        public int follower_count { get; set; }
    
        /// <summary>
        /// 帖子数
        /// </summary>
        public int thread_count { get; set; }
    
        /// <summary>
        /// 超级圈主uid
        /// </summary>
        public int admin_uid { get; set; }
    
        /// <summary>
        /// 是否设为推荐(热门)0-否,1-是
        /// </summary>
        public int recommend { get; set; }
    
        /// <summary>
        /// 是否通过审核:0-未通过,1-已通过
        /// </summary>
        public int status { get; set; }
    
        /// <summary>
        /// 是否删除 默认为0
        /// </summary>
        public int is_del { get; set; }
    
        /// <summary>
        /// 微吧公告
        /// </summary>
        public string notify { get; set; }
    
        /// <summary>
        /// 
        /// </summary>
        public string avatar_big { get; set; }
    
        /// <summary>
        /// 
        /// </summary>
        public string avatar_middle { get; set; }
    
        /// <summary>
        /// 
        /// </summary>
        public int new_count { get; set; }
    
        /// <summary>
        /// 
        /// </summary>
        public DateTime new_day { get; set; }
    
        /// <summary>
        /// 申请附件信息
        /// </summary>
        public string info { get; set; }
    }

  

第三步,生成数据库

PM> Add-Migration t1

PM> Update-Database -Verbose

 

.net core ef mysql 的使用

原文:http://www.cnblogs.com/nopassword/p/6285462.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!