Hi,

 im using a DataGridView to display a View which uses fields from 3 different tables. When i try to update an Entity which corresponds to a single row from one of these 3 tables im getting an esConcurrencyException:

 EntitySpaces.Interfaces.esConcurrencyException was caught
  Message="Error in SqlClientProvider.esSaveDataTable"
  Source="EntitySpaces.Core"
  StackTrace:
       at EntitySpaces.Core.esEntity.SaveToProvider(esSqlAccessType sqlAccessType)
       at EntitySpaces.Core.esEntity.Save(esSqlAccessType sqlAccessType)
       at EntitySpaces.Core.esEntity.Save()

 The InnerException reads "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records."
Stacktrace:
   at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
   at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
   at EntitySpaces.SqlClientProvider.DataProvider.SaveStoredProc(esDataRequest request)
   at EntitySpaces.SqlClientProvider.DataProvider.EntitySpaces.Interfaces.IDataProvider.esSaveDataTable(esDataRequest request)


 
Im not trying to edit in the GridView, im loading the Entity using a field from the View, updating one field and saving it. I don´t use any type of concurrency control.

 
Any Ideas?

 
Thanks in advance,

Joris

 

"im loading the Entity using a field from the View, updating one field and saving it."

Could you post the code for this?

While trying to put the code together i think i may have found the error. My pk consists of a string(lets say partnumber) and an integer-reference to another table (this table is for groups, so every partnumber can exist one time in every group).

Im trying to update the reference to the group-table and then saving it. Should this be possible?

I´ll make some tests and make a simple code-example if it doesn´t work. 

I don´t use timestamps btw. 

You cannot update primary key fields.

Connectors oldOne = new Connectors();
Connectors newOne = new Connectors();

oldOne.LoadByPrimaryKey("#04 003.321.011", 2);
newOne.AddNew();

newOne.PartNumber = oldOne.PartNumber;
newOne.GrouRef = 14;
// copy other fields

oldOne.MarkAsDeleted();

using(esTransactionScope scope = new esTransactionScope())
{
    oldOne.Save();
    newOne.Save();

    scope.Complete();
}

My above code example does not use views. "Connectors" is a table. My first posts here are kinda misleading now.

Im trying to update a field which is part of the primary key. Thats not possible and i see why. I do have an identity column, too. That column is used for foreign keys in other tables, perhaps i should make that identity column the primary key. This would force me to validate my "old primary key" though...

Thanks and my apologizes for bringing that up, should have known better :)

I would have to update some tables that are referencing that row if i keep that primary key. On the other hand i would not have validation when using my identity column...

One death i have to take.

Now you have my curiosity piqued

You have an identity column, that is not the PK, and is part of a FK. I did not know that was even possible. Don't you run into a chicken and egg situation? You must save the parent before the child to avoid FK violations, but you must save the child before the parent in order to generate the identity column value that you need for the parent's PK.

You missunderstood me i think, perhaps due to my bad english :)

Lets say i have 3 fields in my "Connectors" table:

ID - identity colum, autoincrement

PartNumber - string, part1 of my primary key

GroupRef - int, part2 of my primary key, and foreign key relating to my group table

Other tables that are referencing this table do that with a foreign key that maps to "ID".

In this case, i copy all fields to my new "Connector" except the Zero-To-Many fields. I save my new Connector, got a new "ID" and update every object that was referencing my old Connector.

Works well by the way, but i fear any changes (new fields etc.) which could be forgotten.

Will there be Clone()-Function? :)