CRUD

// READ
var personer = from p in db.Person
select p;
where p.Fornamn == "Kalle"
select p;


// CREATE
using (PersonDatabasEntities dataConnection = new PersonDatabasEntities())
{
 //Create new object of the class Person (= one row in database)
 var newPerson = new Person();
 //Set properties
 newPerson = "Mimmi";
 newPerson = "Mouse";
 //Save new object to databae
 dataConnection.Personer.Add(newPerson);
 dataConnection.SaveChanges();
}

// UPDATE
using (PersonDatabasEntities dataConnection = new PersonDatabasEntities())
{
 //Select person having Id = 2
 var selectedPerson = (from p in dataConnection.Personer
 where p.Id == 2
 select p).FirstOrDefault();
 //Update data for person
 if (selectedPerson != null)
 {
 selectedPerson.Fornamn = "Arne";
 selectedPerson.Efternamn = "Anka";
 //Save changed person, ie update database
 dataConnection.SaveChanges();
 }
}

// DELETE
using (PersonDatabasEntities dataConnection = new PersonDatabasEntities())
{
 //Select person having Id = 2
 var selectedPerson = (from p in dataConnection.Personer
 where p.Id == 2
 select p).FirstOrDefault();
 //Delete data for person
 if (selectedPerson != null)
 {
 dataConnection.Personer.Remove(selectedPerson);
 //Save, ie delete in database
 dataConnection.SaveChanges();
 }
}