Update view fails

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
GlennBA
Posts: 21
Joined: Tue 02 Jun 2009 12:58

Update view fails

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

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
Devart Team
Posts: 8036
Joined: Thu 14 Aug 2008 12:44

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

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

Post Reply