Entity framework code first convert between class boolean and column integer

Question

I am using Entity Framework 5 code first. My table has a column called Active and its datatype is of type int. The values that are stored in Active are 0, 1 and null.

I have a class that I need to map to this table.

public class CommandExecutionServer : IEntity
{
     public int Id { get; set; }

     public bool? IsActive { get; set; }
}

Here is my configuration file. I am trying to map my boolean property in my class to the integer field in the database.

class CommandExecutionServerConfiguration : EntityTypeConfiguration<CommandExecutionServer>
{
     internal CommandExecutionServerConfiguration()
     {
          this.ToTable("tblCommandExecutionServers");
          this.Property(x => x.IsActive).HasColumnName("Active").HasColumnType("bit");
     }
}

This is not working well. The error that I am getting is:

The 'IsActive' property on 'CommandExecutionServer' could not be set to a 'Int32' value. You must set this property to a non-null value of type 'Boolean'

I tried adding .HasColumnType("bit") and thought that it might take of my problem. How do I do this? Ideally I would like 0 to be false, 1 to true, null to be null, and any other number to false.

UPDATE

If I change the above to:

this.Property(x => x.IsActive).HasColumnName("Active").HasColumnType("int");

...then I get the following error:

Member Mapping specified is not valid. The type 'Edm.Boolean[Nullable=True,DefaultValue=]' of member 'IsActive' in type 'MyProject.Infrastructure.EntityFramework.CommandExecutionServer' is not compatible with 'SqlServer.int[Nullable=True,DefaultValue=]' of member 'Active' in type 'CodeFirstDatabaseSchema.CommandExecutionServer'.

have you tried with HasColumnType("int") ? With the same problem, I set the column type to bit in SQL server. — tschmit
– tschmit, Commented Mar 7, 2013 at 9:52
See my update above. Yes I would also want to set it to bit but it's not my server so I can't go change table structures :) — Brendan Vogt
– Brendan Vogt, Commented Mar 7, 2013 at 10:15
Does this answer your question? Entity Framework C# convert int to bool — TotPeRo
– TotPeRo, Commented Feb 2, 2024 at 17:20

Brendan Vogt · Accepted Answer · 2013-03-07 10:43:27Z

1

I tried the following because I do not know if Entity Framework can handle the conversion for me.

I removed this line:

this.Property(x => x.IsActive).HasColumnName("Active").HasColumnType("int");

I then added a property to my CommandExecutionServer class:

public class CommandExecutionServer : IEntity
{
     public int Id { get; set; }

     public int? Active { get; set; }

     public bool IsActive
     {
          get
          {
               return (Active == 1) ? true : false;
          }
     }
}

There might be a better way but this works for me for now. If any one can better this then please go ahead :)

answered Mar 7, 2013 at 10:43

Brendan Vogt

26.1k39 gold badges152 silver badges236 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

tschmit Over a year ago

the point here is: IsActive is unknown from the sql server, so if you query using this field in a where, you'll have to get all the table lines client side. BTW, have you an Ignore(x => x.IsActive) in your context ? And if not, Does the mapping run UnExceptionnaly ?

Brendan Vogt Over a year ago

No I don't have it as Ignore. No exception this way.

1c1cle · Accepted Answer · 2015-12-21 15:00:57Z

1

 SELECT   CONVERT(A.bitcolumn as bit) as bitout

ado.net will convert bits to bools. So, just convert your integer to a bit in your select statement in t-sql.

answered Dec 21, 2015 at 15:00

1c1cle

4333 silver badges6 bronze badges

Comments

TotPeRo · Accepted Answer · 2024-02-02 17:21:39Z

0

In Entity Framework Core you can use Value Conversions like this:

class CommandExecutionServerConfiguration : EntityTypeConfiguration<CommandExecutionServer>
{
     internal CommandExecutionServerConfiguration()
     {
          this.ToTable("tblCommandExecutionServers");
          this.Property(x => x.IsActive)
          .HasColumnName("Active")
          .HasConversion<int>();
     }
}

Collectives™ on Stack Overflow

Entity framework code first convert between class boolean and column integer

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related