BetterMembership.Extensions.DatabaseExtensions.AddColumnToTable C# (CSharp) 메소드

AddColumnToTable() 공개 정적인 메소드

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
리턴 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;
            }
        }