BetterMembership.Extensions.DatabaseExtensions.AddColumnToTable C# (CSharp) Method

AddColumnToTable() public static method

public static AddColumnToTable ( this db, string userTableName, string userEmailColumn, SqlDbType dataType, int maxEmailLength, bool allowNull, bool isUnique ) : bool
db this
userTableName string
userEmailColumn string
dataType SqlDbType
maxEmailLength int
allowNull bool
isUnique bool
return bool
        public static bool AddColumnToTable(
            this IDatabase db, 
            string userTableName, 
            string userEmailColumn, 
            SqlDbType dataType, 
            int maxEmailLength, 
            bool allowNull, 
            bool isUnique)
        {
            var buffer =
                new StringBuilder(@"ALTER TABLE [").Append(userTableName)
                                                   .Append("] ADD [")
                                                   .Append(userEmailColumn)
                                                   .Append("] ")
                                                   .Append(Convert.ToString(dataType))
                                                   .Append("(")
                                                   .Append(maxEmailLength)
                                                   .Append(")");

            if (allowNull)
            {
                buffer.Append(" NOT");
            }

            buffer.Append(" NULL");

            if (isUnique)
            {
                buffer.Append(" UNIQUE");
            }

            try
            {
                db.Execute(buffer.ToString());
                return true;
            }
            catch (Exception)
            {
                return false;
            }
        }