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); } }