How can I force a table column type using Petapoco?

Question

I desire force a datetime mysql column type, because petapoco is creating a timestamp column.

[TableName("test"), PrimaryKey("id")]
public class Test
{
        [Column("id")]
        public long id { get; set; }

        [Column("datetime")]
        public DateTime datetime { get; set; }
}

Column decorator has a second parameter "Named Parameters". How can I use it?

score 1 · Answer 1 · answered Sep 29 '14 at 19:09

You can mark the column as ResultColumn, that way the column is retrieved on selects, but isn't included in UPDATE and INSERT

    [ResultColumn("datetime")]
    public DateTime datetime { get; set; }

or just

    [ResultColumn]
    public DateTime datetime { get; set; }

(You don't need to type the name if the property name matches the field name)

score 0 · Answer 2 · answered Sep 29 '14 at 05:54

To force correct column types, I would recommend using scripts to initialize the tables in the database and leave PetaPoco to perform CRUD operations. This is evident in the tests being used in PetaPoco where scripts are used for initialization as follows:

SQL Server

 CREATE TABLE petapoco (
   id bigint IDENTITY(1,1) NOT NULL,
   date_created datetime NOT NULL,
   ...
 );

mysql

CREATE TABLE petapoco (
   id bigint AUTO_INCREMENT NOT NULL,
   date_created datetime NOT NULL,
   ...
  ) ENGINE=INNODB;

The column decorator is used to change the column name to which a property is mapped by specifying it as an argument to the [column] attribute. Therefore if you have a property named id but the column name in the table is named article_id, you would use the following to do the mappings:

[Column("article_id")] 
public long id { get; set; }

In your code you would be using the property name while saving and fetching data and PetaPoco will map the property to the correct column.

So in your question, there would be no need for the attribute as the property and the column names are identical.

How can I force a table column type using Petapoco?

2 Answers2