public void AddProfileColumn( string Name, FbDbType columnType, int size)
{
// get column type...
string type = columnType.ToString();
// FbDbType.SmallInt
// FbDbType.TimeStamp
// FbDbType.VarChar
// FbDbType.Integer
if (type.ToLower()=="timestamp")
{ type = "TimeStamp"; }
if ( size > 0 )
{
type += "(" + size.ToString() + ")";
}
if ( type.Contains("VarChar") && MsSqlDbAccess.DatabaseEncoding !=null)
{
type += " CHARACTER SET " + MsSqlDbAccess.DatabaseEncoding;
if (MsSqlDbAccess.DatabaseCollation !=null)
{
type += " COLLATE " + MsSqlDbAccess.DatabaseCollation;
}
}
string sql = String.Format(@"ALTER TABLE {0} ADD {1} {2};", MsSqlDbAccess.GetObjectName("P_profile"), Name, type);
using ( FbCommand cmd = new FbCommand( sql ) )
{
cmd.CommandType = CommandType.Text;
_dbAccess.ExecuteNonQuery(cmd );
}
}
/// <summary>
/// The add profile column.
/// </summary>
/// <param name="name">
/// The name.
/// </param>
/// <param name="columnType">
/// The column type.
/// </param>
/// <param name="size">
/// The size.
/// </param>
public static void AddProfileColumn( [NotNull] string name, FbDbType columnType, int size)
{
// get column type...
string type = columnType.ToString();
if (size > 0)
{
type += "(" + size + ")";
}
string sql = "ALTER TABLE {0} ADD {1} {2} ".FormatWith(
MsSqlDbAccess.GetObjectName("UserProfile"), name, type);
using (var cmd = MsSqlDbAccess.GetCommand(sql, true))
{
cmd.CommandType = CommandType.Text;
MsSqlDbAccess.Current.ExecuteNonQuery(cmd);
}
}