Is it possible to configure application for replace DateTime.MinValue to null?

Question

I work on a big ASP.NET MVC application. This app contains many forms with date time controls. Values of this controls is optional. Also in database field where store values from this controls can be null. Date-time controls returns Min date (0001/1/1) if users not fill it. I'm see often next exceptions in logs The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. I know how fix it For example. Before fix:

DecisionOfLiquidationData= model.DecisionOfLiquidationData,
CompletionOfLiquidationData = model.CompletionOfLiquidationData

After fix:

DecisionOfLiquidationData= model.DecisionOfLiquidationData==DateTime.MinValue ? null: model.DecisionOfLiquidationData,
CompletionOfLiquidationData = model.CompletionOfLiquidationData == DateTime.MinValue ? null : model.DecisionOfLiquidationData

But application contains many code that's look like before fix. My question is next. Is any way to decide this problem globally using web.config or global.asax? Which ideas?

create a helper method. – Amit Kumar Ghosh Mar 06 '17 at 14:13 — Amit Kumar Ghosh, Mar 06 '17 at 14:13
Are you using Code First or Model First entity framework? – Brandon Kramer Mar 06 '17 at 14:20 — Brandon Kramer, Mar 06 '17 at 14:20
Yes. I'm using code first – user6408649 Mar 06 '17 at 14:45 — user6408649, Mar 06 '17 at 14:45

Brandon Kramer · Answer 1 · 2017-03-07T12:20:19.803

My suggestion is to add a default value to the constructor for your model objects to set the value you want as default.

E.g.

public MyDbEntity()
{
    myDateProperty = new DateTime(1900,1,1);
}

This could be quite a bit of typing if you have a lot of model objects with DateTimes that need to be changed, but at least you will only need to do it once per object, and then your done.

Edit: Note that when using Model First Entity Framework, that you will have to create a partial class and declare the constructor there in order to avoid losing your changes when the model code is regenerated.

score 0 · Answer 2 · answered Mar 06 '17 at 16:27

0

you can use nullable ? with datetime like

public DateTime? DecisionOfLiquidationData {get;set;}

what it will do is set the value to default null if no value is assigned

answered Mar 06 '17 at 16:27

Usman

4,615
2
17
33

Is it possible to configure application for replace DateTime.MinValue to null?

2 Answers2