BoardService.cs

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Net.Mail;
using System.Threading.Tasks;
using Dapper;
using Donatello.Controllers.Api;
using Donatello.Infrastructure;
using Donatello.Models;
using Donatello.ViewModels;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;

namespace Donatello.Services
{

    public class BoardService
    {
        private readonly DonatelloContext dbContext;
        private readonly IConfiguration configuration;

        public BoardService(DonatelloContext dbContext, IConfiguration configuration)
        {
            this.dbContext = dbContext;
            this.emails = emails;
            this.configuration = configuration;
        }

        public BoardList ListBoards()
        {
            var model = new BoardList();

            using(var connection = new SqlConnection(configuration.GetConnectionString("DefaultConnection")))
            {
                var boards = connection.Query<Board>("select * from Boards");
                foreach (var board in boards)
                {
                    model.Boards.Add(new BoardList.Board
                    {
                        Id = board.Id,
                        Title = board.Title
                    });
                }
            }

            return model;
        }
    }
}