Page 1 of 1

DateTime Type is reflected as "datetime2" in Entity Developer Version6.4.775

Posted: Fri 26 Jul 2019 09:35
by PixelHunter
Hi!

I have a problem regarding Entity Developer/Entity Framework Core and the migration to a database after model creation.

I created an EF Core Model in Entity Developer.

When I set the Type as "DateTime" in the desired properties, the type is reflected in Database (Sql Server) as "datetime2", the same happens when I ser the type to "Date", it goes to "datetime2".

Image
Image


I would like to have a normal "datetime" value in Sql Server, How can I achieve this?

Re: DateTime Type is reflected as "datetime2" in Entity Developer Version6.4.775

Posted: Fri 26 Jul 2019 18:17
by Shalex
Please double-click on the particular property in your EF Core Model to get Property Editor, then press [...] against Column to open Column Editor, set SQL Type and press OK.