store only date in database not time portion C#

Question

I have a test class and an ExecutionDate property which stores only date but when we use [DataType(DataType.Date)] that also stores the time portion in database but I want only date portion.

public class Test {      [Key]      public int Id { get; set; }       [DataType(DataType.Date)]      public DateTime ExecutionDate { get; set; }       } 

Is any way to store only date on time portion in db using Entity Framework? Please help me....

I have added snapshot when use [DataType(DataType.Date)] that stores time portion 00:00 I want remove that

Answer 1

I think you are trying to specify database column type. You could use data annotations as described in this article.

Here is an example :

[Table("People")] public class Person {     public int Id { get; set; }      [Column(TypeName = "varchar")]     public string Name { get; set; }      [Column(TypeName="date")]     public DateTime DOB { get; set; } } 

By default, string is translated to nvarchar, we have changed that here. Also Datetime (this is what you asked I suppose) which by default maps to datatime in sql server, is changed to date which stores only the date portion and not the time portion of a DateTime value.

Answer 2

On EF core one may add override OnModelCreating in DbContext class.

protected override void OnModelCreating(ModelBuilder builder)         {             builder.Entity<Test>().                 Property(p => p.ExecutionDate)                 .HasColumnType("date");         }