IssueViewModel IDataAccess.GetIssue(int id) { using (conn = new SQLiteConnection(connectionString)) { conn.Open(); var issue = new IssueViewModel(); var reader = new SQLiteCommand(SQLFixedQueries.SelectIssue(id), conn) .ExecuteReader(); while (reader.Read()) { issue = ReadIssueFromSQL(reader); } return(issue); } }