public void update(PjatkDb con)
{
var result = con.Students.First();
result.age = 99;
con.SaveChanges();
}
public void delete(PjatkDb con)
{
var oldStudent = new Student()
{
Id = 1
};
con.Students.Attach(oldStudent);
con.Students.Remove(oldStudent);
}
public void insert(PjatkDb con)
{
var newStudent = new Student()
{
age = 22, name = "Kowalski"
};
con.Students.Add(newStudent);
con.SaveChanges();
}
public MainWindow()
{
InitializeComponent();
//Niestety baza danych na PJATK dziala niesamowicie wolno, dlatego musialem skorzystac z bazy podstawionej lokalnie
var con = new PjatkDb();
select(con);
insert(con);
delete(con);
update(con);
}
public DB()
{
pjatkDb = new PjatkDb();
}
public void select(PjatkDb con)
{
var result = con.Students.ToList();
DataGrid.ItemsSource = result.ToList();
}
