public static void EditarPersona(Persona p1) { using (PruEntities1 db = new PruEntities1()) { db.Entry(p1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static void AgregarPersona(Persona p1) { using (PruEntities1 db = new PruEntities1()) { db.Persona.Add(p1); db.SaveChanges(); } }
public static void EliminarPersona(int id) { using (PruEntities1 db = new PruEntities1()) { db.Persona.Remove(db.Persona.Where(i => i.Id == id).First()); db.SaveChanges(); } }
public static List <Persona> ObtenerPersonas() { List <Persona> perso = new List <Persona>(); using (PruEntities1 bd = new PruEntities1()) { perso = (from n in bd.Persona select n).ToList(); } return(perso); }
public static Persona ObtenerPorId(int id) { Persona p1 = new Persona(); using (PruEntities1 db = new PruEntities1()) { List <Persona> per = db.Persona.ToList(); foreach (var p in per) { if (p.Id == id) { p1 = p; } } //return (from n in db.Persona // where n.Id == id // select n).First(); //return db.Persona.Where(item => item.Id == id).First(); } return(p1); }