I need to query a database of application titles and count the instances of each title. I've already got a list<string> of distinct values from a previous query, and now I need to count how many times each value occurs. I'm not sure if the query is correct, or how to handle the output. So far I have:
SqlCommand appCommand = new SqlCommand("select count(title) from poss_titles where title = @thisTitle", appConnection);
appCommand.Parameters.AddWithValue("@thisTitle", cands[i]);
SqlDataReader reader;
reader = appCommand.ExecuteReader();