<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>