Why the data is not populated ?

Question

My problem now is that the hard coded data is not being populated.

And I'd like to know why.

In this class - BookInitializer, the author has hard-coded an Author name Jamie Munro:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using BootstrapIntroduction.Models;
using System.Data.Entity;
namespace BootstrapIntroduction.DAL
{
public class BookInitializer : DropCreateDatabaseIfModelChanges<BookContext>
{
protected override void Seed(BookContext context)
{
var author = new Author
{
Biography = "...",
FirstName = "Jamie",
LastName = "Munro"
};
var books = new List<Book>
{
new Book {
Author = author,
Description = "...",
ImageUrl = "http://ecx.images-amazon.com/images/I/51T%2BWt430bL._AA160_.jpg",
Isbn = "1491914319",
Synopsis = "...",
Title = "Knockout.js: Building Dynamic Client-Side Web Applications"
},
new Book {
Author = author,
Description = "...",
ImageUrl = "http://ecx.images-amazon.com/images/I/51AkFkNeUxL._AA160_.jpg",
Isbn = "1449319548",
Synopsis = "...",
Title = "20 Recipes for Programming PhoneGap: Cross-Platform Mobile Development for Android and iPhone"
},
new Book {
Author = author,
Description = "...",
ImageUrl = "http://ecx.images-amazon.com/images/I/51LpqnDq8-L._AA160_.jpg",
Isbn = "1449309860",
Synopsis = "...",
Title = "20 Recipes for Programming MVC 3: Faster, Smarter Web Development"
},
new Book {
Author = author,
Description = "...",
ImageUrl = "http://ecx.images-amazon.com/images/I/41JC54HEroL._AA160_.jpg",
Isbn = "1460954394",
Synopsis = "...",
Title = "Rapid Application Development With CakePHP"
}
};
books.ForEach(b => context.Books.Add(b));
context.SaveChanges();
}
}
}

and the index.html under Author folder is

@model IEnumerable<BootstrapIntroduction.Models.Author>
@{
ViewBag.Title = "Authors";
}
<h2>Authors</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table table-bordered table-striped">
<thead>
<tr>
<th>@Html.DisplayNameFor(model => model.FirstName) </th>
<th>@Html.DisplayNameFor(model => model.LastName) </th>
<th>@Html.DisplayNameFor(model => model.Biography) </th>
<th>Actions</th>
</tr>
</thead>
<tbody data-bind="foreach: authors">
<tr>
<td data-bind="text: FirstName"></td>
<td data-bind="text: LastName"></td>
<td>
<a data-bind="attr: {href: '@Url.Action("Details")/' + Id }" class="btn btn-info">Details</a>
<a data-bind="attr: {href: '@Url.Action("Edit")/' + Id }" class="btn btn-primary">Edit</a>
<a data-bind="attr: {href: '@Url.Action("Delete")/' + Id }" class="btn btn-danger">Delete</a>
</td>
</tr>
</table>
@section Scripts {
<script type= 'text/javascript' src='/Scripts/knockout-3.3.0.js'></script>
<script>
function ViewModel(authors) {
var self = this;
self.authors = authors;
};
var viewModel = new ViewModel(@Html.HtmlConvertToJson(Model)));
ko.applyBindings(viewModel);
</script>
}

Thank you for your patient and I truly appreciate your helping to a beginner like me.

Rajeev Punhani · Answer

Hi Karen Regarding your first question AppData folder is empty.If the database is being created then it will be generated in AppData folder.But it will not be visible.Right click on AppData folder and Open Folder in File Explorer or Click Show All Files option in Solution Explorer. If database is there but data is not being seeded thenopen Global.asax.cs file and add the following line Database.SetInitializer( new BookInitializer()); In BookInitializer i have done a small change used DropCreateDatabaseAlways BookContext> instead of DropCreateDatabaseIfModelChanges and data is showing up. If the above solution is helpful then accept the answer.

Bikesh Srivastava · Answer

Hi According your controller your populating data from this code to view:- //GET:Authors/Details/5 publicActionResultDetails(int?id) { if( id ==null) { returnnewHttpStatusCodeResult(HttpStatusCode.BadRequest); } Authorauthor = db .Authors.Find(id); if( author ==null) { returnHttpNotFound(); } returnView(author); } you are returning view  returnView(author); you are doing correct . if your data is not populating still check your data which is coming from DB using debug in this action.and also check what (if else)condition executing . to populated data simply you can use Webgrid i already posted.

Tangara G · Answer

Hi Bikesh Sorry I did not post the Controller earlier cos I am new in this. Here's the Controller class : Hope you can let me know why the hard coded data is not being populated. Tks. I also want to add that the AppData folder is empty and I am puzzled why it is so cos the database Connection ping successfully and there is database tables created in the localdb v.11. using System; using System.Collections.Generic; using System.Data; using System.Data.Entity; using System.Linq; using System.Net; using System.Web; using System.Web.Mvc; using BootstrapIntroduction.DAL; using BootstrapIntroduction.Models; using System.Web.ModelBinding; namespace BootstrapIntroduction.Controllers { public class AuthorsController:Controller { private BookContextdb= new BookContext(); //GET:Authors public ActionResultIndex() { return View(db.Authors.ToList()); } //GET:Authors/Details/5 public ActionResultDetails( int ?id) { if (id==null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Authorauthor=db.Authors.Find(id); if (author==null) { return HttpNotFound(); } return View(author); } //GET:Authors/Create public ActionResultCreate() { return View(); } //POST:Authors/Create //Toprotectfromoverpostingattackspleaseenablethespecificpropertiesyouwanttobindtofor //moredetailsseehttp://go.microsoft.com/fwlink/?LinkId=317598. [HttpPost] [ValidateAntiForgeryToken] public ActionResultCreate([Bind(Include= IdFirstNameLastNameBiography )]Authorauthor) { if (ModelState.IsValid) { db.Authors.Add(author); db.SaveChanges(); return RedirectToAction( Index ); } return View(author); } //GET:Authors/Edit/5 public ActionResultEdit( int ?id) { if (id==null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Authorauthor=db.Authors.Find(id); if (author==null) { return HttpNotFound(); } return View(author); } //POST:Authors/Edit/5 //Toprotectfromoverpostingattackspleaseenablethespecificpropertiesyouwanttobindtofor //moredetailsseehttp://go.microsoft.com/fwlink/?LinkId=317598. [HttpPost] [ValidateAntiForgeryToken] public ActionResultEdit([Bind(Include= IdFirstNameLastNameBiography )]Authorauthor) { if (ModelState.IsValid) { db.Entry(author).State=EntityState.Modified; db.SaveChanges(); return RedirectToAction( Index ); } return View(author); } //GET:Authors/Delete/5 public ActionResultDelete( int ?id) { if (id==null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Authorauthor=db.Authors.Find(id); if (author==null) { return HttpNotFound(); } return View(author); } //POST:Authors/Delete/5 [HttpPostActionName( Delete )] [ValidateAntiForgeryToken] public ActionResultDeleteConfirmed( int id) { Authorauthor=db.Authors.Find(id); db.Authors.Remove(author); db.SaveChanges(); return RedirectToAction( Index ); } protected override void Dispose( bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); } } }

Bikesh Srivastava · Answer

Hi Karen According your i am not understanding where is your MVC controller which is use to return data or view anyways If you want populate data in webgrid can use like this. @modelIEnumerable MVCBindGridView.Models.Student > @{ ViewBag.Title = BindGridviewwithDatabase ; WebGrid grid = new WebGrid(Model); //bind model value in webgrid } h2 > BindGridViewinMVC5withDatabase h2 > @grid.GetHtml(columns:new[] { grid.Column(id) // controller return data and bind in webgrid. grid.Column(name) grid.Column(city) } ) it may be helpful for you.