/// <summary>
/// drop table with columns
/// </summary>
public void Remove()
{
try
{
Entity.Table t = (Entity.Table)Table;
var tb = new Data.TableBuilder(t.TableName, this.Server.Connection());
tb.DropTable();
// write function here to drop table;
t.Remove();
}
catch (System.Exception ex) {
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="fieldid"></param>
public void RemoveField(string fieldid)
{
Entity.Table t = (Entity.Table)Table;
var tb = new Data.TableBuilder(t.TableName, this.Server.Connection());
var f = this.Table.Fields.Where(x => x.FieldID == fieldid).FirstOrDefault();
if (f == null)
{
throw new Data.Exception.TableFieldException(this.Table.TableName, fieldid, fieldid + " field dosenot exist");
}
try {
DBColumn c = DBColumn.Column(f.FieldName, f.FieldType, f.Length);
tb.AddDropField(c);
tb.DropColumn();
t.RemoveField(fieldid);
// write function here to remove field from table;
}
catch (System.Exception ex)
{
throw ex;
}
}