Styjun

Why can't my huge trees be chopped down?

Why is it considered Acid Rain with pH <5.6

Why are so many countries still in the Commonwealth?

Why isn't there a serious attempt at creating a third mass-appeal party in the US?

Why/when is AC-DC-AC conversion superior to direct AC-Ac conversion?

Why did Saturn V not head straight to the moon?

What does "see" in "the Holy See" mean?

Trying to build a function to compute divided difference for arbitrary list of points

How could a thief buying plane tickets with stolen credit card details benefit personally?

Are there any examples of technologies have been lost over time?

How do we explain the E major chord in this progression?

Heisenberg uncertainty principle in daily life

Is there a reason why I should not use the HaveIBeenPwned API to warn users about exposed passwords?

How can I prevent corporations from growing their own workforce?

Why are all my history books dividing Chinese history after the Han dynasty?

Convert every file from JPEG to GIF in terminal

Problem in styling a monochrome plot

How to deal with a player who makes bad characters and kills them?

Is there anything wrong with Thrawn?

How can I receive packages while in France?

What is the lowest-speed bogey a jet fighter can intercept/escort?

Why are off grid solar setups only 12, 24, 48 VDC?

Commercial jet accompanied by small plane near Seattle

Would this neural network have short term memory?

Mapping NULLs to type default

What is the difference between the remap, noremap, nnoremap and vnoremap mapping commands in Vim?EF Core Relation doesn't existEF core, incorrect mapping of null for nvarcharGetting metadata in EF Core: table and column mappingsAppend model builder overrides in partial for default SQL valuesEF Core / DbContext > Map custom type as primary keyThe property 'PropertyName' could not be mapped, because it is of type 'List<decimal>'Can a database column be configured to allow NULL even if the property type is not nullable?How to extend DbContext with partial class and partial OnModelCreating method in EntityFramework Coreforce innodb engine with Pomelo.EntityFrameworkCore.MySql 2.1.4

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have model classes that I need to use with Entity Framework Core. Unfortunately, I cannot make changes to these classes and none of them use nullable columns, while the database tables they map to do have nullable columns. EF throws an (expected) exception when trying to pull data from the database into the model class.

Is there a way to configure EF Core to automatically map NULLs in a column to the default for the given type?

For example,

//Model class
class Foo

 public int Id get; set;
 public int Age get; set;


//DbContext
public class MyContext: DbContext

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 
 modelBuilder.Entity<MyContext>(entity =>
 
 entity.HasKey(e => new e.Id );
 entity.ToTable("Foo", "dbo");
 entity.Property(e => e.Age).HasColumnName("Age");
 
 

The goal would be that when requesting the data a null in column Age would become the type default (0 in this case).

.net mapping entity-framework-core

share|improve this question

asked Mar 26 at 17:21

MgSamMgSam

6,0841212 gold badges5151 silver badges7878 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  at first, i thought value conversion would solve this but unfortunately, it doesn't convert null. See also Allow HasConversion/ValueConverters to convert nulls
  
  – Jan Paolo Go
  Mar 26 at 18:31
  

  
  
  
  

add a comment | 

0

I have model classes that I need to use with Entity Framework Core. Unfortunately, I cannot make changes to these classes and none of them use nullable columns, while the database tables they map to do have nullable columns. EF throws an (expected) exception when trying to pull data from the database into the model class.

Is there a way to configure EF Core to automatically map NULLs in a column to the default for the given type?

For example,

//Model class
class Foo

 public int Id get; set;
 public int Age get; set;


//DbContext
public class MyContext: DbContext

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 
 modelBuilder.Entity<MyContext>(entity =>
 
 entity.HasKey(e => new e.Id );
 entity.ToTable("Foo", "dbo");
 entity.Property(e => e.Age).HasColumnName("Age");
 
 

The goal would be that when requesting the data a null in column Age would become the type default (0 in this case).

.net mapping entity-framework-core

share|improve this question

asked Mar 26 at 17:21

MgSamMgSam

6,0841212 gold badges5151 silver badges7878 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  at first, i thought value conversion would solve this but unfortunately, it doesn't convert null. See also Allow HasConversion/ValueConverters to convert nulls
  
  – Jan Paolo Go
  Mar 26 at 18:31
  

  
  
  
  

add a comment | 

I have model classes that I need to use with Entity Framework Core. Unfortunately, I cannot make changes to these classes and none of them use nullable columns, while the database tables they map to do have nullable columns. EF throws an (expected) exception when trying to pull data from the database into the model class.

Is there a way to configure EF Core to automatically map NULLs in a column to the default for the given type?

For example,

//Model class
class Foo

 public int Id get; set;
 public int Age get; set;


//DbContext
public class MyContext: DbContext

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 
 modelBuilder.Entity<MyContext>(entity =>
 
 entity.HasKey(e => new e.Id );
 entity.ToTable("Foo", "dbo");
 entity.Property(e => e.Age).HasColumnName("Age");
 
 

The goal would be that when requesting the data a null in column Age would become the type default (0 in this case).

.net mapping entity-framework-core

share|improve this question

asked Mar 26 at 17:21

MgSamMgSam

6,0841212 gold badges5151 silver badges7878 bronze badges

//Model class
class Foo

 public int Id get; set;
 public int Age get; set;


//DbContext
public class MyContext: DbContext

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 
 modelBuilder.Entity<MyContext>(entity =>
 
 entity.HasKey(e => new e.Id );
 entity.ToTable("Foo", "dbo");
 entity.Property(e => e.Age).HasColumnName("Age");
 
 

share|improve this question

asked Mar 26 at 17:21

MgSamMgSam

6,0841212 gold badges5151 silver badges7878 bronze badges

share|improve this question

asked Mar 26 at 17:21

MgSamMgSam

6,0841212 gold badges5151 silver badges7878 bronze badges

asked Mar 26 at 17:21

MgSamMgSam

6,0841212 gold badges5151 silver badges7878 bronze badges

asked Mar 26 at 17:21

MgSamMgSam

6,0841212 gold badges5151 silver badges7878 bronze badges

1 Answer
1

active

oldest

votes

1

If you can change the implementation of the class without changing its public definition, you can do this.

public class Foo

 public int Id get; set; 
 private int? _Age get; set; 
 public int Age
 
 get => _Age.GetValueOrDefault();
 set => _Age = value;
 


public class MyContext : DbContext

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 
 modelBuilder.Entity<Foo>(entity =>
 
 entity.Property("_Age").HasColumnName("Age");
 entity.Ignore(e => e.Age);
 );
 

share|improve this answer

answered Mar 26 at 18:40

Jan Paolo GoJan Paolo Go

2,10911 gold badge77 silver badges2626 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This was a great solution. Thanks for thinking of it!
  
  – MgSam
  Mar 27 at 15:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You're welcome! You might also want to upvote github.com/aspnet/EntityFrameworkCore/issues/13850 which is a better solution. :)
  
  – Jan Paolo Go
  Mar 27 at 15:24
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55362908%2fmapping-nulls-to-type-default%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

If you can change the implementation of the class without changing its public definition, you can do this.

public class Foo

 public int Id get; set; 
 private int? _Age get; set; 
 public int Age
 
 get => _Age.GetValueOrDefault();
 set => _Age = value;
 


public class MyContext : DbContext

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 
 modelBuilder.Entity<Foo>(entity =>
 
 entity.Property("_Age").HasColumnName("Age");
 entity.Ignore(e => e.Age);
 );
 

share|improve this answer

answered Mar 26 at 18:40

Jan Paolo GoJan Paolo Go

2,10911 gold badge77 silver badges2626 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This was a great solution. Thanks for thinking of it!
  
  – MgSam
  Mar 27 at 15:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You're welcome! You might also want to upvote github.com/aspnet/EntityFrameworkCore/issues/13850 which is a better solution. :)
  
  – Jan Paolo Go
  Mar 27 at 15:24
  

  
  
  
  

add a comment | 

1

If you can change the implementation of the class without changing its public definition, you can do this.

public class Foo

 public int Id get; set; 
 private int? _Age get; set; 
 public int Age
 
 get => _Age.GetValueOrDefault();
 set => _Age = value;
 


public class MyContext : DbContext

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 
 modelBuilder.Entity<Foo>(entity =>
 
 entity.Property("_Age").HasColumnName("Age");
 entity.Ignore(e => e.Age);
 );
 

share|improve this answer

answered Mar 26 at 18:40

Jan Paolo GoJan Paolo Go

2,10911 gold badge77 silver badges2626 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This was a great solution. Thanks for thinking of it!
  
  – MgSam
  Mar 27 at 15:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You're welcome! You might also want to upvote github.com/aspnet/EntityFrameworkCore/issues/13850 which is a better solution. :)
  
  – Jan Paolo Go
  Mar 27 at 15:24
  

  
  
  
  

add a comment | 

If you can change the implementation of the class without changing its public definition, you can do this.

public class Foo

 public int Id get; set; 
 private int? _Age get; set; 
 public int Age
 
 get => _Age.GetValueOrDefault();
 set => _Age = value;
 


public class MyContext : DbContext

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 
 modelBuilder.Entity<Foo>(entity =>
 
 entity.Property("_Age").HasColumnName("Age");
 entity.Ignore(e => e.Age);
 );
 

share|improve this answer

answered Mar 26 at 18:40

Jan Paolo GoJan Paolo Go

2,10911 gold badge77 silver badges2626 bronze badges

public class Foo

 public int Id get; set; 
 private int? _Age get; set; 
 public int Age
 
 get => _Age.GetValueOrDefault();
 set => _Age = value;
 


public class MyContext : DbContext

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 
 modelBuilder.Entity<Foo>(entity =>
 
 entity.Property("_Age").HasColumnName("Age");
 entity.Ignore(e => e.Age);
 );
 

share|improve this answer

answered Mar 26 at 18:40

Jan Paolo GoJan Paolo Go

2,10911 gold badge77 silver badges2626 bronze badges

answered Mar 26 at 18:40

Jan Paolo GoJan Paolo Go

2,10911 gold badge77 silver badges2626 bronze badges

answered Mar 26 at 18:40

Jan Paolo GoJan Paolo Go

2,10911 gold badge77 silver badges2626 bronze badges