Why the data is not populated ?

Tangara G

10y1.1k.NET

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
{
protected override void Seed(BookContext context)
{
var author = new Author
{
Biography = "...",
FirstName = "Jamie",
LastName = "Munro"
};
var books = new List
{
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
@{
ViewBag.Title = "Authors";
}
Authors
@Html.ActionLink("Create New", "Create")
class="table table-bordered table-striped">
@Html.DisplayNameFor(model => model.FirstName)
@Html.DisplayNameFor(model => model.LastName)
@Html.DisplayNameFor(model => model.Biography)
Actions
"foreach: authors">
"text: FirstName">
"text: LastName">
"attr: {href: '@Url.Action("Details")/' + Id }" class="btn btn-info">Details
"attr: {href: '@Url.Action("Edit")/' + Id }" class="btn btn-primary">Edit
"attr: {href: '@Url.Action("Delete")/' + Id }" class="btn btn-danger">Delete
@section Scripts {
'text/javascript' src='/Scripts/knockout-3.3.0.js'>
}

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeev Punhani10y ago
Hi Karen,
Regarding your first questionAppData folder is empty.If the database is being created then it will be generated inAppData folder.But it will not be visible.Right click onAppData 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 then,open Global.asax.cs file and add the following line
Database.SetInitializer(newBookInitializer());
In BookInitializer i have done a small change usedDropCreateDatabaseAlways<BookContext> instead ofDropCreateDatabaseIfModelChanges and data is showing up.
If the above solution is helpful then,accept the answer.
0
Bikesh Srivastava10y ago
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.
0
Tangara G10y ago
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.
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Data;
usingSystem.Data.Entity;
usingSystem.Linq;
usingSystem.Net;
usingSystem.Web;
usingSystem.Web.Mvc;
usingBootstrapIntroduction.DAL;
usingBootstrapIntroduction.Models;
usingSystem.Web.ModelBinding;
namespaceBootstrapIntroduction.Controllers
{
publicclassAuthorsController:Controller
{
privateBookContextdb=newBookContext();
//GET:Authors
publicActionResultIndex()
{
returnView(db.Authors.ToList());
}
//GET:Authors/Details/5
publicActionResultDetails(int?id)
{
if(id==null)
{
returnnewHttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Authorauthor=db.Authors.Find(id);
if(author==null)
{
returnHttpNotFound();
}
returnView(author);
}
//GET:Authors/Create
publicActionResultCreate()
{
returnView();
}
//POST:Authors/Create
//Toprotectfromoverpostingattacks,pleaseenablethespecificpropertiesyouwanttobindto,for
//moredetailsseehttp://go.microsoft.com/fwlink/?LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
publicActionResultCreate([Bind(Include="Id,FirstName,LastName,Biography")]Authorauthor)
{
if(ModelState.IsValid)
{
db.Authors.Add(author);
db.SaveChanges();
returnRedirectToAction("Index");
}
returnView(author);
}
//GET:Authors/Edit/5
publicActionResultEdit(int?id)
{
if(id==null)
{
returnnewHttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Authorauthor=db.Authors.Find(id);
if(author==null)
{
returnHttpNotFound();
}
returnView(author);
}
//POST:Authors/Edit/5
//Toprotectfromoverpostingattacks,pleaseenablethespecificpropertiesyouwanttobindto,for
//moredetailsseehttp://go.microsoft.com/fwlink/?LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
publicActionResultEdit([Bind(Include="Id,FirstName,LastName,Biography")]Authorauthor)
{
if(ModelState.IsValid)
{
db.Entry(author).State=EntityState.Modified;
db.SaveChanges();
returnRedirectToAction("Index");
}
returnView(author);
}
//GET:Authors/Delete/5
publicActionResultDelete(int?id)
{
if(id==null)
{
returnnewHttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Authorauthor=db.Authors.Find(id);
if(author==null)
{
returnHttpNotFound();
}
returnView(author);
}
//POST:Authors/Delete/5
[HttpPost,ActionName("Delete")]
[ValidateAntiForgeryToken]
publicActionResultDeleteConfirmed(intid)
{
Authorauthor=db.Authors.Find(id);
db.Authors.Remove(author);
db.SaveChanges();
returnRedirectToAction("Index");
}
protectedoverridevoidDispose(booldisposing)
{
if(disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
}
}
0
Bikesh Srivastava10y ago
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";
WebGridgrid=newWebGrid(Model); //bind model value in webgrid
}
<h2>BindGridViewinMVC5withDatabaseh2>
@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.
0

Why the data is not populated ?

Authors