public List <DBOpenAnswer> getByKeys(List <int> keys) { List <DBOpenAnswer> result = new List <DBOpenAnswer>(); DBManager manager = new DBManager(true); String sqlCommand = "Select * From dbo.OpenAnswers answer Where "; for (int i = 0; i < keys.Count; i++) { if (i != keys.Count - 1) { sqlCommand += "answer.question_id = " + keys[i] + " OR "; } else { sqlCommand += "answer.question_id = " + keys[i] + ";"; } } var reader = manager.Read(sqlCommand); while (reader.Read()) { DBOpenAnswer answer = new DBOpenAnswer(); answer.Question_id = (int)reader["question_id"]; answer.User_id = (String)reader["user_id"]; answer.Probability = (float)reader["probability"]; result.Add(answer); } manager.Close(); return(result); }
public DBOpenAnswer getByKey(int answer_id) { String sqlCommand = "Select * From dbo.OpenAnswers answer Where answer.question_id = " + answer_id + ";"; DBManager manager = new DBManager(true); var reader = manager.Read(sqlCommand); if (!reader.Read()) { return(null); } DBOpenAnswer answer = new DBOpenAnswer(); answer.Question_id = (int)reader["question_id"]; answer.User_id = (String)reader["user_id"]; answer.Probability = (float)reader["probability"]; manager.Close(); return(answer); }