public GetDBCommand ( |
||
sqlcn | ||
CmdText | String | |
CmdType | CommandType | |
CmdBehavior | CommandBehavior | |
sqlParam | ||
return |
// can do this via Search API but this is much faster since we know exactly what we want private List<string> LoadPeople() { List<string> urlNames = new List<string>(); DataIO data = new DataIO(); using (SqlDataReader reader = data.GetDBCommand(ConfigurationManager.ConnectionStrings["ProfilesDB"].ConnectionString, "select n.UrlName from [Profile.Data].Person p join [UCSF.].NameAdditions n on p.InternalUserName = n.InternalUserName where p.IsActive = 1" , CommandType.Text, CommandBehavior.CloseConnection, null).ExecuteReader()) { while (reader.Read()) { urlNames.Add(reader[0].ToString()); } } return urlNames; }
// can do this via Search API but this is much faster since we know exactly what we want private List<Int64> LoadPeople() { List<Int64> nodeIds = new List<Int64>(); DataIO data = new DataIO(); using (SqlDataReader reader = data.GetDBCommand(ConfigurationManager.ConnectionStrings["ProfilesDB"].ConnectionString, "select n.nodeId from [Profile.Data].Person p join [RDF.Stage].InternalNodeMap n on cast(p.PersonID as varchar) = n.InternalID " + "and Class = 'http://xmlns.com/foaf/0.1/Person' where p.IsActive = 1" , CommandType.Text, CommandBehavior.CloseConnection, null).ExecuteReader()) { while (reader.Read()) { nodeIds.Add(reader.GetInt64(0)); } } return nodeIds; }