Adding int property, EF keeps making it nullable column?

entity framework property can't be set to string, has to be nullable int

The 'EmpGipNumber' property on 'Employee' could not be set to a 'System.String' value. You must set this property to a non-null value of type 'System.Int32'....I'm getting this error, and my Employee Model's EmpGipNumber property is declared like this:...public virtual int? EmpGipNumber {get;set;} ...why is it complaining, its a nullable int alr...

EF6 Map column of type int to entity property type bool

I use Entity Framework 6 (EF6), and I want to map a table with a column of type int which only have values 0 or 1 to a property of type bool on my entity. ...I would like to do so without the need for having two properties for the same column by having a property that is not mapped using the property that is mapped in its get'er and set'er like thi...

Error in DbContext after adding a column to table (ASP.NET/EF Core)

All was working fine until I added a new column to my table. I could not find how to update the model class, so I added the column myself in model. But now, when I run my application, I get error: "Object reference not set to an instance of an object."...During debug, I found that it is the problem with creation of instance of my dbcontext:...MyDbC...

Ignore table columns in EF Core

I am creating a greenfield application that uses EF Core which must talk to a legacy database. I want EF to ignore some of the columns in the database because they will eventually be deprecated and I don't want them in the new entity model. I can't remove them yet as the legacy system still relies on them....For an unwanted database column called ....

How can I stop EF Core from creating a filtered index on a nullable column

I have this model:...public class Subject { public int Id { get; set; } [Required] [StringLength(50)] public string Name { get; set; } public int LevelId { get; set; } [ForeignKey("LevelId")] public Level Level { get; set; } [Column(TypeName = "datetime2")] public DateTime? DeletedAt { get; set; } } ...And in...

.NET Core 2.x Identity int foreign key cannot target int primary key

The exception message is not quite clear, but usually indicates improper model configuration....There are several factors to be considered here....First, in version 2.0 the navigation properties have been removed from identity model, and the base ...IndentityDbCOntext... implementation ...explicitly... configures the relationships ...with no naviga...

Change the IDENTITY property of a column, the column needs to be dropped and recreated

I am using ...EF Core 2.1...This was my initial model definition....public class Customer //Parent { public int Id { get; set; } public string Name { get; set; } public string Email { get; set; } public BankAccount BankAccount { get; set; } } public class BankAccount { public int Id { get; set; } public string Branch ...

How should I handle having a entities property be non-nullable while the column is nullable? - EF Core

The database has nullabble columns, which I was told it was safe to assume would never have null data in them. The entity framework code was modeled under this assumpion. Some customer databases, however, I have found do in fact have the occasional null value in these columns. Entity Framework proceeds to blow up internally on using SqlReader to re...

EF Core - How to group by a nullable column through multiple joins

Given the following models in EF Core 2.2:...public class A { public int Id { get; set; } public ICollection<B> Bs { get; set; } } public class B { public int Id { get; set; } public int AId { get; set; } public ICollection<C> Cs { get; set; } } public class C { public int Id { get; set; } public int BId { get; set; } ...

Auto-generated FK relations in EF Core - how to made them non-nullable

I have the following model:...public class Child { public int Id { get; set; } } public class Parent { public int Id { get; set; } public List<Child> Childs { get; set; } } ...Without any further instructing, EF Core 3.1 automatically infers the reference relation between ...Parent... and ...Child..., and generates the following migrat...