Issue with setting default Value for DateTime

Question

I have a model in which I can not set [DefaultValue] for DateTime, the object is used to generate a list of users from the powershella script. When I do not have default value and powershell return null this causes an error. I would like to make the date set to 01.01.1990 00:00:00 in the case of null

public class user
        {
            [DefaultValue("")]
            public string Name { get; set; }

            //[DefaultValue( )]
            public DateTime PasswordLastSet { get; set; }
        }

Isn't it better to make DateTime nullable? Before you set the password for the first time, initial value might be null. public DateTime? PasswordLastSet { get; set; } — dropoutcoder, Jun 26 '18 at 08:57
How about `[System.ComponentModel.DefaultValue(typeof(DateTime), "1900-01-01")]` — Matthew Watson, Jun 26 '18 at 08:58

score -1 · Answer 1 · answered Jun 26 '18 at 08:55

-1

Why don't you use a constructor?

public class user
{
    public string Name { get; set; }

    public DateTime PasswordLastSet { get; set; }

    public user()
    {
        PasswordLastSet = DateTime.MinValue;
    }
}

answered Jun 26 '18 at 08:55

omriman12

1,644
7
25
48

if you on C# 6.0+ you can use property initializer for this: `public DateTime PasswordLastSet { get; set; } = DateTime.MinValue;` – vasily.sib Jun 26 '18 at 09:00
You cant use `DateTime.MinValue` in a SQL Server `DateTime` field beacuse `SQL Server` has a MinValue of `1753`. – Afnan Ahmad Jun 26 '18 at 09:01
@vasily.sib so what, the currect way to do this is by constructor, not attribute – omriman12 Jun 26 '18 at 09:01
You should use `System.Data.SqlTypes.SqlDateTime.MinValue` if this will be linked to SQL `DateTime` column. – Afnan Ahmad Jun 26 '18 at 09:01
@Afnan Ahmad thats not the point of the question... sql, mysql, i don't care(it works for mysql) – omriman12 Jun 26 '18 at 09:02
1

@AfnanAhmad you know, there is [DateTime2](https://learn.microsoft.com/ru-ru/sql/t-sql/data-types/datetime2-transact-sql), right? – vasily.sib Jun 26 '18 at 09:08
@omriman12 agreed. – Afnan Ahmad Jun 26 '18 at 09:11
@omriman12 it's ok. Your answer is seems valid as for me. My comment - is just a side note. – vasily.sib Jun 26 '18 at 09:14

Issue with setting default Value for DateTime

1 Answers1