Help Questions | Solutions | Experts

Select Categories Below

.net [

]

Bluetooth [

]

browsers [

]

C# [

]

computer [

]

Errors [

]

forms [

]

HTML [

]

information tec... [

]

internet [

]

Start Your Own Q&A Site

Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.

Question

Status: Closed Points: 75 Time: 10:51 - Jan 25, 2007

theDude

HibernateException: expected affected row count: 1, actual affected row count: 0?

What does this NHibernate error message mean?
NHibernate.HibernateException: SQL insert, update or delete failed (expected affected row count: 1, actual affected row count: 0)
I'm trying to insert a new item in the database...

Categories:

sql NHibernate

Answer Discussion

Tutorials

theDude

Date:: Jan 25, 2007

Time:: 11:37

i found out what the problem was.
I was basically calling Update with a new object, instead of calling Save.
This happened because I have a generic Save method that checked if the object ID is 0, and if it is, it will Save, otherwise Update the object. But the problem was that this object didn't have an autonumeric identifier in the database, so even if it was new, it had a fixed Id, different from 0.
hmm, can't really blame anyone else than myself for this... :)

Question Answered

This question has been closed, and points have been rewarded to the following experts:

theDude:

You're welcome however to comment or give additional information or if you wish, you have the ability to write a Tutorial in the Tutorial Area.

Answer this Question

New User

Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

No tutorials have been submitted yet. Want to be the first?