BulkCopy ignores IDataContext.CloseAfterUse option for SQL Server #4257

        public class Test
        {
            public int Id { get; set; }
            public string Name { get; set; }
        }

        internal class Context : DataConnection
        {
            public const string ConnString = "...connection string...";

            static Context()
            {
                SqlServerTools.Provider = SqlServerProvider.SystemDataSqlClient;
            }

            public Context() : base(LinqToDB.ProviderName.SqlServer2012, ConnString)
            {
                (this as IDataContext).CloseAfterUse = true; // Very vital for us
            }
        }

            using var scope = new TransactionScope();

            using var ctx = new Context();

            var t = new List<Test>() { new Test { Id = 55, Name = "test" }, new Test { Id = 355, Name = "ewrwe" } };

            ctx.BulkCopy(t);
            //ctx.Close(); // this is workaround
            var conn = new SqlConnection(Context.ConnString);

            conn.Open(); // got error here

            var cmd = new SqlCommand("select 1", conn);
            cmd.ExecuteNonQuery();