Seeding date in EF 2.1

asp.net-core entity-framework-core sql-server

Question

I am using new way of seeding data in Entity Framework 2.1:

modelBuilder.Entity<Blog>().HasData(new Blog {BlogId = 1, CreateDate = DateTime.Now});

However, applying this to the database throws an exception Conversion failed when converting date and/or time from character string. I can see that in the generated SQL the value comes as '2018-06-01T13:22:13.248-07:00' which is wrong. And since the field is obviously DateTime, I can't format it into the string the way I would want to.

Is it a bug in EF? Or I am missing something obvious? In the traditional EF code it works fine:

Blog.CreateDate = DateTime.Now;
...
context.SaveChanges();

Or maybe there is some workaround on the SQL side that would allow it to take date in this format?

1
3
6/1/2018 10:09:02 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Issue 1 here is the conversion failure. This can be solved by converting the column to DateTime2. Reference: Seeding DateTime in EF 2.1 throws exception #12211

Issue 2 (DateTime.Now becomes a fixed date/time) is something I looking into as well.

0
8/22/2018 11:26:00 AM

Popular Answer

Use {[Column(TypeName = "datetime")] annotation

public class Blog
{[Column(TypeName = "datetime")]
public DateTime CreateDate { get; set; }
Foy

Related Questions

Is it possible/advisable to seed Users/Roles using the EFCore 2.1 Data Seeding system?

As of EFCore 2.1 it's possible to seed data using the DbContext OnModelCreating method....https://docs.microsoft.com/en-us/ef/core/modeling/data-seeding...However user/role creation is usually handled by a UserManager/RoleManager....Now, I can manually create a Role or User - but for example in the case of a User I need to hash the password myself ...
asp.net-core entity-framework-core
asked by David Kirkpatrick

Seeding data for a particular environment in Entity Framework Core 2.1

I'm using the new way of seeding data in EF Core 2.1 and I want to seed data for the development environment only....Initially I tried this:...protected override void OnModelCreating(ModelBuilder modelBuilder) { if (Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") != EnvironmentName.Development) { return; } mode...
asp.net-core c# entity-framework-core
asked by ChaoticNadirs

.NET Core 2.1 and EF Framework 2.1

I'm trying to replace a web service that provides information to a mobile app via ODATA 4. The current application is using EF6 and works without error....I have subsequently built a NEW .NET Core 2.1.1, using EF 2.1 and Core Odata 7.0.1. Everything seems to be functioning property when run on IISExpress through the Visual Studio 2017 interface. ..
.net-core c# entity-framework entity-framework-core odata
asked by Stewart Basterash

EF Core 2.1 HasData() creating deletes and re-inserts for unchanged entities on subsequent migrations

Update 8/29/18...Seeing this issue in inline ...new...-ing of seed data as well. Opened an ...EF Core issue.... Will update the question with any findings....I am trying to use ...EF Core 2.1's seeding mechanism.... However, I want to load the seed data from json flat files rather than hard-coding new C# objects. I wrote the extension method below,...
c# entity-framework-core seeding
asked by Collin M. Barrett

Best way to coordinate atomic transactions between different business services in .NET Core / EF Core 2.1?

Let's say you have a UsersService, a TenantsService, and a TenantUserRolesService. ...Each of these services has a "create" method to create their entity and has the same DbContext dependency injected, except for UsersService which has the Identity UserManager class injected....Your goal is to provide an API endpoint that lets a new tenant register...
.net asp.net-core c# entity-framework entity-framework-core
asked by Suren

EF Core 2.1 seeding data primary key

I have just run into an issue, reminiscent of chicken and egg situation....I'm trying to seed data in EF 2.1.3. I have a class called "Sample". ...public class Sample { public long Id { get; set; } public string Name { get; set; } public string Description { get; set; } public bool IsActive { get; set; } ...
ef-core-2.1 ef-migrations entity-framework-core
asked by Nick Goloborodko

Seed data in EF 2.1 with related entities

Using ASP.NET Core 2.1 and Entity Framework Core 2.1 I have the following entities:...public class Category { public Int32 Id { get; set; } public String Name { get; set; } } public class Post { public Int32 Id { get; set; } public Int32 CategoryId { get; set; } public String Title { get; set; } public String Content { get; set; } pu...
asp.net-core asp.net-core-2.1 entity-framework-core entity-framework-core-2.1
asked by Miguel Moura

How to seed an enum in Entity Framework Core 2.1

I am new to EF Core, and am trying to seed an enum. ...According to ...Data Seeding..., this feature is new to EF Core 2.1....I reviewed several solutions including this ...SO solution by Blake Mumford..., but this doesn't work for me since an enum is not a reference type....My goal (with the help from migrations) is to have the Category enum to be...
.net-core asp.net asp.net-core entity-framework entity-framework-core
asked by Pavel

EF Core 2.1 with Seed method and NotMapped attribute

I have a question, why my ...Strategy... property is null, when i getting all ...DbSet... from context? How to ...[NotMapped]... property make visible in my backend?...My class looks like this:...public class Machine { [Key] public int Id { get; set; } [NotMapped] public WorkStrategy Strategy { get; set; } public double GetManH...
asp.net-core c# entity-framework-core seeding
asked by michasaucer

EF Core 2.1 Linq Query to EF Core 3.0

I am dealing with a query that i cannot get to work on ef core 3.0 and it worked fine in the 2.1 version, i would like if anyone can help figure how i can get it work in the 3.0 version....So let me start with the challenge. ...i have a table that is named Zone and it has a one to many relationship to a table called Bin, and bin has a one to many r...
c# ef-core-3.0 entity-framework entity-framework-core linq
asked by Sol Stein

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow