Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jan 31 2019 21:30
    roji commented #2307
  • Jan 31 2019 20:35
    YohDeadfall commented #2307
  • Jan 31 2019 10:20
    capan starred npgsql/npgsql
  • Jan 31 2019 06:10
    SeanFarrow synchronize #2308
  • Jan 30 2019 20:37
    austindrenski commented #2308
  • Jan 30 2019 20:37
    pentagra commented #1445
  • Jan 30 2019 20:33
    SeanFarrow commented #2308
  • Jan 30 2019 20:31
    austindrenski commented #2308
  • Jan 30 2019 20:27
    SeanFarrow commented #2308
  • Jan 30 2019 20:09
    austindrenski labeled #2308
  • Jan 30 2019 20:05
    roji commented #1520
  • Jan 30 2019 19:50
    gyzod commented #1445
  • Jan 30 2019 19:06
    SeanFarrow commented #1520
  • Jan 30 2019 18:54
    roji commented #1520
  • Jan 30 2019 18:53
    roji commented #1520
  • Jan 30 2019 18:52
    roji commented #2050
  • Jan 30 2019 18:45
    Trolldemorted commented #2050
  • Jan 30 2019 18:21
    SeanFarrow commented #1520
  • Jan 30 2019 18:16
    SeanFarrow review_requested #2308
  • Jan 30 2019 18:16
    SeanFarrow review_requested #2308
Shay Rojansky
@roji
@JT-Bruch just copying and pasting the above into a sample file works - there's likely something else you're not showing. Always good to point to a full, runnable code sample rather than snippets...
Sajan
@woodsongem

Hey All,
We have a customer and county table. We added below config and Customer.CountryId is optional. we are able to populate CountryDetail if CountryId is not null and get below error if Customer.CountryId is null. How to fix this issue? . TIA.

builder.HasOne(x => x. CountryDetail).WithOne().HasForeignKey< Country >(x => x. Id).HasPrincipalKey<Customer>(z => z. CountryId);
public class Customer {
  public int Id {get;set;}
  public int? CountryId {get;set;}
  public Country? CountryDetail {get;set;}
}
public class Country
{
 public int CountryId {get;set;}
 public string name  {get;set;}
}

Error:

System.InvalidCastException: Column 'CountryId is null.
   at Npgsql.ThrowHelper.ThrowInvalidCastException_NoValue(FieldDescription field)
   at Npgsql.NpgsqlDataReader.GetFieldValue[T](Int32 ordinal)
   at Npgsql.NpgsqlDataReader.GetInt32(Int32 ordinal)
  at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.BufferedDataRecord.ReadInt(DbDataReader reader, Int32 ordinal, ReaderColumn column)
   at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.BufferedDataRecord.ReadRow()
   at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.BufferedDataRecord.InitializeAsync(DbDataReader reader, IReadOnlyList`1 columns, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.InitializeAsync(IReadOnlyList`1 columns, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.BufferedDataReader.InitializeAsync(IReadOnlyList`1 columns, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
Shay Rojansky
@roji
Looks like you have a null value in the CountryIt column in the database? You're telling EF Core that this isn't possible (that property is a non-nullable int)...
(note that EF Core doesn't support nulls in primary keys)
Matthijs ter Woord
@mterwoord:matrix.org
[m]
Hi all! I recently upgraded a project to .net 6, entity framework core 6 and npgsql 6, and now I have to specify datetimekind everywhere (or resort to the legacy behavior)
Is theer an easy way to have my api assume all dates are in fact utc?
Shay Rojansky
@roji
@mterwoord:matrix.org the question is more why you have DateTimes with non-UTC Kinds in your application, when in fact you want them to mean UTC... For example, maybe you're using DateTime.Now when you should be using DateTime.UtcNow?
Regardless of Npgsql, it's important for the DateTime's Kind to correspond to what's actually being represented
Matthijs ter Woord
@mterwoord:matrix.org
[m]
stuff coming from api's
my api+server side is purely utc
Shay Rojansky
@roji
Like DateTime coming from JSON's being sent by cilents?
Matthijs ter Woord
@mterwoord:matrix.org
[m]
yes
Shay Rojansky
@roji
So if those timestamps really are UTC, I'd look at your JSON deserializer to make it deliver DateTimes with kind UTC
This way in your application you have the right DateTimes
I know it's a pain
Think of DateTimes with different kinds as different .NET types - UTC timestamps and local timestamps really are different things (it's a pity the .NET DateTime type is so badly designed...)
Matthijs ter Woord
@mterwoord:matrix.org
[m]
Sorry for delayed response. Thanks for responding, and suggesting to look at json. I think I fixed (most of) it now. lets see if all tests are green again
Matthijs ter Woord
@mterwoord:matrix.org
[m]
well, the ones caused by this: yes :-)
Thanks!
Matthijs ter Woord
@mterwoord:matrix.org
[m]
Follow-up question: It seems that data retrieved using EFCore doesn't have datetime.kind = utc. Is that something I have to change somewhere as well?
Shay Rojansky
@roji
@mterwoord:matrix.org what is the PostgreSQL column type? For UTC timestamps, it should be timestamp with time zone, and not timestamp without time zone
timestamp with time zone should be the default for DateTime properties in EF Core, so you should get timestamp without time zone only if you're explicitly specifying it
DateTime retrieved from timestamp with time zone should always have Kind=UTC
Matthijs ter Woord
@mterwoord:matrix.org
[m]
hmm, it seems "timestamp" but its all generated by EFC
Shay Rojansky
@roji
With EF Core 6.0?
Are you sure?
Matthijs ter Woord
@mterwoord:matrix.org
[m]
with 3.1 i think
Shay Rojansky
@roji
Ah that's very different indeed
Matthijs ter Woord
@mterwoord:matrix.org
[m]
i made a pgdump yesterday. lets see
Shay Rojansky
@roji
What I wrote above was for 6.0 - there have been significant changes around timestamp handling in that version
Above you said EF Core 6.0 no?
Matthijs ter Woord
@mterwoord:matrix.org
[m]
it seems its all defined with 'without timezone'
i upgraded this project
Shay Rojansky
@roji
Look at the release notes: https://www.npgsql.org/efcore/release-notes/6.0.html#migrating-columns-from-timestamp-to-timestamptz
Matthijs ter Woord
@mterwoord:matrix.org
[m]
i guess i have to upgrade my database schema? (which is definitely an option, if doable via ef migrations)
Shay Rojansky
@roji
Yep
There's instructions for migrating the column types - it's really easy
But read that link carefully
Matthijs ter Woord
@mterwoord:matrix.org
[m]
will re-read
will do reading, but making a migration will automagically upgrade the columns for me?
Shay Rojansky
@roji
It will - but there's something you need to add to that migration after adding it, to make sure there's no bad timezone conversion
Matthijs ter Woord
@mterwoord:matrix.org
[m]
ah
Shay Rojansky
@roji
This all assumes that what you currently have in your database (in your timestamp without time zone columns) is already UTC timestamps
Matthijs ter Woord
@mterwoord:matrix.org
[m]
the set statemnet, i see
Shay Rojansky
@roji
Yep
Matthijs ter Woord
@mterwoord:matrix.org
[m]
yes
and having times/dates switch 1-2 hours wouldn't be a problem, to be honest with you
this is an iot platform. the measurements are in elasticsearch anyway..
:)
Shay Rojansky
@roji
OK :)