Why does PetaPoco return from a db.Insert a ID field of 7 as a decimal

c# .net petapoco
Jon picture Jon · Jun 7, 2011 · Viewed 8.2k times · Source

When doing a Insert the variable id is returned as an object. However in my database it is an int and in my POCO it is an int however when the method call to ExecuteScalar to return @@IDENTITY is called it returns the number 7 as an object but the debugger thinks its a decimal.

Therefore when I do int newID = (int)db.Insert(...) it throws a 

InvalidCastException

Is this a framework bug or a PetaPoco bug?

Answer

Schotime picture Schotime · Jun 10, 2011

Also remember that if you have set your class up and you insert like so.

[TableName("Users")]
[PrimaryKey("Id")]
public class User {
    public int Id {get;set;}
    public string Name {get;set;}
}

var user = new User() { Name = "My Name" };
db.Insert(user);
Assert.True(user.Id != 0);

user.Id will now change from 0 to the newly created identity value

Related questions

How to check a var for null value?

I am using PetaPoco Micro-ORM with C# 4.0. The code below retrieves a single row from the database: var result = db.SingleOrDefault<TdUsers>(getUserQuery); I would like to check whether or not the result contains any rows, and whether …

Read More
How to automatically create model from database using PetaPoco library?

I have a table in my database for which I want to create a model class with getters and setters. For most of the tasks in my project, I am using PetaPoco. I created models manually, but few tables have …

Read More
How to make an HTTP POST web request

Canonical How can I make an HTTP request and send some data using the POST method? I can do a GET request, but I have no idea of how to make a POST request.

Read More