Accessing your Model's Data from a Controller
In this section, you'll create a new MoviesController
class and write code that retrieves the movie data and displays it in the browser using a view template.
Right-click the Controllers folder and make a new MoviesController
class.
This creates a new MoviesController.cs file in the project's Controllers folder. Let's update the Index
action method in the MoviesController
class so that is retrieves the list of movies. Don't forget to include a using
statement for the MvcMovie.Models
namespace.
using System;
using System.Linq;
using System.Web.Mvc;
using MvcMovie.Models; // Required in order to access MovieDBContext.
namespace MvcMovie.Controllers
{
public class MoviesController : Controller
{
MovieDBContext db = new MovieDBContext();
public ActionResult Index() {
var movies = from m in db.Movies
where m.ReleaseDate > new DateTime(1984, 6, 1)
select m;
return View(movies.ToList());
}
}
}
The code is performing a LINQ query to retrieve only movies that were released after the summer of 1984. We'll need a view template to render this list of movies, so right-click inside the method and select Add View to create it.
In the Add View dialog box, we'll indicate that we're passing a Movie
class to the view template. Unlike the previous times when we used the Add View dialog box and chose to create an empty template, this time we'll indicate that we want Visual Web Developer to automatically "scaffold" a view template for us that contains some default content. To do this, select List in the Scaffold template drop-down list.
Remember that after you've created a new class, you'll need to compile your application before the class shows up in the Add View dialog box.
Click Add. Visual Web Developer automatically generates the code for a view that displays our list of movies. This is a good time to change the <h2>
heading to something like "My Movie List" like you did earlier with the "Hello World" view.
The code below show a portion of the Index
view for the movie controller. In this section, change the format string for the release date from {0:g}
to {0:d}
(that is, from general date to short date). Change the format string for the Price
property from {0:F}
to {0:c}
(from float to currency).
In addition, in the table header, change the column name from "ReleaseDate" to "Release Date" (two words).
<table>
<tr>
<th></th>
<th>Title</th>
<th>Release Date</th>
<th>Genre</th>
<th>Price</th>
<th>Rating</th>
</tr>
@foreach (var item in Model) {
<tr>
<td>
@Html.ActionLink("Edit", "Edit", new { id=item.ID }) |
@Html.ActionLink("Details", "Details", new { id=item.ID }) |
@Html.ActionLink("Delete", "Delete", new { id=item.ID })
</td>
<td>
@item.Title
</td>
<td>
@String.Format("{0:d}", item.ReleaseDate)
</td>
<td>
@item.Genre
</td>
<td>
@String.Format("{0:c}", item.Price)
</td>
</tr>
}
</table>
We have not added a connection string to the Web.config file. When no connection string is provided, the code-first approach creates the database file in the default SQL Express directory and gives the file a name based on the database context name with the namespace prepended. Let's set an explicit connection string now.
Creating a Connection String and Working with SQL Server Express
Open the application root Web.config file. (Not the Web.config file in the Views folder.) The image below show both Web.config files; open the Web.config file circled in red.
Add the following connection string to the <connectionStrings>
element in the Web.config file.
<add name="MovieDBContext"
connectionString="Server=./SQLEXPRESS;
Database=Movies;Trusted_Connection=true"
providerName="System.Data.SqlClient" />
Run the application and browse to the Movies
controller by appending /Movies to the URL in the address bar of your browser. An empty list of movies is displayed.
A SQL Server Express 2008 database called Movies was automatically created for you. You can verify that it's been created by looking in the C:/Program Files/Microsoft SQL Server/MSSQL10.SQLEXPRESS/MSSQL/DATA folder.
Under the hood, our code-first approach has created an empty Movies database with a movie table with columns that map to our Movie
class. In the next tutorial, we'll add a Create
method to add movies to this database.
分享到:
相关推荐
Ways to use and extend the Provider Model for accessing data stores, processes, and more * What freeware tools you need in Scott Hanselman's ASP.NET Ultimate Developer Tools appendix
ASP.NET is part of Microsoft's overall .NET framework, which contains a vast set of programming classes designed to satisfy any conceivable programming need. In the following two sections, you learn ...
accessing data using the ADO.NET object model, and updating data with or without transaction support. Programming ASP.NET also discusses such advanced topics as: Caching and performance Security ...
Book Description The most comprehensive book on Microsoft’s new ASP.NET 4, ASP.NET 4 Unleashed covers all facets of ASP.NET development....Construct a complete ASP.NET 4 website from start to finish
ASP.NET实现Gridview隐藏/显示列源码 介绍: 这篇文章演示如果让用户有显示/隐藏他们需要的GridView的列的功能,这是非常有用的,因为在GridView的所有列并不是每个的用户都需要的.用户想根据自己的需求看到想要的...
<br>What you will learn from this book <br>How to create a better user experience by adding more dynamic UIs Steps for accessing ASP.NET profile and authentication services Ways to ...
Use the valuable Entity Framework Core 2.0 tool in ASP.NET and the .NET Framework to eliminate the tedium around accessing databases and the data they contain. Entity Framework Core 2.0 greatly ...
28 Adding Interactivity to Your Web Apps with ASP.NET AJAX 648 What Is AJAX? 648 Setting Up an ASP.NET AJAX Site 649 The AJAX Page Life Cycle 650 Loading Custom Script Libraries 652 ASP.NET...
What you'll learn WF 4.0 basics New activities and changes to existing activities in WF 4.0 Customizing your workflows Accessing your workflows in a variety of ways in a variety of situations Using WF...
Appropriate for novice developers with some programming experience, this guide provides instructions for configuring an ASP.NET application, creating web forms, using server controls, accessing data ...
Chapter 9 Using ADO.NET 409 Introduction 410 Overview of XML 411 XML Documents 411 XSL 411 XDR 412 XPath 412 Understanding ADO.NET Architecture 412 Differences between ADO and ADO.NET 414 XML...
MCTS Self-Paced Training Kit (Exam 70-516) Accessing Data with Microsoft .NET Framework 4 eBook.pdf.7z. 請用7zip解壓
Topics like cryptography and encrypted data exchange with a .NET or Compact Framework application are covered. What you’ll learn Describes and compares wireless communication technologies and how ...
MCTS 70-516 Accessing Data with Microsoft .NET Framework 4 练习1。注意,因为我只能上传小于15兆的文件,所以我把setup1.msi给那出去了。安装时需要把setup1.exe放进Practice Tests文件夹。
Customizing your workflows * Accessing your workflows in a variety of ways in a variety of situations * Using WF with Web Services and ASP.NET * Integrating WCF and WF Who this book is for This book ...
VB.NET - Client-side example accessing data stored in session. 服务端的例子: C#.NET - Server-side example accessing data stored in session. C#.NET - Server-side example which includes: MasterPage...
考察现在和下一代的技术,一个新的编程技术的重大挑战开始呈现出来,即面向对象技术诞生以来并没有解决降低访问和整合信息数据( accessing and integrating information )的复杂度的问题。其中两个最主要访问的...
VB.NET - Client-side example accessing data stored in session. 服务端的例子: C#.NET - Server-side example accessing data stored in session. C#.NET - Server-side example which includes: MasterPage...