Exclude fields from insert/update statement

Exclude fields from insert/update statement

Postby OSTGerman » Fri 11 May 2012 09:53

Hello!

I have an entity mapped to a database view with some calculated fields. When I read data, everything goes smoothly. When data is inserted, i get ORA-01733: virtual column not allowed here. These columns (mapped to calculated columns in a view) have AutoGeneratedValue: true, Nullable: true, ReadOnly: true. Is there a way to avoid this problem?

I use DotConnectOracle pro 6.80 (LinqConnect 3.2.73)
OSTGerman
 
Posts: 5
Joined: Tue 13 Dec 2011 13:47

Re: Exclude fields from insert/update statement

Postby OSTGerman » Fri 11 May 2012 10:49

Sorry, my problem was that .Designer.cs wasn't updated properly after saving model in visual designer. Setting AutoGeneratedValue to true removes field from insert query. Problem solved.
OSTGerman
 
Posts: 5
Joined: Tue 13 Dec 2011 13:47


Return to LinqConnect (LINQ to SQL support)