Storage for connection strings. Demonstrates the usage of SPPersistedObject and utilizes the method UpdateSecureStringValue

SecuredConnectionString.cs

    public class SecuredConnectionString : SPPersistedObject
    {
        public SecuredConnectionString()
        {
        }

        public SecuredConnectionString(string name)
            : base(name, SPFarm.Local)
        {
        }

        public void SetConnectionString(string key, string value)
        {
            if (_connectionString == null)
                _connectionString = new SPEncryptedString(key, this);
            _connStringToUpdate =  FromString(value);
        }


        public override void Update()
        {
            if (_connStringToUpdate != null)
            {
                _connectionString.UpdateSecureStringValue(this._connStringToUpdate);
                _connStringToUpdate = null;
            }
            base.Update();
        }


        private static SecureString FromString(string strIn)
        {
            if (strIn == null)
                return null;
            var secureString = new SecureString();
            foreach (var c in strIn)
                secureString.AppendChar(c);
            secureString.MakeReadOnly();
            return secureString;
        }



        [Persisted] private SPEncryptedString _connectionString;
        private SecureString _connStringToUpdate;
    }