"Row not found: GenericOID@5 Cat Id=3
UPDATE [Animals] SET [MiceEaten]=? WHERE [Id] = ? AND [MiceEaten]=?"
(see also attached screenshot).
To reproduce the problem one may follow these steps:
- Create a new EntityDiagrams file
- Using the "Model First" approach, define a table called "Animals" with the columns: Id, Age, MiceEaten (all int NOT NULL)
- Create the base model called "Animal" and a derived model called "Cat". Map the "MiceEaten" column to the "Cat" model. "Id" and "Age" must be mapped to the "Animal" model class.
- Create the database and generate the tables. Create a few records, all of which "MiceEaten" will be NULL (although we defined "MiceEaten" to be non-nullable, the column must be generated as nullable because other derived classes, such as Dog, do not have a "MiceEaten" property, thus records of type "Dog" will have its 'MiceEaten" column set to NULL.
- Write a simple Console program that loads one or more Cats, update the "MiceEaten" property with some value, and call SaveChanges.
When you run the program you will receive an OptimisticVerificationException.
To avoid the exception, you need to set the "MiceEaten" column to an integer value that is not NULL, e.g. 0 for all Cat records.
I don't think the error is supposed to happen, because during development it may very well happen more than once that I need to add a property to some derived class, updating the database with a migration script, which will leave the newly generated column with NULL values (unless of course I modify the migration update script and use 0 as the default value to avoid the OptimisticVerificationException).
A sample project demonstrating the problem can be downloaded from here (including a SQL Compact database with preconfigured data).
Detected another smaller issue: There seems to be a bug that causes mapped properties to be NULLABLE, even though the Table is defined with NOT NULL columns. I have to manually set "Nullable" to false for these properties (I also need to do so for the Id property, otherwise OA generates an error messagebox when I want to update the database, which prevents me from doing so).
Regards,
Skywalker
7 Answers, 1 is accepted
We verified the scenario you reported and you are right, this is definitely a bug on our side. We will make sure it is fixed by the next internal build.
Best wishes,Zoran
the Telerik team
Rank 1
The problem regarding this scenario is a bit more complex than initially thought. The issue comes from the fact that there is a null value in the database for the MiceEaten column, however the MiceEaten property is of type int which in .NET can't hold the value of null. That is why, when the object is fetched from the database, the value of the MiceEaten property is initialized with 0(default for int) and when you update it to 15 for example, OpenAccess sees that the value of the property has changed from 0 to 15 and not from NULL to 15 as is the case in the database.
There is an easy solution to this problem though and that is to edit the MiceEaten property in the Visual Designer by setting its IsNullable property=true. That will make the designer to generate int? as the type of the property and will allow it to hold NULL which is the actual value available in the database. With this setup, the exception described in this post will not be present.
Zoran
the Telerik team
Rank 2
Hello! problem has not been solved (for now I have the latest version) should quickly fix this thing!
Row not found: GenericOID@f14e99db VirbeeSessionState ID=184a8431-5ba8-4d02-a99a-231f73c3fefa
UPDATE [VirbeeSessionState] SET [LockDate]=?, [LockID]=?, [Locked]=? WHERE [ID] = ? AND [LockID]=? AND [Locked]=?
create table VirbeeSessionState
(
ID UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY NOT NULL,
SessionID nvarchar(40),
Created datetime, --Время создание сессии.
Expires datetime, --Время, когда истекает сессия.
LockDate datetime, --Момент когда была заблокирована сессия.
LockID int , --Номер блокировки сессии.
Locked bit, -- Есть ли в данным момент блокировка.
ItemContent varbinary(max), --Содержимое сессии в сериализованном виде.
UserID UNIQUEIDENTIFIER, -- пользователь
)
I am not sure that the problem you have faced is the same as the one discussed in this thread, even though the error messages might be alike. Can you tell us more about your scenario, how does your model look like and what are you trying to accomplish when you get the error? Do you have any inheritance at all in your model as that was part of the problem which was discussed so far?
Greetings,Zoran
the Telerik team
Rank 2
I have a problem with updating data in a table, in which the key field - UNIQUEIDENTIFIER. database - SQL Azure.
when trying to update an exception occurs that says that OpenAccess can not find an existing entry in the table to refresh
sql:
create table VirbeeSessionState
(
ID UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY NOT NULL,
SessionID nvarchar(40),
Created datetime, --Время создание сессии.
Expires datetime, --Время, когда истекает сессия.
LockDate datetime, --Момент когда была заблокирована сессия.
LockID int , --Номер блокировки сессии.
Locked bit, -- Есть ли в данным момент блокировка.
ItemContent varbinary(max), --Содержимое сессии в сериализованном виде.
UserID UNIQUEIDENTIFIER, -- пользователь
)
The problem is really not visible with the information we have from you so far. Can we have a sample console application showing the issue or at least your .rlinq file together with some sample code that you use in order to update your entity. We need to know which properties are you trying to update and what are the value available in the database for the updated object, in order to re-create the scenario locally and eventually reproduce the exception.
Greetings,Zoran
the Telerik team