C#

Stream memoryStream = new MemoryStream();
...
memoryStream.Flush() - does nothing
memoryStream.SetLength(0) - calls AccessViolationException ("memory is corrupt")

_sqlConnection = new SqlConnection(Settings.ConnectionString);

private static SqlConnection _sqlConnection = null;

private static string _connectionString = string.Empty;
        public static string ConnectionString
        {
            get
            {
                Configuration config = ConfigurationManager.OpenExeConfiguration(Settings.AppName);
                _connectionString = EncryptDecrypt.Decrypt(config.ConnectionStrings.ConnectionStrings["ConnectionString"].ToString(),Settings.EncPassword);
                return _connectionString;
            }
        }