[Firebird-net-provider] EF Code First Attempted Update of read-only Column

[Muthu A. <pea...@ho...>]

I am using Provider 3.0.2.0 with EF 5.0 code First. When I call save changes
it is giving FirebirdSql.Data.Common.IscException: attempted update of
read-only column. I have trigger for id column and I don't include values
for those columns in code and there is no other computed column.  I also
tried saving a different table, but no use, when savechanges is called it is
throwing the exception.

 

Here is the exception stack details.

 

----------------------------------------------------------------------------
---------------------

 

(System.Data.Entity.Infrastructure.DbUpdateException: An error occurred
while updating the entries. See the inner exception for details. --->
System.Data.UpdateException: An error occurred while updating the entries.
See the inner exception for details. --->
FirebirdSql.Data.FirebirdClient.FbException: attempted update of read-only
column ---> FirebirdSql.Data.Common.IscException: attempted update of
read-only column

   at
FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IRespo
nse response)

   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()

   at
FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()

   at FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String
commandText)

   at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)

   at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior
behavior, Boolean returnsSet)

   at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
behavior)

   --- End of inner exception stack trace ---

   at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
behavior)

   at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavio
r behavior)

   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

   at
System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTrans
lator translator, EntityConnection connection, Dictionary`2
identifierValues, List`1 generatedValues)

   at
System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateMana
ger stateManager, IEntityAdapter adapter)

   --- End of inner exception stack trace ---

   at
System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateMana
ger stateManager, IEntityAdapter adapter)

   at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager
entityCache)

   at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)

   at System.Data.Entity.Internal.InternalContext.SaveChanges()

   --- End of inner exception stack trace ---

   at System.Data.Entity.Internal.InternalContext.SaveChanges()

   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()

   at System.Data.Entity.DbContext.SaveChanges()

   at Pearlpos.Data.Models.Entities.SaveChanges() in c:\Users\Muthu
Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos.Data\Models\Entities.cs:line 85

   at Pearlpos.Data.Repository`1.SaveChanges() in c:\Users\Muthu
Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos.Data\Repository.cs:line 93

   at Pearlpos.Data.Utils.DataInit.SetDefaultUser() in c:\Users\Muthu
Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos.Data\Utils\DataInit.cs:line 295

   at Pearlpos.Data.Utils.DataInit.DatabaseConnection() in c:\Users\Muthu
Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos.Data\Utils\DataInit.cs:line 42}
System.Exception {System.Data.Entity.Infrastructure.DbUpdateException}

 

----------------------------------------------------------------------------
---------------------

 

Thanks,

Muthu Annamalai