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(); } }