You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Provider-specific date/time types (e.g. NpgsqlDate) not supported in 2.1.0 #467
After update to net core 2.1 and Npgsql.EntityFrameworkCore.PostgreSQL 2.1, EF throw exception:
System.InvalidOperationException: "The property 'TBReestr.TBrDateEnd' is of type 'Nullable<NpgsqlDate>' which is not supported by current database provider.
Why I use NpgsqlDate\NpgsqlDateTime instead of DateTime? We use (+-)Infinity values of timestamp in postgres base (Default values for some data in db). DateTime doesn't support it (maybe infinity must be mapped to DateTime.Max/.Min values, now i convert it in code).
Migrate to NodaTime not easy when you has a lot of code with manipulating DateTime.
p.s. Sorry for my English :(
You can specify Convert Infinity DateTime=true to access infinity values as DateTime.{Max,Min}Value, this allows you to avoid using the Npgsql-interactive specific types which are frankly not that great.
changed the title [-]Nullable<NpgsqlDate> not supported by current database provider.[/-][+]Provider-specific types (e.g. NpgsqlDate) not supported in 2.1.0[/+]on Jun 14, 2018
Moving to backlog as there's not much request for this, and we're considering deprecating the provider-specific date/time types altogether (npgsql/npgsql#2009).
changed the title [-]Provider-specific types (e.g. NpgsqlDate) not supported in 2.1.0[/-][+]Provider-specific date/time types (e.g. NpgsqlDate) not supported in 2.1.0[/+]on Dec 30, 2018
Activity
iflight commentedon Jun 13, 2018
Why I use NpgsqlDate\NpgsqlDateTime instead of DateTime? We use (+-)Infinity values of timestamp in postgres base (Default values for some data in db). DateTime doesn't support it (maybe infinity must be mapped to DateTime.Max/.Min values, now i convert it in code).
Migrate to NodaTime not easy when you has a lot of code with manipulating DateTime.
p.s. Sorry for my English :(
roji commentedon Jun 13, 2018
You can specify
Convert Infinity DateTime=trueto access infinity values asDateTime.{Max,Min}Value, this allows you to avoid using the Npgsql-interactive specific types which are frankly not that great.[-]Nullable<NpgsqlDate> not supported by current database provider.[/-][+]Provider-specific types (e.g. NpgsqlDate) not supported in 2.1.0[/+]roji commentedon Jun 30, 2018
Moving to backlog as there's not much request for this, and we're considering deprecating the provider-specific date/time types altogether (npgsql/npgsql#2009).
[-]Provider-specific types (e.g. NpgsqlDate) not supported in 2.1.0[/-][+]Provider-specific date/time types (e.g. NpgsqlDate) not supported in 2.1.0[/+]