Open perlun opened 1 year ago
I'll take a look at this, see what's going on.
As someone who works with a number of codebases still on .NET Framework, I'm in favor of maintaining as much compatibility as possible. Conditional compiles can be your friend. In this case, explicitly supporting DateOnly
would require adding a net6.0
compilation target to the package, but maybe there's something else that can be done.
In the short term, either a value converter or a custom mapper would be the way to go for you. A value converter would have to be applied to each DateOnly
field, whereas a mapper (passed to the Database
constructor) could handle them all at once.
@asherber , can you point me to an example of a custom-mapper (or provide a custom-mapper for the DateOnly type)?
There are several ways of going about this. Here's one.
create table date_test (Foo date not null);
insert into date_test (Foo) values ('2024-08-01');
class DateMapper : ConventionMapper
{
public override Func<object, object> GetFromDbConverter(PropertyInfo targetProperty, Type sourceType)
{
// see if there's already a converter on the class/property
var result = base.GetFromDbConverter(targetProperty, sourceType);
if (result == null
&& targetProperty.PropertyType == typeof(DateOnly)
&& sourceType == typeof(DateTime))
{
return o => DateOnly.FromDateTime((DateTime)o);
}
return result;
}
}
class DateTest
{
public DateOnly foo { get; set; }
}
using var db = new Database(Connection, new DateMapper());
var records = db.Fetch<DateTest>("select * from date_test");
Given the preconditions (that we need to support Netstandard 2.0+, .NET Framework 4.0 and 4.5+), I might be asking for the impossible here, but anyway... :slightly_smiling_face:
Trying to read a
DATE NOT NULL
field in PostgreSQL, but it causes the following failure:My guess is that I need to resort to a custom converter, i.e. create a class which inherits from
ValueConverterAttribute
and override the methods there for now? :thinking: To manually handle such properties.Would be awesome to be able to drop all "old" platforms here to be able to fully utilize the goodness of
DateOnly
, which is .NET 6 and 7 only... but I realize I might be one of the privileged few in this case, not having to deal with any legacy .NET codebases. :grin: (My day job is as a Java programmer. :joy:)