Exception during SaveEntity with LLBLGen Pro

最新推荐文章于 2023-11-02 08:47:19 发布

weixin_34302798

最新推荐文章于 2023-11-02 08:47:19 发布

阅读量111

点赞数

本文介绍了一个使用LLGLGenPro更新实体时遇到的异常情况：由于未正确设置实体的IsNew属性导致尝试插入重复键而引发的错误。通过调整IsNew属性的值，解决了这一问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I wanted to update an entity with LLGLGen Pro by executing the adapter.SaveEntity() method and got an exception.

Error

An exception was caught during the execution of an action query: Cannot insert duplicate key row in object ‘dbo.Customer’ with unique index ‘UniqueApi’.
The statement has been terminated.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

Cause

This was caused by an unique constraint on a column ApiKey, but I was updating an existing “Customer” entity and the value for the “ApiKey”, was unique, but I forgot to set the IsNew property on the “Customer” entity to false. So LLGLGen wanted to insert a new record instead of updating the existing record.

Solution

By setting the “IsNew” property on the “Customer” entity to false, the exception was resolved.

关注博主即可阅读全文