Ignore properties in data model while keeping them in EF CoreMigration

I have properties in my Model like

Here, I am using this Test class for creating Table in Database using Migration, Now the table is created successfully but the problem is when i want do any operation using stored procedure which is like " Select Title from Test where Id=1" ,When i run the this i am facing error like this

 

The required column 'CreatedDate' was not present in the results of a 'FromSql' operation"

 

I tried

1. NotMapped Attribute it works fine but when i add another migration the NotMapped properties gets Dropped from the database after updating the database
2. Also use Shadow properties and Ignore properties like
3. 1. protected override void OnModelCreating(ModelBuilder modelBuilder)  
   2. {  
   3. modelBuilder.Entity().Property("CreatedDate");  
   4. modelBuilder.Entity().Property("ModifiedDate");  
   5. modelBuilder.Entity().Property("DeletedDate");  
   6. }  
4. Also try this
   1. protected override void OnModelCreating(ModelBuilder modelBuilder) {  
   2. modelBuilder.Entity().Ignore(x => x.DeletedDate);  
   3. modelBuilder.Entity().Ignore(x => x.IsDeleted);  
   4. modelBuilder.Entity().Ignore(x => x.ModifiedDate); }