GetDBCommand() public method

public GetDBCommand ( SqlConnection sqlcn, String CmdText, CommandType CmdType, CommandBehavior CmdBehavior, SqlParameter sqlParam ) : SqlCommand
sqlcn System.Data.SqlClient.SqlConnection
CmdText String
CmdType CommandType
CmdBehavior CommandBehavior
sqlParam System.Data.SqlClient.SqlParameter
return System.Data.SqlClient.SqlCommand
DataIO Class Documentation
Esempio n. 1
0
 // 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;
 }
Esempio n. 2
0
 // 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;
 }