private Sql8rAssemblyType addAssembyType(DataRow drType)
{
string atName = drType["name"].ToString();
string sName = drType["sName"].ToString();
string assemblyClass = drType["assemblyClass"].ToString();
long objectId = long.Parse(drType["objectId"].ToString());
var at = new Sql8rAssemblyType(atName, sName, assemblyClass, objectId);
return(at);
}
public void GetServerOtherStuff(Sql8rDatabase db)
{
string aSQL = string.Format(sqlAssemblies, db.Name);
var dsAssemblies = new DataSet("Assemblies");
var sdaAssemblies = new SqlDataAdapter(aSQL, ConnectionString);
sdaAssemblies.Fill(dsAssemblies);
db.Assemblies.Clear();
foreach (DataRow drAssembly in dsAssemblies.Tables[0].Rows)
{
Sql8rAssembly a = addAssembly(drAssembly);
DataRow[] types = dsAssemblies.Tables[1].Select(string.Format("assemblyId={0}", a.ObjectId));
foreach (DataRow drType in types)
{
Sql8rAssemblyType type = addAssembyType(drType);
a.Types.Add(type.Name, type);
}
db.Assemblies.Add(a.Name, a);
}
}
