Mapping a date field to a string property of record

I am trying to migrate all my classes to record because it is much more convenient and during that I found a case which works fine on class type but not record:

Structure of record:
public record Foo(string EffectiveDate);
OR
public record Foo() {
public string EffectiveDate { get; set; }
}

Structure of class
public class Foo {
public string EffectiveDate { get; set; }
}

My MSSQL table is using Date data type for EffectiveDate, when I tried to query by using dapper then it throws an exception said it can't match the record which doesn't happened when using class.

Is there a workaround to get through? Thanks.

Start by reproducing the reported difference between the shown C# record and class when mapping the MSSQL Date field EffectiveDate with Dapper. Compare the mapping behavior and determine whether the record maps successfully or whether a documented workaround is needed.