asp.net EF的简单使用

来源：互联网发布：淘宝账号注册自动编辑：程序博客网时间：2024/06/02 15:41
using System;using System.Collections.Generic;using System.Linq;using System.Web;namespace EFdemo{    public class Demo    {      static  JNJewelryEntities je = new JNJewelryEntities();        //新增        public static void Add()        {            UserAdmin user = new UserAdmin() { Id = "3", UserName = "demo", PassWord = "123", CreatTime = DateTime.Now.ToString() };            //新增到数据库            je.UserAdmins.Add(user);            je.SaveChanges();            Console.WriteLine("保存成功");        }        //修改       public static string   Edit()        {            var usr = je.UserAdmins.Where(u => u.UserName == "测试").FirstOrDefault();            usr.UserName = "demo";            je.SaveChanges();           return "修改成功";        }        //查询        public static List<UserAdmin> Serch(string name)        {            List<UserAdmin> list = je.UserAdmins.Where(u => u.UserName == name).ToList();            return list;        }        //删除        public static string Delete()        {            UserAdmin u = new UserAdmin() { Id = "3" };            je.UserAdmins.Attach(u);            je.UserAdmins.Remove(u);            je.SaveChanges();            return "删除成功";        }    }}
0 0