Загрузка данных


<connectionStrings>
  <add name="BookContext" 
       connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename='|DataDirectory|\BookStore.mdf';Integrated Security=True;" 
       providerName="System.Data.SqlClient" />
</connectionStrings>

public class BookDbInitializer : DropCreateDatabaseAlways<BookContext>
{
    protected override void Seed(BookContext db)
    {
        db.Books.Add(new Book { Name = "Война и мир", Author = "Л.Н. Толстой", Price = 220 });
        db.Books.Add(new Book { Name = "Отцы и дети", Author = "И.С. Тургенев", Price = 220 });
        db.Books.Add(new Book { Name = "Чайка", Author = "А.П. Чехов", Price = 220 });

        base.Seed(db);
    }
}

Database.SetInitializer(new BookDbInitializer());

using ASPMVCApp.Models;

public class HomeController : Controller
{
    BookContext db = new BookContext();

    public ActionResult Index()
    {
        var books = db.Books;
        ViewBag.Books = books;
        return View();
    }
}

@{
    ViewBag.Title = "Книжный магазин";
}

<div>
    <h3>Распродажа книг</h3>
    <table>
        <tr>
            <td><p>Название книги</p></td>
            <td><p>Автор</p></td>
            <td><p>Цена</p></td>
        </tr>
        @foreach (var b in ViewBag.Books)
        {
            <tr>
                <td><p>@b.Name</p></td>
                <td><p>@b.Author</p></td>
                <td><p>@b.Price</p></td>
            </tr>
        }
    </table>
</div>