Entity Framework Core - Knowledge Base (KB)

How to create a table corresponding to enum in EF6 Code First?

I've followed ...MSDN... on how to handle enumerations in Code First for EF6. It worked, as supposed to ...but... the field in the created table that refers to the enumerator is a simple ...int.......I'd prefer a second table to be produced, the values of...

How to implement typesafe enum pattern in entity framework core rc2

How can I implement the ...typesafe enum pattern... in entity framework core rc2?...public class TestStatus { [Column("Id")] public int Id { get; private set; } [Column("Description")] public string Description { get; private set; } ...

How to create a table corresponding to enum in EF Core Code First?

How would one turn the enums used in an EF Core database context into lookup tables and add the relevant foreign keys?...Same as ...EF5 Code First Enums and Lookup Tables... but for EF Core instead of EF 6...Related to ...How can I make EF Core database f...

.Net Core 2.1 seems to be ignoring modelBuilder.Entity<TEntity>().HasData

I have a .net core project that contains model, service and api projects. My original goal with this project was to make enums work in a more "code-first" way. I wanted to just be able to modify the enum and get the database and the lookup table to be upd...

How to fix No suitable constructor found

I have to use Enum Safe Pattern to persist in the database, just the code of an enum. When I try to run the migration, I get the error:...No suitable constructor found for entity type 'Regiao'. The following constructors had parameters that could not be b...

enriching enums - possible?

I am looking for a solution to store immutable data in my code instead of the db. In the specific case I want to deal with units. Here an example for units of weight (they won't change, so its ok to store them in my code): ...public class Unit { ...

Default values for EF Core with enum to string Value Conversion

EF Core 2.1+ supports ...Value Conversions.... You can use the built-in ...EnumToStringConverter<>... to automatically convert an Enum to string, and vice versa....I'm connecting to an existing database and would like one of the columns to be converted to...

Npgsql enum array with int conversion throws InvalidCastException on "Contains"

I'm using enum to int conversion for enum arrays in npgsql due to lack of enum altering features....Model: ...public class TestEntity { public Guid Id { get; set; } public TestEnum[] Enums { get; set; } public TestEntity() { Enums...

Convert Enum From String To Int In DB Then Back To String - Entity Framework Core 3

I have an Enum similar to this:... public enum Type { TypeA, TypeB, TypeC } ...I have this using Fluent API and Entity Framework 3.0:... builder.Entity<Element>() .Property(p => p.Type) .HasConversion<...

Workaround for DefaultIfEmpty

I have something like this:...public enum CoolEnum { Yes = 0, No = 1, Perhaps = 2, Maybe = 3, Perchance = 4, } ...and I want to do the following:...CoolEnum? enum = await this.context .MyTable .Where(x => x.Id == ...

Entity Framework Core 3.1 Enum Conversion failed when converting the nvarchar value 'EnumValue' to data type int

I'm using Entity Framework Core 3.1 and trying to do a simple query on an enum property in my entity in my localdb and I keep getting this error:...Enum conversion failed when converting the nvarchar value 'Accountant' to data type int...Entity:...public ...