Bug IDataAccess.GetBug(int id) { using (conn = new SQLiteConnection(connectionString)) { conn.Open(); var bug = new Bug(); var reader = new SQLiteCommand(SQLFixedQueries.SelectBug(id), conn) .ExecuteReader(); while (reader.Read()) { bug = ReadBugFromSQL(reader); } return(bug); } }