Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Manish Agrawal 25 posts 218 karma points
    Aug 10, 2017 @ 07:32
    Manish Agrawal
    0

    Create Nullable field with PetaPoco Model

    Hi,

    I am using petapoco to create custom table in database.

    Now I want to change int and datetime property as NULLABLE. so I have set (?) with property datatype.

    public int? TotalNumber { get; set; }

    I have deleted the tables and running the project. It is creating new table with not Nullable field.

    Please suggest what I am missing.

    Thanks

    Copy Link
  • Manish Agrawal 25 posts 218 karma points
    Aug 11, 2017 @ 05:19
    Manish Agrawal
    0

    It will be good if any one can reply on it.

    when I am trying to create table with nullable fields it is creating not nullable fields in tables.

    Please suggest what is the approach to make this in petapoco. I have done this many times in MVC entity framwork but this is not working here.

    Regards Manish

    Copy Link
  • David Brendel 792 posts 2970 karma points MVP 3x c-trib
    Aug 11, 2017 @ 07:41
    David Brendel
    0

    Hi Manish,

    don't think this is possible with PetaPoco when creating the table with the poco. You could try creating the schema by sql. At least I now that with that you could set a field to nullable.

    Alter.Table(yourTable).AddColumn("TotalNumber").AsInt32().Nullable();

    Maybe this works.

    Regards David

    Copy Link
  • Manish Agrawal 25 posts 218 karma points
    Aug 11, 2017 @ 12:29
    Manish Agrawal
    100

    Thanks David for reply.

    but this will not help in my problem.

    I will wait Peta poco new versions if they fix this problem in new versions.

    Thanks

    Copy Link
  • Marcio Goularte 389 posts 1362 karma points
    Aug 11, 2017 @ 14:48
    Marcio Goularte
    9

    Add this attribute: [NullSetting(NullSetting = NullSettings.Null)]

    [NullSetting(NullSetting = NullSettings.Null)]
public int? TotalNumber { get; set; }

    UPDATE: Does it work with DateTime, I use it in a project.

    [NullSetting(NullSetting = NullSettings.Null)]
public DateTime? Suporte { get; set; }
    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies