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