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 "删除成功";
}
}
}
asp.net EF的简单使用
最新推荐文章于 2024-04-21 20:13:43 发布