Expected: System.Int32, got System.Decimal

Question

Possible Duplicate:
Why does select SCOPE_IDENTITY() return a decimal instead of an integer?

I'm using following code to determine last inserted id on my column

var sql = "SELECT IDENT_CURRENT('TableName')"; 
var query = session.CreateSQLQuery(sql); 
var lastInsertedId = query.UniqueResult();

But when I'm try to use these id value

photo.Property = session.Load<Domain.Property>(lastInsertedId);

I got following error message Provided id of the wrong type. Expected: System.Int32, got System.Decimal

How can I overcome these ? Thanks

please try session.Load(System.Convert.ToInt32(lastInsertedId)); — HatSoft, Aug 07 '12 at 11:33

score 3 · Accepted Answer · answered Aug 07 '12 at 11:41

3

lastInsertedId is getting returned as decimal you will have to convert it into to Int and pass it to the session.Load method

photo.Property = session.Load<Domain.Property>(System.Convert.ToInt32(lastInsertedId));

answered Aug 07 '12 at 11:41

HatSoft

score 0 · Answer 2 · answered Aug 07 '12 at 11:39

0

You can write:

SELECT Cast(IDENT_CURRENT('Core.Clients') As Int)

answered Aug 07 '12 at 11:39

Chepene

2 Answers2