Пример #1
0
        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);
            }
        }