ADOUtils.Tests.DatabaseTest.BasicOperation.Should_put_raw_command_in_transaction C# (CSharp) Method

        public void Should_put_raw_command_in_transaction()
        {
            using(_target.BeginTransaction())
            {
                using(ICommand cmd = _target.CreateCommand())
                {
                    var sqlCmd = (SqlCommand)cmd.DbCommand;
                    sqlCmd.CommandText = "INSERT INTO Tbl(IntValue) VALUES(123)";
                    sqlCmd.ExecuteNonQuery();
                }
            }

            _target.Scalar<int>("SELECT COUNT(*) FROM Tbl WHERE IntValue = 123").Should().Be.EqualTo(0);
        }