Page 1 of 1

Update view fails

Posted: Tue 09 Jun 2009 08:28
by GlennBA
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.

Posted: Tue 09 Jun 2009 12:38
by GlennBA
Hi

Are there any requierements to the stored procs for updating the view ?
They are currently selectable with parameters and all in Entity Developer.

Any requirements for the view ?

Is it a functionality which is not working in the trial version ?

Any work-arounds ?

Any time frame for fixes?

Posted: Wed 10 Jun 2009 10:49
by Shalex
Please check if the VKurvereg class implements INotifyPropertyChanging, INotifyPropertyChanged. Otherwise, Devart.Data.Linq.ChangeSet collection will be empty, but updates must be performed in any cases.
If it doesn't help, please send us (support*devart*com) a small test project that reproduces the issue. Please include the definitions of database objects.

Posted: Thu 11 Jun 2009 09:14
by GlennBA
Both interfaces are supported !

I have added a view and some stored procedures to your CRM example and sent SQL scripts and a sample project to Support.

Best regards
Glenn