Efficiencies and Problems when updating foreign key

[richardFlow]

Hi,

When updating a foreign key in a class, instead of just being able to update the Id, i have to retrieve the entire object and then update it. this needs an unnecessary call to the database.  Is there a workaround?

I get the following error when running the following code:

"Unable to set slave column value"

internal DAL.ProductAttributeValue CreateDALObject(intattUid, int prodUid)

        {

DAL_scope.Transaction.Begin();

DAL.ProductAttributeValue newProductAttributeValue = newDAL.ProductAttributeValue();

              newProductAttributeValue.AttributeUid = attUid;    [A]

newProductAttributeValue.ProductUid = prodUid;    [B]

      

DAL_scope.Add(newProductAttributeValue);

DAL_scope.Transaction.Commit();

return newProductAttributeValue;

        }

and i need to reaplace [A] and [B] with the following instead to make it work (where RetrieveDALObjectByKey returns the openaccess generated class.:

newProductAttributeValue.Attribute = (newAttributeManager(DAL_scope)).RetrieveDALObjectByKey(attUid);

newProductAttributeValue.Product = (newProductManager(DAL_scope)).RetrieveDALObjectByKey(prodUid);

Your thoughts would be appreciated.

[Zoran]

Hello Web Belief Ltd,

This exception usually indicates inconsistency in your mapping. It could mean that the ProductAttributeValue.AttributeUid field is not mapped to the same column as the identity field of your Attribute class. Can you send us your App.config file so we can evaluate further the issue and tell you the exact cause of your problem.

All the best,
Zoran
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.