Dapper.Contrib Insert Fails identity column

Created on 1 Jun 2016 · 5Comments · Source: StackExchange/Dapper

Cannot insert the value NULL into column 'Id', table 'Infusion.dbo.StockReference'; column does not allow nulls. INSERT fails.The statement has been terminated.

check the below images

The id column is an identity column but i keep getting the above error, i tried both ways assigning a value for Id and not assigning a value for the Id but still it doesn't work any thoughts? or am i missing something.

Source

ishamfazal

Most helpful comment

For posterity, the issue (for me anyway) was that I had specified [Key], instead of [ExplicitKey]. I had a one-to-one relationship table.

Thanks to joncloud for pointing me in the right direction.

JohnnyFun on 9 Oct 2018

👍6 🎉2 🚀1

All 5 comments

@mgravell

ishamfazal on 5 Jun 2016

@ishamfazal how is StockReference defined exactly in the database? Does StockReference.Id have an Identity Specification?

joncloud on 11 Jun 2016

🚀2 👍2

@joncloud Thanks for your reply. i fixed the error

ishamfazal on 22 Jun 2016

For posterity, the issue (for me anyway) was that I had specified [Key], instead of [ExplicitKey]. I had a one-to-one relationship table.

Thanks to joncloud for pointing me in the right direction.

JohnnyFun on 9 Oct 2018

👍6 🎉2 🚀1

Also for posterity, I had the same message when I had decorated my poco class id property with System.ComponentModel.DataAnnotations.KeyAttribute instead of Dapper.Contrib.Extensions.KeyAttribute. if you don't fully qualify the attribute this is very easy to miss.