NotWorkingDateTime link
CrudMultipleSimpleTable [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (10s 133ms) link
✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (26ms)
✓ 2. CRUD Tbl DATETIME Table [nr: "20"] (10s 104ms)
CrudMultipleSimpleTable [provider: "MySql_EntityFrameworkCore"] (40s 927ms) link
✓ 1. GIVEN The Database IsCreated [provider: "MySql_EntityFrameworkCore"] (26s 455ms)
✕ 2. CRUD Tbl DATETIME Table [nr: "20"] (10s 570ms)
Details:
Step 2: Xunit.Sdk.XunitException : Expected verify!.DataColumn to be <2023-12-13 21:45:39.6089917>, but found <2023-12-13 21:45:39.608991>.
at FluentAssertions.Execution.XUnit2TestFramework.Throw(String message)
at FluentAssertions.Execution.TestFrameworkProvider.Throw(String message)
at FluentAssertions.Execution.DefaultAssertionStrategy.HandleFailure(String message)
at FluentAssertions.Execution.AssertionScope.FailWith(Func`1 failReasonFunc)
at FluentAssertions.Execution.AssertionScope.FailWith(Func`1 failReasonFunc)
at FluentAssertions.Execution.AssertionScope.FailWith(String message, Object[] args)
at FluentAssertions.Primitives.DateTimeAssertions`1.Be(Nullable`1 expected, String because, Object[] becauseArgs)
at TestEFCoreProviders.NotWorkingDateTime.CRUD_Tbl_DATETIME_Table(Int32 nr) in C:\gth\TestEFCoreDatabaseProviders\src\TestEFCoreProviders\TestEFCoreProviders\TestsNotWorking.Steps.cs:line 67Comments:
// Step 1: connection : server=127.0.0.1;port=3306;database=testcac84759fc56464084541e312aaa9f3b;user id=root;password=mysql;persistsecurityinfo=True// Step 1: before created// Step 1: after createdCrudMultipleSimpleTable [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (3s 504ms) link
✓ 1. GIVEN The Database IsCreated [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (2s 967ms)
✕ 2. CRUD Tbl DATETIME Table [nr: "20"] (37ms)
Details:
Step 2: Microsoft.EntityFrameworkCore.DbUpdateException : An error occurred while saving the entity changes. See the inner exception for details.
---> System.InvalidCastException : Cannot write DateTime with Kind=Local to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)Comments:
// Step 1: connection : Host=127.0.0.1;Port=51680;Database=test2abc130ef10949c5ad242826fe740566;Username=postgres;Password=postgres;Persist Security Info=True// Step 1: before created// Step 1: after createdCrudMultipleSimpleTable [provider: "Pomelo_EntityFrameworkCore_MySql"] (35s 660ms) link
✓ 1. GIVEN The Database IsCreated [provider: "Pomelo_EntityFrameworkCore_MySql"] (21s 488ms)
✓ 2. CRUD Tbl DATETIME Table [nr: "20"] (10s 253ms)
Comments:
// Step 1: connection : Server=127.0.0.1;Port=3306;User ID=root;Password=mysql;Database=test69c21c5b82ab43158efc2d17bed4a38c;Persist Security Info=True// Step 1: after use mysql// Step 1: before created// Step 1: after created// Step 2: after use mysql// Step 2: after use mysql// Step 2: after use mysql// Step 2: after use mysql// Step 2: after use mysql// Step 2: after use mysql
Comments:
// Step 1: connection : testda0bfcdc6793415f8f2f90fddcb7d862// Step 1: before created// Step 1: after created