{
     "ConnectionStrings": {
          "DefaultConnection": "Server=EVGENI\MSSQLSERVER2012; Database=MyBooks; Trusted_Connection=True; MultipleActiveResultSets=true"
     },

     "Logging": {
          "LogLevel": {
               "Default": "Warning"
          }
     },

     "AllowedHosts": "*"
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

using Microsoft.EntityFrameworkCore; // Entity Framework Core

namespace BookLibrary.Models
{
     // контекст для работы с базой данных (добавление, удаление)
     public class BookContext : DbContext
     {
          public DbSet<Book> Books { get; set; }

          // конструктор
          public BookContext(DbContextOptions<BookContext> options) : base(options)
          {
               Database.EnsureCreated();
          }
     }

     // данные для базы данных
     public class Book
     {
          public int Id { get; set; }
          public string Name { get; set; }
          public string Author { get; set; }
     }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.DependencyInjection;

using Microsoft.Extensions.Configuration;
using BookLibrary.Models;
using Microsoft.EntityFrameworkCore; // add for sql server (options => options.UseSqlServer(connection))

namespace BookLibrary
{
     public class Startup
     {
          public Startup(IConfiguration configuration)
          {
               Configuration = configuration;
          }

          public IConfiguration Configuration { get; }

          // This method gets called by the runtime. Use this method to add services to the container.
          // For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=398940
          public void ConfigureServices(IServiceCollection services)
          {
               // add db connection
               string connection = Configuration.GetConnectionString("DefaultConnection");
               services.AddDbContext<BookContext>(options => options.UseSqlServer(connection));

               services.AddMvc();
          }

          // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
          public void Configure(IApplicationBuilder app, IHostingEnvironment env)
          {
               if (env.IsDevelopment())
               {
                    app.UseDeveloperExceptionPage();
               }

               app.UseMvc(routes =>
               {
                    routes.MapRoute(
                         name: "default",
                         template: "{controller=Home}/{action=Index}/{id?}");
               });

               //app.Run(async (context) =>
               //{
               //     await context.Response.WriteAsync("Hello World!");
               //});
          }
     }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace BookLibrary.Models
{
     public class BooksInit
     {
          public static void Initialize(BookContext context)
          {
               if (!context.Books.Any())
               {
                    // добавляем книги
                    context.Books.AddRange(
                         new Book
                         {
                              Name = "Фантастическое путешествие",
                              Author = "Айзек Азимов",
                         },

                         new Book
                         {
                              Name = "Неукротимая планета",
                              Author = "Гарри Гаррисон",
                         },

                         new Book
                         {
                              Name = "Изучаем C#",
                              Author = "Эндрю Стиллмен",
                         },

                         new Book
                         {
                              Name = "Мастер и Маргарита",
                              Author = "Михаил Булгаков",
                         }
                    );

                    // сохраняем в базу данных
                    context.SaveChanges();
               }
          }
     }
}

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore;
using Microsoft.AspNetCore.Hosting;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.Logging;

using Microsoft.Extensions.DependencyInjection;
using BookLibrary.Models;

namespace BookLibrary
{
     public class Program
     {
          public static void Main(string[] args)
          {
               // CreateWebHostBuilder(args).Build().Run();

               var host = CreateWebHostBuilder(args).Build();

               using (var scope = host.Services.CreateScope())
               {
                    var services = scope.ServiceProvider;
                    try
                    {
                         var context = services.GetRequiredService<BookContext>();
                         BooksInit.Initialize(context);
                    }
                    catch (Exception ex)
                    {
                         var logger = services.GetRequiredService<ILogger<Program>>();
                         logger.LogError(ex, "An error occurred while seeding the database.");
                    }
               }

               host.Run();
          }

public static IWebHostBuilder CreateWebHostBuilder(string[] args) =>
               WebHost.CreateDefaultBuilder(args)
                    .UseStartup<Startup>();
     }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;

using BookLibrary.Models;

namespace BookLibrary.Controllers
{
     public class HomeController : Controller
     {
          BookContext db;

          public HomeController(BookContext context)
          {
               db = context;
          }

          public IActionResult Index()
          {
               return View(db.Books.ToList());
          }

     }
}

@model IEnumerable<BookLibrary.Models.Book>

@{
     Layout = null;
}

<!DOCTYPE html>

<html>
<head>
     <meta name="viewport" content="width=device-width" />
     <title>Библиотека книг</title>
</head>

<body>
     <h3>Книги</h3>

     <table border="1">
          <tr>
               <th>Название книги</th>
               <th>Автор</th>
          </tr>
          @foreach (var book in Model)
          {
               <tr>
                    <td>@book.Name</td>
                    <td>@book.Author</td>
               </tr>
          }
     </table>
</body>

</html>