Prevent TestContext from automatically converting data

Question

I parameterize my test cases using data read from CSV files. One of the columns in the csv file has simple date values ​​(like regular strings) in US format, for example mm/dd/yyyy . When data is actually read and populated in TestContext , however, TestContext.DataRow["MyDateColumn"] actually returns a converted System.DateTime object with a timestamp of 12:00:00 AM . I absolutely do not require or do not want this automatic conversion. How to stop this?

Answer 1

If the type MyDateColumn is set to datetime, it should / should return a datetime object.

Try changing the type of MyDateColumn as a string and see if this does the trick.

UPDATE

Change the dates in CSV so that they are "mm / dd / yyyy" instead of mm / dd / yyyy.

Answer 2

 DateTime.Parse(TestContext.DataRow["MyDateColumn"], CultureInfo.InvariantCulture).ToShortDateString() 

Answer 3

I got a solution for this :)

I just put it in front of the actual data. When I receive data, the data arrives as is. Before using it, I remove 'from the data using the substring method.

I remember using this technique for excel to have numbers displayed as text. It worked for me.