Update view fails

Update view fails

Postby 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
 
Posts: 21
Joined: Tue 02 Jun 2009 12:58

Postby 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?
GlennBA
 
Posts: 21
Joined: Tue 02 Jun 2009 12:58

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby 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
GlennBA
 
Posts: 21
Joined: Tue 02 Jun 2009 12:58


Return to dotConnect for Oracle