static void Main(string[] args)
{
//创建修改的对象
Users change = new Users()
{
UNum = 10000,
UName = "admin",
UPass = "******"
};
using (EFDemoEntities db = new EFDemoEntities())
{
//将对象加入EF容器
DbEntityEntry entity = db.Entry <Users>(change);
//设置对象状态
entity.State = System.Data.EntityState.Unchanged;
//Modified状态 设置被修改的列
entity.Property("UNum").IsModified = false;
entity.Property("UName").IsModified = true;
entity.Property("UPass").IsModified = true;
//保存修改
db.SaveChanges();
Console.WriteLine("数据修改成功！");
}
}
static void Main(string[] args)
{
using (EFDemoEntities db = new EFDemoEntities())
{
//创建需要删除的对象
Users del = new Users()
{
UNum = 10001
};
//附加到EF中
db.Users.Attach(del);
//标记为删除
db.Users.Remove(del);
//提交修改
db.SaveChanges();
Console.WriteLine("数据删除成功！");
}
}
static void Main(string[] args)
{
using (EFDemoEntities db = new EFDemoEntities())
{
//循环添加50个账户
for (int i = 0; i < 50; i++)
{
Users u = new Users()
{
UName = "Test" + i,
UPass = "******" + i,
};
db.Users.Add(u);
}
//保存更改
//批处理 多次添加 一次实现
db.SaveChanges();
Console.WriteLine("数据添加成功！");
}
}
