ChangeRequest IDataAccess.GetChangeRequest(int id)
{
using (conn = new SQLiteConnection(connectionString))
{
conn.Open();
var changeRequest = new ChangeRequest();
var reader = new SQLiteCommand(SQLFixedQueries.SelectChangeRequest(id), conn)
.ExecuteReader();
while (reader.Read())
{
changeRequest = ReadChangeRequestFromSQL(reader);
}
return(changeRequest);
}
}
