Update view fails

GlennBA · Post by **GlennBA** » 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.

GlennBA · Post by **GlennBA** » Tue 09 Jun 2009 12:38

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?

Shalex · Post by **Shalex** » Wed 10 Jun 2009 10:49

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.

GlennBA · Post by **GlennBA** » Thu 11 Jun 2009 09:14

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