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