Entity Framework 示例

1.先创建一个项目，创建完成后再webconfig.fig的<entityFramework>标签之前增加

<connectionStrings>
    <add name="ConnectionDb" connectionString="Data Source=DESKTOP-CACBDRH\SQLEXPRESS;Initial Catalog=RegistereInfo;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

2.安装Entity Framework

3.新建Users实体类

  [Key]
        public int ID { get; set; }
        public string Name { get; set; }
        public string IDCard { get; set; }
        public string Address { get; set; }
        public string Phone { get; set; }
        public string PathStr { get; set; }
        [Column("PassWord")]
        public string Pwd { get; set; }

4.在Model文件夹下建DBContext

public class ConnectionDb : DbContext
 {
        public ConnectionDb() : base("name=ConnectionDb") { }

        public DbSet<Users> users { get; set; }
 }

5.新建Common类用于存放公共方法，如DMD5加密：

        /// <summary>
        /// MD5加密
        /// </summary>
        /// <param name="strText">待加密字符串</param>
        /// <returns>加密后字符串</returns>
        public static string MD5Encrypt(string strText)
        {
            MD5 md5 = new MD5CryptoServiceProvider();
            byte[] targetData = md5.ComputeHash(Encoding.UTF8.GetBytes(strText));

            string byte2String = null;

            for (int i = 0; i < targetData.Length; i++)
            {
                byte2String += targetData[i].ToString("x2");
            }

            return byte2String.ToUpper();
        }

6.新建UserInfoController

        /// <summary>
        /// 登录（EF查询、修改）
        /// </summary>
        /// <param name="user"></param>
        /// <returns></returns>
        [HttpPost]
        public string GetUser(Users user)
        {
            var result = "";
            try
            {
                using (ConnectionDb db = new ConnectionDb())
                {
                    //var userList = (from u in db.users
                    //                where u.Name == user.Name
                    //                select u).ToList();
                    var userList = db.users.Where(s => s.Name == user.Name).FirstOrDefault();
                    if (userList == null)
                    {
                        result = "用户名密码不匹配";
                    }
                    else
                    {
                        result = "登录成功";
                        userList.IDCard = Common.MD5Encrypt(userList.IDCard);
                        db.SaveChanges();
                    }
                    return "{\"code\":\"0\",\"Msg\":\"" + result + "\"}";
                }
            }
            catch (Exception ex)
            {
                return "{\"code\":\"500\",\"Msg\":\"服务器内部错误\"}";
            }
        }



        /// <summary>
        /// 注册（EF新增）
        /// </summary>
        /// <param name="user"></param>
        /// <returns></returns>
        [HttpPost]
        public string PostUser(Users user)
        {
            var result = "";
            try
            {
                using (ConnectionDb db = new ConnectionDb())
                {
                    var userList = (from u in db.users
                                    where u.Name == user.Name && u.IDCard == user.IDCard
                                    select u).ToList();
                    if (userList.Count == 0)
                    {
                        Users us = new Users();
                        us.Name = user.Name;
                        us.IDCard = user.IDCard;
                        us.Address = "";
                        db.users.Add(us);
                        int i = db.SaveChanges();
                        if (i > 0)
                            result = "注册成功";
                        else
                            result = "注册失败";
                    }
                    else
                    {
                        result = "该用户已注册";
                    }
                    return "{\"code\":\"0\",\"Msg\":\"" + result + "\"}";
                }
            }
            catch (Exception)
            {
                return "{\"code\":\"500\",\"Msg\":\"服务器内部错误\"}";
            }
        }



        /// <summary>
        /// 删除用户（EF删除）
        /// </summary>
        /// <param name="user"></param>
        /// <returns></returns>
        [HttpPost]
        public string DelUser(Users user)
        {
            user.ID = 14;
            var result = "";
            try
            {
                using (ConnectionDb db = new ConnectionDb())
                {
                    var deluser = db.users.FirstOrDefault(s => s.ID == user.ID);
                    if (deluser != null)
                    {
                        //删除用户信息
                        db.users.Remove(deluser);
                        //执行删除操作
                        int i = db.SaveChanges();
                        if (i > 0)
                            result = "删除成功";
                        else
                            result = "删除失败";
                    }
                    else
                    {
                        result = "不存在该用户";
                    }
                    return "{\"code\":\"0\",\"Msg\":\"" + result + "\"}";
                }
            }
            catch (Exception)
            {
                return "{\"code\":\"500\",\"Msg\":\"服务器内部错误\"}";
            }
        }