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