private KeyValueCollection ExtendedProperties(IDatabase db, string schema, string entitytype, string entity, string column)
{
KeyValueCollection hash = new KeyValueCollection();
Recordset rs = db.ExecuteSql(
String.Format(QUERY,
"'" + schema + "'",
"'" + entitytype + "'",
"'" + entity + "'",
((column == null) ? "null" : "'column'"),
((column == null) ? "null" : "'" + column + "'")
)
);
if (rs != null)
{
rs.MoveFirst();
while (!rs.EOF && !rs.BOF)
{
hash.AddKeyValue(rs.Fields["name"].Value.ToString(), rs.Fields["value"].Value.ToString());
rs.MoveNext();
}
rs.Close();
rs = null;
}
return(hash);
}
private KeyValueCollection ExtendedProperties(IDatabase db, string schema, string entitytype, string entity, string column)
{
KeyValueCollection hash = new KeyValueCollection();
Recordset rs = db.ExecuteSql(
String.Format(QUERY,
"'" + schema + "'",
"'" + entitytype + "'",
"'" + entity + "'",
((column == null) ? "null" : "'column'"),
((column == null) ? "null" : "'" + column + "'")
)
);
if (rs != null)
{
rs.MoveFirst();
while (!rs.EOF && !rs.BOF)
{
hash.AddKeyValue( rs.Fields["name"].Value.ToString(), rs.Fields["value"].Value.ToString());
rs.MoveNext();
}
rs.Close();
rs = null;
}
return hash;
}