/// <summary>
/// Clona el objeto en una nueva instancia.
/// </summary>
public override ISchemaBase Clone(ISchemaBase parent)
{
View item = new View(parent);
item.Text = this.Text;
item.Status = this.Status;
item.Name = this.Name;
item.Id = this.Id;
item.Owner = this.Owner;
item.IsSchemaBinding = this.IsSchemaBinding;
item.DependenciesIn = this.DependenciesIn;
item.DependenciesOut = this.DependenciesOut;
item.Indexes = this.Indexes.Clone(item);
item.Triggers = this.Triggers.Clone(item);
return item;
}
private void FillView(Database database, string connectionString)
{
int lastViewId = 0;
using (var conn = new SqlConnection(connectionString))
{
using (var command = new SqlCommand(ViewSQLCommand.GetView(database.Info.Version), conn))
{
conn.Open();
command.CommandTimeout = 0;
using (SqlDataReader reader = command.ExecuteReader())
{
View item = null;
while (reader.Read())
{
root.RaiseOnReadingOne(reader["name"]);
if (lastViewId != (int)reader["object_id"]) {
item = new View(database) {
Id = (int) reader["object_id"],
Name = reader["name"].ToString(),
Owner = reader["owner"].ToString(),
IsSchemaBinding = reader["IsSchemaBound"].ToString().Equals("1"),
CreateDate = (DateTime) reader["create_date"],
ModifyDate = (DateTime) reader["modify_date"]
};
database.Views.Add(item);
lastViewId = item.Id;
}
if (item.IsSchemaBinding)
{
if (!reader.IsDBNull(reader.GetOrdinal("referenced_major_id")))
database.Dependencies.Add(database,(int)reader["referenced_major_id"], item);
if (!String.IsNullOrEmpty(reader["TableName"].ToString()))
item.DependenciesIn.Add(reader["TableName"].ToString());
if (!String.IsNullOrEmpty(reader["DependOut"].ToString()))
item.DependenciesOut.Add(reader["DependOut"].ToString());
}
}
}
}
}
}
