Entity Framework default value for null properties on select

Question

Entity Framework default value for null properties on select

asp.net-web-api2 c# entity-framework entity-framework-6

Question

I am possibly looking at moving from nHibernate for my ORM to entity framework and I am running into a small issue if the database is has a null value, but the entity property is not nullable. nHibernate will just set the default value and move on and will not cause any exceptions. Meaning if I have a boolean property it will be false if the database is null.

In entity framework (6) it throws an exception. Is there some configuration setting that I am missing to tell EF to set a default value if the property is not nullable and the database value is null?

Rodney Pannell

View more on Stack Overflow

daf · Accepted Answer · 7/13/2016 5:27:38 PM

Accepted Answer

Your entity properties don't have to be automatic properties, so you could, for instance do:

public class SomeEntity
{
  private bool _field
  public bool? Field
  {
    get { return _field; }
    set { _field = value.HasValue ? false : value.Value; }
  }
}

daf

Entity Framework default value for null properties on select

Question

Fastest Entity Framework Extensions

Accepted Answer

Performance

Expression Evaluator

Related