Test execution summary

Execution
Overall status:Passed
Start date:2023-09-04 (UTC)
Start time:18:37:27
End time:18:42:00
Duration:4m 33s
Content
Features:2
Scenarios:18
Passed scenarios:18

Feature summary

FeatureScenariosPassedBypassedFailedIgnoredStepsPassedBypassedFailedIgnoredNot RunDurationAggregatedAverage
TestSimpleTablesMultipleData66000363600002m 23s2m 23s23s 968ms
TestSingleTable121200012612600002m 09s2m 09s10s 771ms
Totals181800016216200004m 33s4m 33s15s 170ms

Feature details link

Toggle:
Filter:
filtered link

TestSimpleTablesMultipleData link

CrudMultipleSimpleTable [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (11s 208ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (56ms)
✓ 2. CRUD Tbl BIGINT Table [nr: "20"] (92ms)
✓ 3. CRUD Tbl DATETIME Table [nr: "20"] (10s 033ms)
✓ 4. WHEN Search For Date "09/04/2023 18:34:50" That Is Criteria "Greater" Than nr the results number are "19" [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (8ms)
✓ 5. AND Search For Date "09/04/2023 18:44:50" That Is Criteria "Greater" Than nr the results number are "0" [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (<1ms)
✓ 6. Finish (1s 003ms)

Comments:

// Step 1: tables Tbl_BIGINT,Tbl_BINARY,Tbl_BIT,Tbl_CHAR,Tbl_DATE,Tbl_DATETIME,Tbl_DATETIME2,Tbl_DATETIMEOFFSET,Tbl_DECIMAL,Tbl_FLOAT,Tbl_GEOGRAPHY,Tbl_GEOMETRY,Tbl_HIERARCHYID,Tbl_IMAGE,Tbl_INT,Tbl_JSON,Tbl_MONEY,Tbl_NCHAR,Tbl_NTEXT,Tbl_NVARCHAR,Tbl_REAL,Tbl_SMALLDATETIME,Tbl_SMALLINT,Tbl_TEXT,Tbl_TIME,Tbl_TINYINT,Tbl_UNIQUEIDENTIFIER,Tbl_VARBINARY,Tbl_VARCHAR,Tbl_XML
// Step 1: table Tbl_BIGINT
// Step 1: column => int ID
// Step 1: column => long? DataColumn
// Step 1: table Tbl_BINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_BIT
// Step 1: column => int ID
// Step 1: column => bool? DataColumn
// Step 1: table Tbl_CHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_DATE
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME2
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIMEOFFSET
// Step 1: column => int ID
// Step 1: column => DateTimeOffset? DataColumn
// Step 1: table Tbl_DECIMAL
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_FLOAT
// Step 1: column => int ID
// Step 1: column => double? DataColumn
// Step 1: table Tbl_GEOGRAPHY
// Step 1: column => int ID
// Step 1: table Tbl_GEOMETRY
// Step 1: column => int ID
// Step 1: table Tbl_HIERARCHYID
// Step 1: column => int ID
// Step 1: table Tbl_IMAGE
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_INT
// Step 1: column => int ID
// Step 1: column => int? DataColumn
// Step 1: table Tbl_JSON
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_MONEY
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_NCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NTEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NVARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_REAL
// Step 1: column => int ID
// Step 1: column => float? DataColumn
// Step 1: table Tbl_SMALLDATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_SMALLINT
// Step 1: column => int ID
// Step 1: column => short? DataColumn
// Step 1: table Tbl_TEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_TIME
// Step 1: column => int ID
// Step 1: column => TimeSpan? DataColumn
// Step 1: table Tbl_TINYINT
// Step 1: column => int ID
// Step 1: column => byte? DataColumn
// Step 1: table Tbl_UNIQUEIDENTIFIER
// Step 1: column => int ID
// Step 1: column => Guid? DataColumn
// Step 1: table Tbl_VARBINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_VARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_XML
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: connection : test33c6821d651e4586bd27630adf2a4cd6
// Step 1: before created
// Step 1: after created

CrudMultipleSimpleTable [provider: "Microsoft_EntityFrameworkCore_Sqlite_File"] (11s 328ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_Sqlite_File"] (137ms)
✓ 2. CRUD Tbl BIGINT Table [nr: "20"] (112ms)
✓ 3. CRUD Tbl DATETIME Table [nr: "20"] (10s 049ms)
✓ 4. WHEN Search For Date "09/04/2023 18:33:20" That Is Criteria "Greater" Than nr the results number are "19" [provider: "Microsoft_EntityFrameworkCore_Sqlite_File"] (5ms)
✓ 5. AND Search For Date "09/04/2023 18:43:20" That Is Criteria "Greater" Than nr the results number are "0" [provider: "Microsoft_EntityFrameworkCore_Sqlite_File"] (1ms)
✓ 6. Finish (1s 005ms)

Comments:

// Step 1: tables Tbl_BIGINT,Tbl_BINARY,Tbl_BIT,Tbl_CHAR,Tbl_DATE,Tbl_DATETIME,Tbl_DATETIME2,Tbl_DATETIMEOFFSET,Tbl_DECIMAL,Tbl_FLOAT,Tbl_GEOGRAPHY,Tbl_GEOMETRY,Tbl_HIERARCHYID,Tbl_IMAGE,Tbl_INT,Tbl_JSON,Tbl_MONEY,Tbl_NCHAR,Tbl_NTEXT,Tbl_NVARCHAR,Tbl_REAL,Tbl_SMALLDATETIME,Tbl_SMALLINT,Tbl_TEXT,Tbl_TIME,Tbl_TINYINT,Tbl_UNIQUEIDENTIFIER,Tbl_VARBINARY,Tbl_VARCHAR,Tbl_XML
// Step 1: table Tbl_BIGINT
// Step 1: column => int ID
// Step 1: column => long? DataColumn
// Step 1: table Tbl_BINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_BIT
// Step 1: column => int ID
// Step 1: column => bool? DataColumn
// Step 1: table Tbl_CHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_DATE
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME2
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIMEOFFSET
// Step 1: column => int ID
// Step 1: column => DateTimeOffset? DataColumn
// Step 1: table Tbl_DECIMAL
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_FLOAT
// Step 1: column => int ID
// Step 1: column => double? DataColumn
// Step 1: table Tbl_GEOGRAPHY
// Step 1: column => int ID
// Step 1: table Tbl_GEOMETRY
// Step 1: column => int ID
// Step 1: table Tbl_HIERARCHYID
// Step 1: column => int ID
// Step 1: table Tbl_IMAGE
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_INT
// Step 1: column => int ID
// Step 1: column => int? DataColumn
// Step 1: table Tbl_JSON
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_MONEY
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_NCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NTEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NVARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_REAL
// Step 1: column => int ID
// Step 1: column => float? DataColumn
// Step 1: table Tbl_SMALLDATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_SMALLINT
// Step 1: column => int ID
// Step 1: column => short? DataColumn
// Step 1: table Tbl_TEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_TIME
// Step 1: column => int ID
// Step 1: column => TimeSpan? DataColumn
// Step 1: table Tbl_TINYINT
// Step 1: column => int ID
// Step 1: column => byte? DataColumn
// Step 1: table Tbl_UNIQUEIDENTIFIER
// Step 1: column => int ID
// Step 1: column => Guid? DataColumn
// Step 1: table Tbl_VARBINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_VARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_XML
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: connection : Data Source=test7552a54fd4044018a40e2b98f6fdd8a8.db
// Step 1: before created
// Step 1: after created

CrudMultipleSimpleTable [provider: "Microsoft_EntityFrameworkCore_SqlServer"] (26s 708ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_SqlServer"] (14s 363ms)
✓ 2. CRUD Tbl BIGINT Table [nr: "20"] (181ms)
✓ 3. CRUD Tbl DATETIME Table [nr: "20"] (10s 081ms)
✓ 4. WHEN Search For Date "09/04/2023 18:34:38" That Is Criteria "Greater" Than nr the results number are "19" [provider: "Microsoft_EntityFrameworkCore_SqlServer"] (12ms)
✓ 5. AND Search For Date "09/04/2023 18:44:38" That Is Criteria "Greater" Than nr the results number are "0" [provider: "Microsoft_EntityFrameworkCore_SqlServer"] (2ms)
✓ 6. Finish (1s 011ms)

Comments:

// Step 1: tables Tbl_BIGINT,Tbl_BINARY,Tbl_BIT,Tbl_CHAR,Tbl_DATE,Tbl_DATETIME,Tbl_DATETIME2,Tbl_DATETIMEOFFSET,Tbl_DECIMAL,Tbl_FLOAT,Tbl_GEOGRAPHY,Tbl_GEOMETRY,Tbl_HIERARCHYID,Tbl_IMAGE,Tbl_INT,Tbl_JSON,Tbl_MONEY,Tbl_NCHAR,Tbl_NTEXT,Tbl_NVARCHAR,Tbl_REAL,Tbl_SMALLDATETIME,Tbl_SMALLINT,Tbl_TEXT,Tbl_TIME,Tbl_TINYINT,Tbl_UNIQUEIDENTIFIER,Tbl_VARBINARY,Tbl_VARCHAR,Tbl_XML
// Step 1: table Tbl_BIGINT
// Step 1: column => int ID
// Step 1: column => long? DataColumn
// Step 1: table Tbl_BINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_BIT
// Step 1: column => int ID
// Step 1: column => bool? DataColumn
// Step 1: table Tbl_CHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_DATE
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME2
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIMEOFFSET
// Step 1: column => int ID
// Step 1: column => DateTimeOffset? DataColumn
// Step 1: table Tbl_DECIMAL
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_FLOAT
// Step 1: column => int ID
// Step 1: column => double? DataColumn
// Step 1: table Tbl_GEOGRAPHY
// Step 1: column => int ID
// Step 1: table Tbl_GEOMETRY
// Step 1: column => int ID
// Step 1: table Tbl_HIERARCHYID
// Step 1: column => int ID
// Step 1: table Tbl_IMAGE
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_INT
// Step 1: column => int ID
// Step 1: column => int? DataColumn
// Step 1: table Tbl_JSON
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_MONEY
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_NCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NTEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NVARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_REAL
// Step 1: column => int ID
// Step 1: column => float? DataColumn
// Step 1: table Tbl_SMALLDATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_SMALLINT
// Step 1: column => int ID
// Step 1: column => short? DataColumn
// Step 1: table Tbl_TEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_TIME
// Step 1: column => int ID
// Step 1: column => TimeSpan? DataColumn
// Step 1: table Tbl_TINYINT
// Step 1: column => int ID
// Step 1: column => byte? DataColumn
// Step 1: table Tbl_UNIQUEIDENTIFIER
// Step 1: column => int ID
// Step 1: column => Guid? DataColumn
// Step 1: table Tbl_VARBINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_VARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_XML
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: connection : Data Source=127.0.0.1,1433;Initial Catalog=test2f0d174e32dd403997597facba05359a;Persist Security Info=True;User ID=sa;Password=<YourStrong@Passw0rd>;TrustServerCertificate=True
// Step 1: before created
// Step 1: after created

CrudMultipleSimpleTable [provider: "MySql_EntityFrameworkCore"] (37s 455ms) link

✓ 1. GIVEN The Database IsCreated [provider: "MySql_EntityFrameworkCore"] (22s 949ms)
✓ 2. CRUD Tbl BIGINT Table [nr: "20"] (162ms)
✓ 3. CRUD Tbl DATETIME Table [nr: "20"] (10s 092ms)
✓ 4. WHEN Search For Date "09/04/2023 18:34:09" That Is Criteria "Greater" Than nr the results number are "19" [provider: "MySql_EntityFrameworkCore"] (7ms)
✓ 5. AND Search For Date "09/04/2023 18:44:09" That Is Criteria "Greater" Than nr the results number are "0" [provider: "MySql_EntityFrameworkCore"] (4ms)
✓ 6. Finish (1s 003ms)

Comments:

// Step 1: tables Tbl_BIGINT,Tbl_BINARY,Tbl_BIT,Tbl_CHAR,Tbl_DATE,Tbl_DATETIME,Tbl_DATETIME2,Tbl_DATETIMEOFFSET,Tbl_DECIMAL,Tbl_FLOAT,Tbl_GEOGRAPHY,Tbl_GEOMETRY,Tbl_HIERARCHYID,Tbl_IMAGE,Tbl_INT,Tbl_JSON,Tbl_MONEY,Tbl_NCHAR,Tbl_NTEXT,Tbl_NVARCHAR,Tbl_REAL,Tbl_SMALLDATETIME,Tbl_SMALLINT,Tbl_TEXT,Tbl_TIME,Tbl_TINYINT,Tbl_UNIQUEIDENTIFIER,Tbl_VARBINARY,Tbl_VARCHAR,Tbl_XML
// Step 1: table Tbl_BIGINT
// Step 1: column => int ID
// Step 1: column => long? DataColumn
// Step 1: table Tbl_BINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_BIT
// Step 1: column => int ID
// Step 1: column => bool? DataColumn
// Step 1: table Tbl_CHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_DATE
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME2
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIMEOFFSET
// Step 1: column => int ID
// Step 1: column => DateTimeOffset? DataColumn
// Step 1: table Tbl_DECIMAL
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_FLOAT
// Step 1: column => int ID
// Step 1: column => double? DataColumn
// Step 1: table Tbl_GEOGRAPHY
// Step 1: column => int ID
// Step 1: table Tbl_GEOMETRY
// Step 1: column => int ID
// Step 1: table Tbl_HIERARCHYID
// Step 1: column => int ID
// Step 1: table Tbl_IMAGE
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_INT
// Step 1: column => int ID
// Step 1: column => int? DataColumn
// Step 1: table Tbl_JSON
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_MONEY
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_NCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NTEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NVARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_REAL
// Step 1: column => int ID
// Step 1: column => float? DataColumn
// Step 1: table Tbl_SMALLDATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_SMALLINT
// Step 1: column => int ID
// Step 1: column => short? DataColumn
// Step 1: table Tbl_TEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_TIME
// Step 1: column => int ID
// Step 1: column => TimeSpan? DataColumn
// Step 1: table Tbl_TINYINT
// Step 1: column => int ID
// Step 1: column => byte? DataColumn
// Step 1: table Tbl_UNIQUEIDENTIFIER
// Step 1: column => int ID
// Step 1: column => Guid? DataColumn
// Step 1: table Tbl_VARBINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_VARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_XML
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: connection : server=127.0.0.1;port=3306;database=test49b11e8ee9a04a719113a28226de2d93;user id=root;password=mysql;persistsecurityinfo=True
// Step 1: before created
// Step 1: after created

CrudMultipleSimpleTable [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (14s 669ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (2s 945ms)
✓ 2. CRUD Tbl BIGINT Table [nr: "20"] (142ms)
✓ 3. CRUD Tbl DATETIME Table [nr: "20"] (10s 070ms)
✓ 4. WHEN Search For Date "09/04/2023 18:33:34" That Is Criteria "Greater" Than nr the results number are "19" [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (<1ms)
✓ 5. AND Search For Date "09/04/2023 18:43:34" That Is Criteria "Greater" Than nr the results number are "0" [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (<1ms)
✓ 6. Finish (1s 004ms)

Comments:

// Step 1: tables Tbl_BIGINT,Tbl_BINARY,Tbl_BIT,Tbl_CHAR,Tbl_DATE,Tbl_DATETIME,Tbl_DATETIME2,Tbl_DATETIMEOFFSET,Tbl_DECIMAL,Tbl_FLOAT,Tbl_GEOGRAPHY,Tbl_GEOMETRY,Tbl_HIERARCHYID,Tbl_IMAGE,Tbl_INT,Tbl_JSON,Tbl_MONEY,Tbl_NCHAR,Tbl_NTEXT,Tbl_NVARCHAR,Tbl_REAL,Tbl_SMALLDATETIME,Tbl_SMALLINT,Tbl_TEXT,Tbl_TIME,Tbl_TINYINT,Tbl_UNIQUEIDENTIFIER,Tbl_VARBINARY,Tbl_VARCHAR,Tbl_XML
// Step 1: table Tbl_BIGINT
// Step 1: column => int ID
// Step 1: column => long? DataColumn
// Step 1: table Tbl_BINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_BIT
// Step 1: column => int ID
// Step 1: column => bool? DataColumn
// Step 1: table Tbl_CHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_DATE
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME2
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIMEOFFSET
// Step 1: column => int ID
// Step 1: column => DateTimeOffset? DataColumn
// Step 1: table Tbl_DECIMAL
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_FLOAT
// Step 1: column => int ID
// Step 1: column => double? DataColumn
// Step 1: table Tbl_GEOGRAPHY
// Step 1: column => int ID
// Step 1: table Tbl_GEOMETRY
// Step 1: column => int ID
// Step 1: table Tbl_HIERARCHYID
// Step 1: column => int ID
// Step 1: table Tbl_IMAGE
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_INT
// Step 1: column => int ID
// Step 1: column => int? DataColumn
// Step 1: table Tbl_JSON
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_MONEY
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_NCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NTEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NVARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_REAL
// Step 1: column => int ID
// Step 1: column => float? DataColumn
// Step 1: table Tbl_SMALLDATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_SMALLINT
// Step 1: column => int ID
// Step 1: column => short? DataColumn
// Step 1: table Tbl_TEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_TIME
// Step 1: column => int ID
// Step 1: column => TimeSpan? DataColumn
// Step 1: table Tbl_TINYINT
// Step 1: column => int ID
// Step 1: column => byte? DataColumn
// Step 1: table Tbl_UNIQUEIDENTIFIER
// Step 1: column => int ID
// Step 1: column => Guid? DataColumn
// Step 1: table Tbl_VARBINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_VARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_XML
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: connection : Host=127.0.0.1;Port=51533;Database=test3d08b73a0283484eb4f89c664d1e26cd;Username=postgres;Password=postgres;Persist Security Info=True
// Step 1: before created
// Step 1: after created
// Step 4: for datetime must use UTC in search also
// Step 5: for datetime must use UTC in search also

CrudMultipleSimpleTable [provider: "Pomelo_EntityFrameworkCore_MySql"] (42s 439ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Pomelo_EntityFrameworkCore_MySql"] (27s 532ms)
✓ 2. CRUD Tbl BIGINT Table [nr: "20"] (561ms)
✓ 3. CRUD Tbl DATETIME Table [nr: "20"] (10s 128ms)
✓ 4. WHEN Search For Date "09/04/2023 18:33:06" That Is Criteria "Greater" Than nr the results number are "19" [provider: "Pomelo_EntityFrameworkCore_MySql"] (25ms)
✓ 5. AND Search For Date "09/04/2023 18:43:06" That Is Criteria "Greater" Than nr the results number are "0" [provider: "Pomelo_EntityFrameworkCore_MySql"] (4ms)
✓ 6. Finish (1s 004ms)

Comments:

// Step 1: tables Tbl_BIGINT,Tbl_BINARY,Tbl_BIT,Tbl_CHAR,Tbl_DATE,Tbl_DATETIME,Tbl_DATETIME2,Tbl_DATETIMEOFFSET,Tbl_DECIMAL,Tbl_FLOAT,Tbl_GEOGRAPHY,Tbl_GEOMETRY,Tbl_HIERARCHYID,Tbl_IMAGE,Tbl_INT,Tbl_JSON,Tbl_MONEY,Tbl_NCHAR,Tbl_NTEXT,Tbl_NVARCHAR,Tbl_REAL,Tbl_SMALLDATETIME,Tbl_SMALLINT,Tbl_TEXT,Tbl_TIME,Tbl_TINYINT,Tbl_UNIQUEIDENTIFIER,Tbl_VARBINARY,Tbl_VARCHAR,Tbl_XML
// Step 1: table Tbl_BIGINT
// Step 1: column => int ID
// Step 1: column => long? DataColumn
// Step 1: table Tbl_BINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_BIT
// Step 1: column => int ID
// Step 1: column => bool? DataColumn
// Step 1: table Tbl_CHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_DATE
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIME2
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_DATETIMEOFFSET
// Step 1: column => int ID
// Step 1: column => DateTimeOffset? DataColumn
// Step 1: table Tbl_DECIMAL
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_FLOAT
// Step 1: column => int ID
// Step 1: column => double? DataColumn
// Step 1: table Tbl_GEOGRAPHY
// Step 1: column => int ID
// Step 1: table Tbl_GEOMETRY
// Step 1: column => int ID
// Step 1: table Tbl_HIERARCHYID
// Step 1: column => int ID
// Step 1: table Tbl_IMAGE
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_INT
// Step 1: column => int ID
// Step 1: column => int? DataColumn
// Step 1: table Tbl_JSON
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_MONEY
// Step 1: column => int ID
// Step 1: column => decimal? DataColumn
// Step 1: table Tbl_NCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NTEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_NVARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_REAL
// Step 1: column => int ID
// Step 1: column => float? DataColumn
// Step 1: table Tbl_SMALLDATETIME
// Step 1: column => int ID
// Step 1: column => DateTime? DataColumn
// Step 1: table Tbl_SMALLINT
// Step 1: column => int ID
// Step 1: column => short? DataColumn
// Step 1: table Tbl_TEXT
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_TIME
// Step 1: column => int ID
// Step 1: column => TimeSpan? DataColumn
// Step 1: table Tbl_TINYINT
// Step 1: column => int ID
// Step 1: column => byte? DataColumn
// Step 1: table Tbl_UNIQUEIDENTIFIER
// Step 1: column => int ID
// Step 1: column => Guid? DataColumn
// Step 1: table Tbl_VARBINARY
// Step 1: column => int ID
// Step 1: column => byte[] DataColumn
// Step 1: table Tbl_VARCHAR
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: table Tbl_XML
// Step 1: column => int ID
// Step 1: column => string DataColumn
// Step 1: connection : Server=127.0.0.1;Port=3306;User ID=root;Password=mysql;Database=teste2c4b4f552f24dbea9b6a2c983aeaf5d;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
// Step 3: after use mysql
// Step 3: after use mysql
// Step 3: after use mysql
// Step 3: after use mysql
// Step 4: after use mysql
// Step 5: after use mysql

TestSingleTable link

CrudSimpleTable [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (23ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (6ms)
✓ 2. THEN Number Of Dep Are Nr "0" (1ms)
✓ 3. WHEN Creating Nr "5" Departments (<1ms)
✓ 4. THEN Number Of Dep Are Nr "5" (<1ms)
✓ 5. WHEN Deleting Department With id "2" (4ms)
✓ 6. THEN Number Of Dep Are Nr "4" (<1ms)
✓ 7. WHEN Modify Department With id "4" and name "8261956323cd44f68244946438b560b2" (<1ms)
✓ 8. THEN For id "4" has name "8261956323cd44f68244946438b560b2" (<1ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : testdc512d31a3cd4fcd84347a173956cb25
// Step 1: before created
// Step 1: after created

CrudSimpleTable [provider: "Microsoft_EntityFrameworkCore_Sqlite_File"] (68ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_Sqlite_File"] (24ms)
✓ 2. THEN Number Of Dep Are Nr "0" (3ms)
✓ 3. WHEN Creating Nr "5" Departments (8ms)
✓ 4. THEN Number Of Dep Are Nr "5" (1ms)
✓ 5. WHEN Deleting Department With id "2" (10ms)
✓ 6. THEN Number Of Dep Are Nr "4" (1ms)
✓ 7. WHEN Modify Department With id "4" and name "ccb34f7ee3c94428bc8c7e9516500be6" (8ms)
✓ 8. THEN For id "4" has name "ccb34f7ee3c94428bc8c7e9516500be6" (2ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : Data Source=testdd675b34464b4fe59cee46a6b3fd2016.db
// Step 1: before created
// Step 1: after created

CrudSimpleTable [provider: "Microsoft_EntityFrameworkCore_SqlServer"] (12s 585ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_SqlServer"] (11s 484ms)
✓ 2. THEN Number Of Dep Are Nr "0" (52ms)
✓ 3. WHEN Creating Nr "5" Departments (19ms)
✓ 4. THEN Number Of Dep Are Nr "5" (2ms)
✓ 5. WHEN Deleting Department With id "2" (21ms)
✓ 6. THEN Number Of Dep Are Nr "4" (2ms)
✓ 7. WHEN Modify Department With id "4" and name "1bb1733038c54cfdb80fc592d9f9e228" (8ms)
✓ 8. THEN For id "4" has name "1bb1733038c54cfdb80fc592d9f9e228" (1ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : Data Source=127.0.0.1,1433;Initial Catalog=test538198034ffb47249c85495a4e4cc810;Persist Security Info=True;User ID=sa;Password=<YourStrong@Passw0rd>;TrustServerCertificate=True
// Step 1: before created
// Step 1: after created

CrudSimpleTable [provider: "MySql_EntityFrameworkCore"] (23s 893ms) link

✓ 1. GIVEN The Database IsCreated [provider: "MySql_EntityFrameworkCore"] (19s 904ms)
✓ 2. THEN Number Of Dep Are Nr "0" (13ms)
✓ 3. WHEN Creating Nr "5" Departments (23ms)
✓ 4. THEN Number Of Dep Are Nr "5" (6ms)
✓ 5. WHEN Deleting Department With id "2" (23ms)
✓ 6. THEN Number Of Dep Are Nr "4" (4ms)
✓ 7. WHEN Modify Department With id "4" and name "c012d895c2104ba1985c4277b4b185df" (13ms)
✓ 8. THEN For id "4" has name "c012d895c2104ba1985c4277b4b185df" (7ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : server=127.0.0.1;port=3306;database=test924c4ca60f7d41f78af0cf9df4640877;user id=root;password=mysql;persistsecurityinfo=True
// Step 1: before created
// Step 1: after created

CrudSimpleTable [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (3s 232ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (2s 772ms)
✓ 2. THEN Number Of Dep Are Nr "0" (4ms)
✓ 3. WHEN Creating Nr "5" Departments (3ms)
✓ 4. THEN Number Of Dep Are Nr "5" (1ms)
✓ 5. WHEN Deleting Department With id "2" (5ms)
✓ 6. THEN Number Of Dep Are Nr "4" (1ms)
✓ 7. WHEN Modify Department With id "4" and name "5c5c7ad1471b4df580242609c2424cb4" (1ms)
✓ 8. THEN For id "4" has name "5c5c7ad1471b4df580242609c2424cb4" (1ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : Host=127.0.0.1;Port=51600;Database=test753a8dee52da4d0ab1c5b60836199870;Username=postgres;Password=postgres;Persist Security Info=True
// Step 1: before created
// Step 1: after created

CrudSimpleTable [provider: "Pomelo_EntityFrameworkCore_MySql"] (26s 038ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Pomelo_EntityFrameworkCore_MySql"] (22s 269ms)
✓ 2. THEN Number Of Dep Are Nr "0" (9ms)
✓ 3. WHEN Creating Nr "5" Departments (36ms)
✓ 4. THEN Number Of Dep Are Nr "5" (7ms)
✓ 5. WHEN Deleting Department With id "2" (22ms)
✓ 6. THEN Number Of Dep Are Nr "4" (5ms)
✓ 7. WHEN Modify Department With id "4" and name "75edbd6ac4af479dada3861e1add5af3" (15ms)
✓ 8. THEN For id "4" has name "75edbd6ac4af479dada3861e1add5af3" (3ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : Server=127.0.0.1;Port=3306;User ID=root;Password=mysql;Database=testd5c01788a9724643a6942003802d445c;Persist Security Info=True
// Step 1: after use mysql
// Step 1: before created
// Step 1: after created
// Step 2: after use mysql
// Step 3: after use mysql
// Step 4: after use mysql
// Step 5: after use mysql
// Step 6: after use mysql
// Step 7: after use mysql
// Step 8: after use mysql

SearchSimpleTable [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (87ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_In_Memory"] (3ms)
✓ 2. WHEN Creating Nr "22" Departments (8ms)
✓ 3. AND Search For id1 "21" and id2 "20" is success (10ms)
✓ 4. AND Search For Id That Is Criteria "Different" Than nr "1" the results number are "21" (4ms)
✓ 5. AND Search For Id That Is Criteria "Different" Than nr "122" the results number are "22" (14ms)
✓ 6. AND Search For Id That Is Criteria "GreaterOrEqual" Than nr "1" the results number are "22" (4ms)
✓ 7. AND Search For Id That Is Criteria "Greater" Than nr "1" the results number are "21" (4ms)
✓ 8. AND Search For Id That Is Criteria "Less" Than nr "1" the results number are "0" (3ms)
✓ 9. AND Search For Id That Is Criteria "LessOrEqual" Than nr "1" the results number are "1" (4ms)
✓ 10. AND Search For Name That Is Criteria "StartsWith" For searchString "An" the results number are "22" (5ms)
✓ 11. AND Search For Name That Is Criteria "StartsWith" For searchString "XAn" the results number are "0" (<1ms)
✓ 12. AND Search For Name That Is Criteria "StartsWith" For searchString "Andrei 1" the results number are "11" (<1ms)
✓ 13. AND Search For Name That Is Criteria "EndsWith" For searchString "11" the results number are "1" (5ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : testc12a36c6837844ab8a916a4084357495
// Step 1: before created
// Step 1: after created

SearchSimpleTable [provider: "Microsoft_EntityFrameworkCore_Sqlite_File"] (169ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_Sqlite_File"] (51ms)
✓ 2. WHEN Creating Nr "22" Departments (37ms)
✓ 3. AND Search For id1 "21" and id2 "20" is success (32ms)
✓ 4. AND Search For Id That Is Criteria "Different" Than nr "1" the results number are "21" (3ms)
✓ 5. AND Search For Id That Is Criteria "Different" Than nr "122" the results number are "22" (<1ms)
✓ 6. AND Search For Id That Is Criteria "GreaterOrEqual" Than nr "1" the results number are "22" (2ms)
✓ 7. AND Search For Id That Is Criteria "Greater" Than nr "1" the results number are "21" (2ms)
✓ 8. AND Search For Id That Is Criteria "Less" Than nr "1" the results number are "0" (2ms)
✓ 9. AND Search For Id That Is Criteria "LessOrEqual" Than nr "1" the results number are "1" (2ms)
✓ 10. AND Search For Name That Is Criteria "StartsWith" For searchString "An" the results number are "22" (10ms)
✓ 11. AND Search For Name That Is Criteria "StartsWith" For searchString "XAn" the results number are "0" (1ms)
✓ 12. AND Search For Name That Is Criteria "StartsWith" For searchString "Andrei 1" the results number are "11" (<1ms)
✓ 13. AND Search For Name That Is Criteria "EndsWith" For searchString "11" the results number are "1" (3ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : Data Source=test1ea62695bd88459facdfa4b2eee10d65.db
// Step 1: before created
// Step 1: after created

SearchSimpleTable [provider: "Microsoft_EntityFrameworkCore_SqlServer"] (13s 368ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Microsoft_EntityFrameworkCore_SqlServer"] (11s 596ms)
✓ 2. WHEN Creating Nr "22" Departments (61ms)
✓ 3. AND Search For id1 "21" and id2 "20" is success (40ms)
✓ 4. AND Search For Id That Is Criteria "Different" Than nr "1" the results number are "21" (5ms)
✓ 5. AND Search For Id That Is Criteria "Different" Than nr "122" the results number are "22" (2ms)
✓ 6. AND Search For Id That Is Criteria "GreaterOrEqual" Than nr "1" the results number are "22" (6ms)
✓ 7. AND Search For Id That Is Criteria "Greater" Than nr "1" the results number are "21" (5ms)
✓ 8. AND Search For Id That Is Criteria "Less" Than nr "1" the results number are "0" (4ms)
✓ 9. AND Search For Id That Is Criteria "LessOrEqual" Than nr "1" the results number are "1" (4ms)
✓ 10. AND Search For Name That Is Criteria "StartsWith" For searchString "An" the results number are "22" (16ms)
✓ 11. AND Search For Name That Is Criteria "StartsWith" For searchString "XAn" the results number are "0" (10ms)
✓ 12. AND Search For Name That Is Criteria "StartsWith" For searchString "Andrei 1" the results number are "11" (3ms)
✓ 13. AND Search For Name That Is Criteria "EndsWith" For searchString "11" the results number are "1" (6ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : Data Source=127.0.0.1,1433;Initial Catalog=test50467a9afbc4487db96e7edbcad5b3bf;Persist Security Info=True;User ID=sa;Password=<YourStrong@Passw0rd>;TrustServerCertificate=True
// Step 1: before created
// Step 1: after created

SearchSimpleTable [provider: "MySql_EntityFrameworkCore"] (23s 305ms) link

✓ 1. GIVEN The Database IsCreated [provider: "MySql_EntityFrameworkCore"] (19s 785ms)
✓ 2. WHEN Creating Nr "22" Departments (50ms)
✓ 3. AND Search For id1 "21" and id2 "20" is success (18ms)
✓ 4. AND Search For Id That Is Criteria "Different" Than nr "1" the results number are "21" (6ms)
✓ 5. AND Search For Id That Is Criteria "Different" Than nr "122" the results number are "22" (4ms)
✓ 6. AND Search For Id That Is Criteria "GreaterOrEqual" Than nr "1" the results number are "22" (5ms)
✓ 7. AND Search For Id That Is Criteria "Greater" Than nr "1" the results number are "21" (5ms)
✓ 8. AND Search For Id That Is Criteria "Less" Than nr "1" the results number are "0" (5ms)
✓ 9. AND Search For Id That Is Criteria "LessOrEqual" Than nr "1" the results number are "1" (6ms)
✓ 10. AND Search For Name That Is Criteria "StartsWith" For searchString "An" the results number are "22" (9ms)
✓ 11. AND Search For Name That Is Criteria "StartsWith" For searchString "XAn" the results number are "0" (4ms)
✓ 12. AND Search For Name That Is Criteria "StartsWith" For searchString "Andrei 1" the results number are "11" (4ms)
✓ 13. AND Search For Name That Is Criteria "EndsWith" For searchString "11" the results number are "1" (7ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : server=127.0.0.1;port=3306;database=test6831a159b45e49a1af52cfeb19f72ed1;user id=root;password=mysql;persistsecurityinfo=True
// Step 1: before created
// Step 1: after created

SearchSimpleTable [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (3s 212ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Npgsql_EntityFrameworkCore_PostgreSQL"] (2s 661ms)
✓ 2. WHEN Creating Nr "22" Departments (14ms)
✓ 3. AND Search For id1 "21" and id2 "20" is success (17ms)
✓ 4. AND Search For Id That Is Criteria "Different" Than nr "1" the results number are "21" (3ms)
✓ 5. AND Search For Id That Is Criteria "Different" Than nr "122" the results number are "22" (1ms)
✓ 6. AND Search For Id That Is Criteria "GreaterOrEqual" Than nr "1" the results number are "22" (3ms)
✓ 7. AND Search For Id That Is Criteria "Greater" Than nr "1" the results number are "21" (4ms)
✓ 8. AND Search For Id That Is Criteria "Less" Than nr "1" the results number are "0" (4ms)
✓ 9. AND Search For Id That Is Criteria "LessOrEqual" Than nr "1" the results number are "1" (3ms)
✓ 10. AND Search For Name That Is Criteria "StartsWith" For searchString "An" the results number are "22" (28ms)
✓ 11. AND Search For Name That Is Criteria "StartsWith" For searchString "XAn" the results number are "0" (2ms)
✓ 12. AND Search For Name That Is Criteria "StartsWith" For searchString "Andrei 1" the results number are "11" (1ms)
✓ 13. AND Search For Name That Is Criteria "EndsWith" For searchString "11" the results number are "1" (3ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : Host=127.0.0.1;Port=51572;Database=test5b81f093c6fc4db781dc8ef9b3f31daa;Username=postgres;Password=postgres;Persist Security Info=True
// Step 1: before created
// Step 1: after created

SearchSimpleTable [provider: "Pomelo_EntityFrameworkCore_MySql"] (23s 268ms) link

✓ 1. GIVEN The Database IsCreated [provider: "Pomelo_EntityFrameworkCore_MySql"] (19s 788ms)
✓ 2. WHEN Creating Nr "22" Departments (35ms)
✓ 3. AND Search For id1 "21" and id2 "20" is success (21ms)
✓ 4. AND Search For Id That Is Criteria "Different" Than nr "1" the results number are "21" (6ms)
✓ 5. AND Search For Id That Is Criteria "Different" Than nr "122" the results number are "22" (3ms)
✓ 6. AND Search For Id That Is Criteria "GreaterOrEqual" Than nr "1" the results number are "22" (5ms)
✓ 7. AND Search For Id That Is Criteria "Greater" Than nr "1" the results number are "21" (5ms)
✓ 8. AND Search For Id That Is Criteria "Less" Than nr "1" the results number are "0" (5ms)
✓ 9. AND Search For Id That Is Criteria "LessOrEqual" Than nr "1" the results number are "1" (5ms)
✓ 10. AND Search For Name That Is Criteria "StartsWith" For searchString "An" the results number are "22" (8ms)
✓ 11. AND Search For Name That Is Criteria "StartsWith" For searchString "XAn" the results number are "0" (3ms)
✓ 12. AND Search For Name That Is Criteria "StartsWith" For searchString "Andrei 1" the results number are "11" (3ms)
✓ 13. AND Search For Name That Is Criteria "EndsWith" For searchString "11" the results number are "1" (6ms)

Comments:

// Step 1: tables Department
// Step 1: table Department
// Step 1: column => long IDDepartment
// Step 1: column => string Name
// Step 1: connection : Server=127.0.0.1;Port=3306;User ID=root;Password=mysql;Database=test3340ac39409c4f75a6173c32ca05cb80;Persist Security Info=True
// Step 1: after use mysql
// Step 1: before created
// Step 1: after created
// Step 2: after use mysql
// Step 3: after use mysql
// Step 4: after use mysql
// Step 5: after use mysql
// Step 6: after use mysql
// Step 7: after use mysql
// Step 8: after use mysql
// Step 9: after use mysql
// Step 10: after use mysql
// Step 11: after use mysql
// Step 12: after use mysql
// Step 13: after use mysql