public void Modify(string id)
{
using (var ctx = new PermissionDBEntities())
{
users myusers = ctx.users.FirstOrDefault(u => u.userid == id);
myusers.username = "******";
ctx.ApplyCurrentValues("users", myusers);
int intAffected = ctx.SaveChanges();
ctx.AcceptAllChanges();
}
}
public string print()
{
StringBuilder sb = new StringBuilder();
//PermissionDBEntities is entity factory ,object-myusers can be created by PermissionDBEntities with dynmaic
using (var ctx = new PermissionDBEntities())
{
ObjectQuery<users> myuser = ctx.users;
foreach (users u in myuser) {
sb.AppendLine("id:" + u.userid + "\tname:" + u.name + "\tusername:" + u.username);
}
}
return sb.ToString();
}
public void Insert()
{
//create an instance belong to users
var myusers = new users() {
userid=Guid.NewGuid().ToString(),
username="******",
passwordword="123",
name="张伟2",
sex="男" };
//PermissionDBEntities is entity factory ,object-myusers can be created by PermissionDBEntities with dynmaic
using (var ctx = new PermissionDBEntities())
{
ctx.users.AddObject(myusers);
ctx.SaveChanges();
}
}
