Exclude fields from insert/update statement

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
OSTGerman
Posts: 5
Joined: Tue 13 Dec 2011 13:47

Exclude fields from insert/update statement

Post by 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)
Top
OSTGerman
Posts: 5
Joined: Tue 13 Dec 2011 13:47

Re: Exclude fields from insert/update statement

Post by 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.
Top
Post Reply

Return to “LinqConnect (LINQ to SQL support)”