/// <summary> /// Get transaction /// </summary> /// <param name="bulk"></param> /// <returns></returns> public static SqlTransaction GetTransaction(this SqlBulkCopy bulk) { bulk.CheckNull(nameof(bulk)); var type = bulk.GetType(); var field = type.GetField("_externalTransaction", BindingFlags.NonPublic | BindingFlags.Instance); return(field?.GetValue(bulk) as SqlTransaction); }