treehouse-blog-post-adonet-query.cs

public static DataTable GetComicBook(int comicBookId)
{
    using (var conn = new SqlConnection(ConnectionString))
    {
        using (var cmd = new SqlCommand($@"
                SELECT Id, SeriesId, IssueNumber, 
                    [Description], PublishedOn, AverageRatng
                FROM ComicBook
                WHERE Id = {comicBookId};
            ", conn))
        {
            var dataAdapter = new SqlDataAdapter(cmd);
            var dt = new DataTable();
            dataAdapter.Fill(dt);
            return dt;
        }
    }
}