public void Fill(Database database, string connectionString)
        {
            if (database.Options.Ignore.FilterRules)
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    using (SqlCommand command = new SqlCommand(GetSQL(), conn))
                    {
                        conn.Open();
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                var name = reader["Name"].ToString();
                                var owner = reader["Owner"].ToString();

                                Default item = new Default(database);
                                item.Id = (int)reader["object_id"];
                                item.Name = Util.SqlStrings.HasHexEnding(name) ? AlternateName(owner, reader["TableName"].ToString(), reader["ColumnName"].ToString()) : name;
                                item.Owner = owner;
                                item.Value = reader["Definition"].ToString();
                                database.Defaults.Add(item);
                            }
                        }
                    }
                }
            }
        }
Exemple #2
0
 public UserDataType(ISchemaBase parent)
     : base(parent, Enums.ObjectType.UserDataType)
 {
     Default = new Default(this);
     Rule = new Rule(this);
     Dependencys = new List<ObjectDependency>();
 }
Exemple #3
0
 public new Default Clone(ISchemaBase parent)
 {
     Default item = new Default(parent);
     item.Id = this.Id;
     item.Name = this.Name;
     item.Owner = this.Owner;
     item.Value = this.Value;
     return item;
 }