Esempio n. 1
0
        public IEnumerable <Person> GetPerson()
        {
            List <Person>     li = new List <Person>();
            SwabhavDbContext1 db = new SwabhavDbContext1();

            li = db.persons.ToList();
            return(li);
        }
Esempio n. 2
0
        public void deletePerson(int id)
        {
            SwabhavDbContext1 db = new SwabhavDbContext1();
            var li = db.persons.SingleOrDefault(x => x.id == 7);

            db.persons.Remove(li);
            db.SaveChanges();
        }
Esempio n. 3
0
        public void insertPerson(Person p1)
        {
            var p = new Person {
                id = 2, name = "Sharon", address = "Mumbai"
            };
            SwabhavDbContext1 db = new SwabhavDbContext1();

            db.persons.Add(p1);
            db.SaveChanges();
        }
Esempio n. 4
0
        public void updateperson(Person p1)
        {
            SwabhavDbContext1 db = new SwabhavDbContext1();
            var c = (from per in db.persons
                     where per.id == p1.id
                     select per).First();

            c.name    = p1.name;
            c.address = p1.address;
            db.SaveChanges();
        }