본문에서는 먼저 스캐폴딩(Scaffolding) 기능을 이용해서 새로운 컨트롤러와 뷰들을 추가해봅니다.

이렇게 생성된 코드들을 분석해보면서 강력한 형식의 뷰를 이용한 모델 데이터 접근 방식을 살펴보고, 그 과정에 사용되는 강력한 형식의 모델과 HttpPost/HttpGet 어트리뷰트, 몇 가지 도우미 메서드 등에 관해서 알아봅니다. 그리고, SQL 서버 LocalDB를 사용하는 방법도 간단하게 살펴봅니다.

마지막으로, 장르와 제목으로 영화 정보를 검색할 수 있는 기능을 추가해보면서, 실제 응용 프로그램 구축 작업시 고려해야 할 점들을 몇 가지 짚어봅니다.

• 컨트롤러 이름(Controller name): MoviesController.
• 템플릿(Template): Controller with read/write actions and views, using Entity Framework.
• 모델 클래스(Model class): Movie (MvcMovie.Models).
• 데이터 컨텍스트 클래스(Data context class): MovieDBContext (MvcMovie.Models).
• 뷰(Views): Razor (CSHTML). (기본값)

• 프로젝트의 Controllers 폴더에 MoviesController.cs 파일이 생성됩니다.
• 프로젝트의 Views 폴더에 Movies 폴더가 생성됩니다.
• 새로운 Views\Movies 폴더에 Create.cshtml, Delete.cshtml, Details.cshtml, Edit.cshtml, Index.cshtml 파일이 생성됩니다.

public class MoviesController : Controller 
{
    private MovieDBContext db = new MovieDBContext(); 

    //
    // GET: /Movies/ 

    public ActionResult Index() 
    {
        return View(db.Movies.ToList());
    }

private MovieDBContext db = new MovieDBContext();

public ActionResult Details(int id = 0)
{
    Movie movie = db.Movies.Find(id);
    if (movie == null)
    {
        return HttpNotFound();
    }
    return View(movie);
}

@model MvcMovie.Models.Movie

public ActionResult Index()
{
    return View(db.Movies.ToList());
}

@model IEnumerable<MvcMovie.Models.Movie>

@foreach (var item in Model) {
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.Title)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.ReleaseDate)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Genre)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Price)
        </td>
        <th>
            @Html.DisplayFor(modelItem => item.Rating)
        </th>
        <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>
    </tr>
}

@Html.ActionLink("Edit", "Edit", new { id=item.ID })

//
// GET: /Movies/Edit/5

public ActionResult Edit(int id = 0)
{
    Movie movie = db.Movies.Find(id);
    if (movie == null)
    {
        return HttpNotFound();
    }
    return View(movie);
}

//
// POST: /Movies/Edit/5

[HttpPost]
public ActionResult Edit(Movie movie)
{
    if (ModelState.IsValid)
    {
        db.Entry(movie).State = EntityState.Modified;
        db.SaveChanges();
        return RedirectToAction("Index");
    }
    return View(movie);
}

@model MvcMovie.Models.Movie

@{
    ViewBag.Title = "Edit";
}

<h2>Edit</h2>

<script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"></script>
<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript"></script>

@using (Html.BeginForm()) {
    @Html.ValidationSummary(true)
    <fieldset>
        <legend>Movie</legend>

        @Html.HiddenFor(model => model.ID)

        <div class="editor-label">
            @Html.LabelFor(model => model.Title)
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.Title)
            @Html.ValidationMessageFor(model => model.Title)
        </div>

        <div class="editor-label">
            @Html.LabelFor(model => model.ReleaseDate)
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.ReleaseDate)
            @Html.ValidationMessageFor(model => model.ReleaseDate)
        </div>

        <div class="editor-label">
            @Html.LabelFor(model => model.Genre)
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.Genre)
            @Html.ValidationMessageFor(model => model.Genre)
        </div>

        <div class="editor-label">
            @Html.LabelFor(model => model.Price)
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.Price)
            @Html.ValidationMessageFor(model => model.Price)
        </div>

        <p>
            <input type="submit" value="Save" />
        </p>
    </fieldset>
}

<div>
    @Html.ActionLink("Back to List", "Index")
</div>

<form action="/Movies/Edit/4" method="post">
    <fieldset>
        <legend>Movie</legend>

        <input data-val="true" data-val-number="The field ID must be a number." data-val-required="The ID field is required." id="ID" name="ID" type="hidden" value="4" />

        <div class="editor-label">
            <label for="Title">Title</label>
        </div>
        <div class="editor-field">
            <input class="text-box single-line" id="Title" name="Title" type="text" value="Rio Bravo" />
            <span class="field-validation-valid" data-valmsg-for="Title" data-valmsg-replace="true"></span>
        </div>

        <div class="editor-label">
            <label for="ReleaseDate">ReleaseDate</label>
        </div>
        <div class="editor-field">
            <input class="text-box single-line" data-val="true" data-val-date="The field ReleaseDate must be a date." data-val-required="The ReleaseDate field is required." id="ReleaseDate" name="ReleaseDate" type="text" value="4/15/1959 12:00:00 AM" />
            <span class="field-validation-valid" data-valmsg-for="ReleaseDate" data-valmsg-replace="true"></span>
        </div>

        <div class="editor-label">
            <label for="Genre">Genre</label>
        </div>
        <div class="editor-field">
            <input class="text-box single-line" id="Genre" name="Genre" type="text" value="Western" />
            <span class="field-validation-valid" data-valmsg-for="Genre" data-valmsg-replace="true"></span>
        </div>

        <div class="editor-label">
            <label for="Price">Price</label>
        </div>
        <div class="editor-field">
            <input class="text-box single-line" data-val="true" data-val-number="The field Price must be a number." data-val-required="The Price field is required." id="Price" name="Price" type="text" value="2.99" />
            <span class="field-validation-valid" data-valmsg-for="Price" data-valmsg-replace="true"></span>
        </div>

        <p>
            <input type="submit" value="Save" />
        </p>
    </fieldset>
</form>

[HttpPost]
public ActionResult Edit(Movie movie)
{
    if (ModelState.IsValid)
    {
        db.Entry(movie).State = EntityState.Modified;
        db.SaveChanges();
        return RedirectToAction("Index");
    }
    return View(movie);
}

<system.web>
  <globalization culture ="en-US" />
  <!--명확성을 위해 다른 요소들은 제거했습니다.-->
</system.web>

public ActionResult SearchIndex(string searchString)
{
    var movies = from m in db.Movies
select m;

    if (!String.IsNullOrEmpty(searchString))
    { 
        movies = movies.Where(s => s.Title.Contains(searchString));
    }

    return View(movies);
}

var movies = from m in db.Movies 
             select m;

if (!String.IsNullOrEmpty(searchString))
{ 
    movies = movies.Where(s => s.Title.Contains(searchString));
}

@model IEnumerable<MvcMovie.Models.Movie>

@{
    ViewBag.Title = "SearchIndex";
}

<h2>SearchIndex</h2>

<p>
     @Html.ActionLink("Create New", "Create") 
</p>
<table>
    <tr>
        <th>
            Title
        </th>
        <th> 
            ReleaseDate 
        </th>
        <th> 
            Genre
        </th>
        <th> 
            Price
        </th>
        <th></th>
    </tr> 

@foreach (var item in Model) {
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.Title) 
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.ReleaseDate)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Genre) 
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Price)
        </td>
        <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>
    </tr>
}

</table>

{controller}/{action}/{id}

public ActionResult SearchIndex(string searchString)
{
    var movies = from m in db.Movies
 select m;

    if (!String.IsNullOrEmpty(searchString))
    {
        movies = movies.Where(s => s.Title.Contains(searchString));
    }

    return View(movies);
}

public ActionResult SearchIndex(string id)
{
    string searchString = id;
    var movies = from m in db.Movies
 select m;

    if (!String.IsNullOrEmpty(searchString))
    {
        movies = movies.Where(s => s.Title.Contains(searchString));
    }

    return View(movies);
}

public ActionResult SearchIndex(string searchString)
{
    var movies = from m in db.Movies
 select m;

    if (!String.IsNullOrEmpty(searchString))
    {
        movies = movies.Where(s => s.Title.Contains(searchString));
    }

    return View(movies);
}

@using (Html.BeginForm()){
    <p>Title: @Html.TextBox("SearchString")
    <input type="submit" value="Filter" /></p>
}

@model IEnumerable<MvcMovie.Models.Movie>

@{
    ViewBag.Title = "SearchIndex";
}

<h2>SearchIndex</h2>

<p>
    @Html.ActionLink("Create New", "Create") 
    
    @using (Html.BeginForm()){
        <p>Title: @Html.TextBox("SearchString")
        <input type="submit" value="Filter" /></p>
    }
</p>

[HttpPost]
public string SearchIndex(FormCollection fc, string searchString)
{
    return "<h3> From [HttpPost]SearchIndex: " + searchString + "</h3>";
}

@using(Html.BeginForm("SearchIndex", "Movies", FormMethod.Get))

public ActionResult SearchIndex(string movieGenre, string searchString)
{
    var GenreLst = new List<string>();

    var GenreQry = from d in db.Movies
   orderby d.Genre
   select d.Genre;
    GenreLst.AddRange(GenreQry.Distinct());
    ViewBag.movieGenre = new SelectList(GenreLst);

    var movies = from m in db.Movies
 select m;

    if (!String.IsNullOrEmpty(searchString))
    {
        movies = movies.Where(s => s.Title.Contains(searchString));
    }

    if (string.IsNullOrEmpty(movieGenre))
        return View(movies);
    else
    {
        return View(movies.Where(x => x.Genre == movieGenre));
    }
}

var GenreQry = from d in db.Movies
               orderby d.Genre
               select d.Genre;

if (string.IsNullOrEmpty(movieGenre))
    return View(movies);
else
{
    return View(movies.Where(x => x.Genre == movieGenre));
}

<p> 
    @Html.ActionLink("Create New", "Create") 
    @using (Html.BeginForm("SearchIndex","Movies",FormMethod.Get)) {
        <p>Genre: @Html.DropDownList("movieGenre", "All")
        Title: @Html.TextBox("SearchString")
        <input type="submit" value="Filter" /></p>
    }
</p>

宋

역자 송원석은 현재 프리랜서 개발자로 활동하고 있습니다. 2006년부터 3년간 마이크로소프트 IIS 부문 MVP를 수상했으며, 개인적으로 지난 6, 7년간 꾸준히 IIS.net의 문서들을 번역하여 소개해오고 있습니다.

“프로 ASP.NET MVC 3 프레임워크"와 “프로 ASP.NET MVC 프레임워크”의 공역에 참여했던 경험을 계기 삼아, 본격적으로 ASP.net의 문서 번역 작업을 시작하게 되었습니다.

두 딸아이의 아버지며, 공을 사용하는 모든 운동을 싫어하고, 맥주와 막걸리, 그리고 진도 홍주를 사랑하는 배가 나온 평범한 남자입니다.