Can anyone tell me how to set a table column to allow nulls when doing a migration. I have the following model

csharp
    [TableName(TableConstants.Questions.TableName)]
    [ExplicitColumns]
    [PrimaryKey("Id", AutoIncrement=true)]
    public class Question
    {
        [Column("Id")]
        [PrimaryKeyColumn(AutoIncrement = true)]
        public int Id { get; set; }

        [Column("Name")]
        public string Name { get; set; }

        [Column("Responses")]
        public int ResponseCount { get; set; }

        [Column("StartDate")]
        [NullSetting(NullSetting = NullSettings.Null)]
        public DateTime? StartDate { get; set; }

        [Column("EndDate")]
        [NullSetting(NullSetting = NullSettings.Null)]
        public DateTime? EndDate { get; set; }

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

        [Ignore]
        public IEnumerable<Answer> Answers { get; set; }
        [Ignore]
        public IEnumerable<Response> Responses { get; set; }
    }

I am executing

Create.Table<Question>().Do();

but it does not set the datetime fields to allow nulls

I always just add [NullSetting], but not sure I've combined it with datetime

worth a try 😄

Hmm found this in a project, seemingly works:

[NullSetting]
public DateTime? ClosingDate { get; set; }

Don't know if making the type nullable has any effect

They are nullable

csharp
        [Column("EndDate")]
        [NullSetting(NullSetting = NullSettings.Null)]
        public DateTime? EndDate { get; set; }

Didnt you already have this in your example?

no, I had

[NullSetting(NullSetting = NullSettings.Null)]

which didn't work, just using` [NullSetting]` does

Oooh good to know, thanks!

Hello, Sorry to jump in .New to C# and umbraco Just wanna ask how to setup relationship with tables I found this in the above [Ignore] public IEnumerable Answers { get; set; } Is that another table that related to Question table ?

yes

thank you for you response. what does [Ignore] do ?

The Ignore is to prevent it from creating a column called answers in the question table when the table is created.

oh ok, Thank you .