.NET orm 操作mysql

1.如何mysql安装？

          这里我选择的 5.4版本

推荐小白安装文章

            win7安装mysql菜鸟_【超详细全过程】安装MySQL_weixin_39959794的博客-CSDN博客

可视化工具

            Navicat

      实体model

   public class cc
        {
        public string id { get; set; }
            public int sex { get; set; }
        }

 引用

using Chloe.MySql;
 

   /// <summary>
        /// 创建连接
        /// </summary>
        public static MySqlContext mysqlserver
        {
            get
            {


                MySqlContext context = new MySqlContext(new MySqlConnectionFactory("server=localhost;uid=root;pwd=root;database=apiuser"));
                return context;
            }
        }

    /// <summary>
    /// 建个 MySqlConnectionFactory 类，实现 IDbConnectionFactory 接口：
    /// </summary>
    public class MySqlConnectionFactory : IDbConnectionFactory
    {
        string _connString = null;
        public MySqlConnectionFactory(string connString)
        {
            this._connString = connString;
        }
        public IDbConnection CreateConnection()
        {
            MySqlConnection conn = new MySqlConnection(this._connString);
            return conn;
        }
    }

//关键的来了 增删改查

//添加
  cc cc = new cc();
                cc.id = DateTime.Now.ToString("yyyyMM-ff");
                cc.sex = 1;
                mysqlserver.Insert(cc);

//查询
                var user = mysqlserver.Query<cc>().ToList();
//修改
                var count=mysqlserver.Update<cc>(n => n.id == "1", n => new cc()
                {
                    sex=3
                });
//删除
                 count = mysqlserver.Delete<cc>(n => n.id == "1");

 看得懂把   用的 nacicat 可视化工具

库

表

数据