C# (CSharp) BugTracker.DataAccess SQLFixedQueries.SelectBug Examples

Example #1

File: SQLiteController.cs Project: dandanyouxiang/BugTracker

        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);
            }
        }