dapper nodatime npgsql

dapper_nodatime_npgsql

public class DapperTest 
{
	public ZonedDateTime DapperTime { get; set;}
}

private void NpgsqlWithDapper()
{
	
	NpgsqlConnection.GlobalTypeMapper.UseNodatime();
	SqlMapper.AddTypeHandler(ZonedDateTimeHandler.Default);
	using (var connection = new NpgsqlConnection("connection_string"))
	{

		connection.Open();
		
		var d = connection.Query<DapperTest>("set time zone 'Europe/Vienna'; select now() as dappertime;").First();
		
		Console.WriteLine(d);

	}
}





public class ZonedDateTimeHandler : SqlMapper.TypeHandler<ZonedDateTime>
{
	private ZonedDateTimeHandler()
	{
	}

	public static readonly ZonedDateTimeHandler Default = new ZonedDateTimeHandler();

	public override void SetValue(IDbDataParameter parameter, ZonedDateTime value)
	{
		parameter.Value = value.ToInstant();

		if (parameter is SqlParameter sqlParameter)
		{
			sqlParameter.SqlDbType = SqlDbType.DateTime2;
		}
	}

	public override ZonedDateTime Parse(object value)
	{
		Console.WriteLine(value.GetType()); // typeof Instant not ZonedDatetime
		
		if (value is ZonedDateTime dateTime)
		{
			Console.WriteLine(value);
		}

		throw new DataException("Cannot convert " + value.GetType() + " to NodaTime.ZonedDateTime");
	}
}