Page 1 of 1

Exclude fields from insert/update statement

Posted: Fri 11 May 2012 09:53
by OSTGerman
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)

Re: Exclude fields from insert/update statement

Posted: Fri 11 May 2012 10:49
by OSTGerman
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.