Update view fails
Posted: Tue 09 Jun 2009 08:28
I have defined a view In Entity Developer and attached a stored procedure for update.
I do the following
VKurvereg q = (from k in DataContext.VKurveregs
where k.Id == 1
select k).SingleOrDefault();
if (q == null)
MessageBox.Show("Query result is null");
q.Kurvelaengde = 123456.47885M;
q.Sportype = "test";
Devart.Data.Linq.ChangeSet cs = DataContext.GetChangeSet();
if (cs.Updates.Count <= 0)
MessageBox.Show("No updates!");
DataContext.SubmitChanges();
I get "No updates!" and SubmitChanges does nothing.
I do the following
VKurvereg q = (from k in DataContext.VKurveregs
where k.Id == 1
select k).SingleOrDefault();
if (q == null)
MessageBox.Show("Query result is null");
q.Kurvelaengde = 123456.47885M;
q.Sportype = "test";
Devart.Data.Linq.ChangeSet cs = DataContext.GetChangeSet();
if (cs.Updates.Count <= 0)
MessageBox.Show("No updates!");
DataContext.SubmitChanges();
I get "No updates!" and SubmitChanges does nothing.