public void AddColumn(Table table, Attribute attribute)
{
conn.Open();
SqlCommand command = new SqlCommand(" ");
command.Connection = conn;
command.CommandText = "ALTER TABLE " + table.Name +
" ADD " + attribute.Name +
" " + attribute.Type + " ";
if (attribute.Length != 0)
{
command.CommandText += "(" + attribute.Length.ToString() + ")";
}
command.CommandText += " ";
if (!attribute.IsNull)
{
command.CommandText += "NOT NULL";
}
command.CommandText += "; ";
if (attribute.Indexed)
{
command.CommandText += "CREATE INDEX " + "idx_" + table.Name + "_" + attribute.Name +
" ON " + table.Name + "(" + attribute.Name + "); ";
}
command.ExecuteNonQuery();
conn.Close();
context.AttributeSet.Add(attribute);
context.SaveChanges();
}
public void SelectDatabase(Database database)
{
conn.Open();
SqlCommand command = new SqlCommand(" ");
command.Connection = conn;
///TODO: доделать запросы
//CREATE TABLE TableName (TableNameId int IDENTITY(1,1) PRIMARY KEY);
command.CommandText = "USE " + database.Name + ";";
command.Connection = conn;
command.ExecuteNonQuery();
conn.Close();
context.SaveChanges();
}
