Tests.SqlServerDataSourceTests.SqlServerDataSourceTests_XactAbortAsync C# (CSharp) Method

        public async Task SqlServerDataSourceTests_XactAbortAsync()
        {
            const string sql = @"DECLARE @Option bit  = 0;
IF ( (16384 & @@OPTIONS) = 16384 ) SET @Option = 1;
SELECT @Option AS [Option];";


            var dataSource = SqlServerDataSource.CreateFromConfig("SqlServerTestDatabase").WithSettings(new SqlServerDataSourceSettings() { XactAbort = true }); ;
            var settingOnA = await dataSource.Sql(sql).ToBoolean().ExecuteAsync();
            var settingOnB = await dataSource.GetEffectiveSettingsAsync();
            Assert.IsTrue(settingOnA, "XACT_ABORT should have been turned on.");
            Assert.IsTrue(settingOnB.XactAbort, "XACT_ABORT should have been turned on in effective settings.");

            dataSource = dataSource.WithSettings(new SqlServerDataSourceSettings() { XactAbort = false }); ;
            var settingOffA = await dataSource.Sql(sql).ToBoolean().ExecuteAsync();
            var settingOffB = await dataSource.GetEffectiveSettingsAsync();
            Assert.IsFalse(settingOffA, "XACT_ABORT should have been turned off.");
            Assert.IsFalse(settingOffB.XactAbort, "XACT_ABORT should have been turned off in effective settings.");
        }