[C#] .NET FRAMEWORK - Code First

URL : https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/

+) Code First vs Database First

Code First

: class로 데이터를 미리 만들어 놓은 후에 실행을 한 뒤 (ex)add-migration) database를 생성함

Database First (ex) Dapper)

: 다른 서버 or Local에 미리 테이블을 만들어 놓고 만든 테이블이나 데이터베이스를 가져와서 사용

<.NET FRAMEWORK 시작하기 - HelloWorld 파일 실행해보기>

1. 프로젝트 생성하기

1) 파일 -> 새 프로젝트 -> ASP.NET 웹 응용 프로그램(.NET Framework)

2) 폴더 구조

- App_Data

: Database에서 DB를 생성하고 테이블을 생성하면 이곳에서 mdf파일(MSSQL)로 저장

- App_Start

RouteConfig.cs : url을 지정

- Model / Controller / View

: MVC 패턴을 따르고 있음

- Web.config

: Database 생성후 LocalDB와 연동할 때 필요

- 이외의 파일

: default로 bootstrap을 이용하기 때문에 bootstrap에서 사용될 css, javascript 파일이 대다수

2. HelloWorld 예제 파일 생성해보기

Controller -> 추가 -> MVC5 컨트롤러 - 비어있음

: 자동으로 View까지 생성!

Controllers/HelloWorldController.cs

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; namespace myWebAppMVC.Controllers { public class HelloWorldController : Controller { // GET: /HelloWorld/ //public string Index() //{ // return "This is my <b> default</b> action "; //} // GET: /HelloWorld/ public ActionResult Index() { return View(); } // GET: /HelloWorld/Welcome/ //public string Welcome() //{ // return "This is the Welcome action method ..."; //} // GET: /HelloWorld/Welcome?name=Zoe&numTimes=4 // numTimes의 default는 1 // 하지만 url로 들어오면 변경 //public string Welcome(string name, int numTimes = 1) //{ // return HttpUtility.HtmlEncode("Hello " + name + ", NumTimes is :" + numTimes); //} public ActionResult Welcome(string name, int numTimes = 1) { ViewBag.Message = "Hello " + name; ViewBag.NumTimes = numTimes; return View(); } } }

- HelloWorld Controller : HelloWorld 폴더에 있는 파일을 제어

- HelloWorld 안에 있는 함수 이름 = HelloWorld 폴더 아래의 cshtml 파일의 이름

- ActionResult -> return View()인데 View의 이름을 지정하지 않는 이유 -> 함수의 이름이 cshtml의 파일 이름

- 함수에 parameter를 설정하는 것은 get 형식일 때 "/HelloWorld/Welcome?name=Zoe&numTimes=4" 뒤에 들어오는 변수를 담음

(단 get으로 받아올 때의 변수 이름과 parameter의 이름이 같아야함)

- ViewBag : 해당 View에서 뿌려줄 데이터를 담음 

Views/HelloWorld/Index.cshtml

<!-- 공통된 파일 _Layout에서 이 파일을 Renderbody로 가져옴 --> @*@{ Layout = "~/Views/Shared/_Layout.cshtml"; }*@ @{ ViewBag.Title = "Movie List"; } <h2>My Movie List</h2> <p>Hello from our View Template!</p>

- _Layout은 cshtml의 파일을 공통으로 가져오는 것

예를 들어 디자인은 같은데 내용만 바뀌어야할 경우 _Layout에는 디자인을 내용은 다른 cshtml의 내용을 가져옴

- ViewBag을 이용하여 controller에서 정의했던 변수를 가져옴

Views/HelloWorld/Welcome.cshtml

@*@{ Layout = "~/Views/Shared/_Layout.cshtml"; }*@ <h2>Welcome</h2> <ul> @for (int i=0; i<ViewBag.NumTimes; i++) { <li> @ViewBag.Message </li> } </ul>

<.NET FRAMEWORK 시작하기 - Database 연동해보기>

1. Entity Framework Nuget Package 설치하기

URL : https://www.nuget.org/packages/EntityFramework/

도구 -> NuGet 패키지 관리자 -> 패키지 관리자 콘솔 -> Install-Package EntityFramework -Version 6.2.0 

2. Model 생성하기

1) Models -> 추가 -> 클래스 파일 생성하기

(저는 예제와 같이 이름은 Movie로 지정하였습니다!)

using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.Data.Entity; using System.Linq; using System.Web; // Code First namespace myWebAppMVC.Models { // 생성된 데이터는 myWebAppMVC 프로젝트에서 모든 파일 보기 -> App_Data안에 mdf파일로 존재! // Validation 값을 모두 지정 /* > database 변경할 때 마다 add-migration '새로 생성될 Migrations 이름' update-database */ public class Movie { public int ID { get; set; } [StringLength(60, MinimumLength =3)] public string Title { get; set; } //[Display(Name="Release Date")] //[DataType(DataType.Date)] //[DisplayFormat(DataFormatString ="{0:yyyy-MM-dd}",ApplyFormatInEditMode =true)] //[Range(typeof(DateTime),"1/1/1966","1/1/2020")] [Display(Name = "Release Date"), DataType(DataType.Date)] public DateTime ReleaseDate { get; set; } [RegularExpression(@"^[A-Z]+[a-zA-Z'\s]*$")] [Required] [StringLength(30)] public string Genre { get; set; } //[Range(1,100)] //[DataType(DataType.Currency)] [Range(1,100),DataType(DataType.Currency)] public decimal Price { get; set; } [RegularExpression(@"^[A-Z]+[a-zA-Z'\s]*$")] [StringLength(5)] public string Rating { get; set; } } // DbContext : Db를 생성 // Movie : movie class의 변수를 가짐 // Movies : Database의 이름 public class MovieDBContext : DbContext { public DbSet<Movie> Movies { get; set; } } }

- class를 이용해서 Table의 column 명 & validation (조건) 을 입력

- DbContext를 이용해서 Db를 생성 후 Db명 입력

2) Web.config 수정

<configuration> <connectionStrings> <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=aspnet-MvcMovie-fefdc1f0-bd81-4ce9-b712-93a062e01031;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MvcMovie-fefdc1f0-bd81-4ce9-b712-93a062e01031.mdf" providerName="System.Data.SqlClient" /> <add name="MovieDBContext" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=aspnet-MvcMovie;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Movies.mdf" providerName="System.Data.SqlClient" /> </connectionStrings> </configuration>

3) 도구 -> NuGet 패키지 관리자 -> 패키지 관리자 콘솔

Enable-Migrations -ContextTypeName 프로젝트이름.Models.MovieDBContext

-> Migrations폴더에 Configuration.cs 생성!

+) Database 수정할 때마다

add-migration '새로 생성될 Migrations 파일 이름'

update-database

4) Entity Framework를 사용하며 뷰가 포함된 MVC 5 컨트롤러

-> 이 option을 선택하면 View 폴더 아래의 새로 생성된 폴더 밑에 Create, Delete, Details, Edit, Index 파일을 자동으로 생성

Controllers/MoviesController.cs

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 myWebAppMVC.Models; namespace myWebAppMVC.Controllers { public class MoviesController : Controller { // Model에서 만든 DBContext private MovieDBContext db = new MovieDBContext(); // GET: Movies //public ActionResult Index() //{ // return View(db.Movies.ToList()); //} //Movies?searchString=ghost //public ActionResult Index(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); //} //Movies/index/ghost //public ActionResult Index(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); //} //Movies/Index //[HttpPost] //public string Index(FormCollection fc, string searchString) //{ // return "<h3> From [HttpPost]Index: " + searchString + "</h3>"; //} public ActionResult Index(string movieGenre, string searchString) { var GenreList = new List<string>(); var GenreQry = from d in db.Movies orderby d.Genre select d.Genre; GenreList.AddRange(GenreQry.Distinct()); ViewBag.movieGenre = new SelectList(GenreList); 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)) { movies = movies.Where(x => x.Genre == movieGenre); } return View(movies); } // GET: Movies/Details/5 public ActionResult Details(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Movie movie = db.Movies.Find(id); if (movie == null) { return HttpNotFound(); } // return View("view 이름",넘길 데이터); return View(movie); } // GET: Movies/Create public ActionResult Create() { return View(); } // POST: Movies/Create // 초과 게시 공격으로부터 보호하려면 바인딩하려는 특정 속성을 사용하도록 설정하십시오. // 자세한 내용은 https://go.microsoft.com/fwlink/?LinkId=317598을(를) 참조하십시오. [HttpPost] [ValidateAntiForgeryToken] public ActionResult Create([Bind(Include = "ID,Title,ReleaseDate,Genre,Price")] Movie movie) { if (ModelState.IsValid) { // View에서 받아온 값을 저장 db.Movies.Add(movie); db.SaveChanges(); return RedirectToAction("Index"); } return View(movie); } // GET: Movies/Edit/5 public ActionResult Edit(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Movie movie = db.Movies.Find(id); if (movie == null) { return HttpNotFound(); } return View(movie); } // POST: Movies/Edit/5 // 초과 게시 공격으로부터 보호하려면 바인딩하려는 특정 속성을 사용하도록 설정하십시오. // 자세한 내용은 https://go.microsoft.com/fwlink/?LinkId=317598을(를) 참조하십시오. [HttpPost] [ValidateAntiForgeryToken] public ActionResult Edit([Bind(Include = "ID,Title,ReleaseDate,Genre,Price")] Movie movie) { // 변경되었으면 Update if (ModelState.IsValid) { db.Entry(movie).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(movie); } // GET: Movies/Delete/5 //public ActionResult Delete(int? id) //{ // if (id == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // Movie movie = db.Movies.Find(id); // if (movie == null) // { // return HttpNotFound(); // } // return View(movie); //} public ActionResult Delete(FormCollection fcNotUsed, int id = 0) { Movie movie = db.Movies.Find(id); if(movie == null) { return HttpNotFound(); } db.Movies.Remove(movie); db.SaveChanges(); return RedirectToAction("Index"); } // POST: Movies/Delete/5 [HttpPost, ActionName("Delete")] [ValidateAntiForgeryToken] public ActionResult DeleteConfirmed(int id) { Movie movie = db.Movies.Find(id); db.Movies.Remove(movie); db.SaveChanges(); return RedirectToAction("Index"); } protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); } } }

- MovieDbcontext의 값을 가져옴 (DB를 가져옴)

- get 방식

1) ?를 이용해서 변수의 값을 가져옴

//Movies? searchString = ghost public ActionResult Index(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); }

2) url을 생성한 후 변수의 값을 가져옴 
//Movies/index/ghost public ActionResult Index(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); }

App_Start/RouteConfig.cs (아래를 추가)

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using System.Web.Routing; namespace myWebAppMVC { // url의 형식을 관리해주는 곳 public class RouteConfig { public static void RegisterRoutes(RouteCollection routes) { routes.IgnoreRoute("{resource}.axd/{*pathInfo}"); routes.MapRoute( name: "Default", url: "{controller}/{action}/{id}", defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional } ); // HelloWorldController.cs에서 정의한 // /HelloWorld/Welcome?name=Zoe&numTimes=3 => /HelloWorld/Welcome/Zoe/3으로 변경 // 단 url에 지정한 이름이 같아야 한다 routes.MapRoute( name: "Hello", url: "{controller}/{action}/{name}/{numTimes}" ); } } }

+) Views/Movies안의 cshtml 중 한개

Views/Movies/Delete.cshtml

@model myWebAppMVC.Models.Movie @{ ViewBag.Title = "Delete"; } <h2>Delete</h2> <h3>Are you sure you want to delete this?</h3> <div> <h4>Movie</h4> <hr /> <dl class="dl-horizontal"> <dt> @Html.DisplayNameFor(model => model.Title) </dt> <dd> @Html.DisplayFor(model => model.Title) </dd> <dt> @Html.DisplayNameFor(model => model.ReleaseDate) </dt> <dd> @Html.DisplayFor(model => model.ReleaseDate) </dd> <dt> @Html.DisplayNameFor(model => model.Genre) </dt> <dd> @Html.DisplayFor(model => model.Genre) </dd> <dt> @Html.DisplayNameFor(model => model.Price) </dt> <dd> @Html.DisplayFor(model => model.Price) </dd> </dl> @using (Html.BeginForm()) { <!-- 폼을 제출할 때 유효성이 검사되는 숨겨진 폼 필드(위조 방지 토큰)를 생성합니다 --> @Html.AntiForgeryToken() <div class="form-actions no-color"> <input type="submit" value="Delete" class="btn btn-default" /> | @Html.ActionLink("Back to List", "Index") </div> } </div>

+) Entity Framework 6 (Code First) - 간단하게

<프로젝트 생성 후 간단한 기능 구현해보기>

1. Entity Framework 설치 

도구 -> NuGet 패키지 관리자 -> 패키지 관리자 콘솔

Install-Package EntityFramework

2. Paging을 위해 PagedList 설치

도구 -> NuGet 패키지 관리자 -> 패키지 관리자 콘솔

Install-Package PagedList.Mvc

3. 코드를 보고 대충 감잡기

Controllers/StudentController.cs

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 myWebAppWithEF6.DAL; using myWebAppWithEF6.Models; using PagedList; namespace myWebAppWithEF6.Controllers { public class StudentsController : Controller { private SchoolContext db = new SchoolContext(); // GET: Students //public ActionResult Index() //{ // return View(db.Students.ToList()); //} public ViewResult Index(string sortOrder, string currentFilter, string searchString, int? page) { ViewBag.CurrentSort = sortOrder; ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; var students = from s in db.Students select s; if (!String.IsNullOrEmpty(searchString)) { students = students.Where(s => s.LastName.Contains(searchString) || s.FirstMidName.Contains(searchString)); } switch (sortOrder) { case "name_desc": students = students.OrderByDescending(s => s.LastName); break; case "Date": students = students.OrderBy(s => s.EnrollmentDate); break; case "date_desc": students = students.OrderByDescending(s => s.EnrollmentDate); break; default: // Name ascending students = students.OrderBy(s => s.LastName); break; } int pageSize = 3; int pageNumber = (page ?? 1); return View(students.ToPagedList(pageNumber, pageSize)); } // GET: Students/Details/5 public ActionResult Details(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Student student = db.Students.Find(id); if (student == null) { return HttpNotFound(); } return View(student); } // GET: Students/Create public ActionResult Create() { return View(); } // POST: Students/Create // 초과 게시 공격으로부터 보호하려면 바인딩하려는 특정 속성을 사용하도록 설정하십시오. // 자세한 내용은 https://go.microsoft.com/fwlink/?LinkId=317598을(를) 참조하십시오. [HttpPost] [ValidateAntiForgeryToken] public ActionResult Create([Bind(Include = "ID,LastName,FirstMidName,EnrollmentDate")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return RedirectToAction("Index"); } return View(student); } // GET: Students/Edit/5 public ActionResult Edit(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Student student = db.Students.Find(id); if (student == null) { return HttpNotFound(); } return View(student); } // POST: Students/Edit/5 // 초과 게시 공격으로부터 보호하려면 바인딩하려는 특정 속성을 사용하도록 설정하십시오. // 자세한 내용은 https://go.microsoft.com/fwlink/?LinkId=317598을(를) 참조하십시오. [HttpPost] [ValidateAntiForgeryToken] public ActionResult Edit([Bind(Include = "ID,LastName,FirstMidName,EnrollmentDate")] Student student) { if (ModelState.IsValid) { db.Entry(student).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(student); } // GET: Students/Delete/5 public ActionResult Delete(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Student student = db.Students.Find(id); if (student == null) { return HttpNotFound(); } return View(student); } // POST: Students/Delete/5 [HttpPost, ActionName("Delete")] [ValidateAntiForgeryToken] public ActionResult DeleteConfirmed(int id) { Student student = db.Students.Find(id); db.Students.Remove(student); db.SaveChanges(); return RedirectToAction("Index"); } protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); } } }

- Index를 살짝 수정했는데

sortOrder를 이용해서 현재 들어오는 데이터의 값을 이용해서 sorting을 해준다

아래에 보면 pageSize가 있는데 

현재 pageNumber가 즉 page가 null이면 1을 아니면 page를 넣어주는

(page ?? 1)을 사용했다

DAL/SchoolContext.cs

using myWebAppWithEF6.Models; using System; using System.Collections.Generic; using System.Data.Entity; using System.Data.Entity.ModelConfiguration.Conventions; using System.Linq; using System.Web; namespace myWebAppWithEF6.DAL { public class SchoolContext:DbContext { public SchoolContext() : base("SchoolContext"){ } public DbSet<Student> Students { get; set; } public DbSet<Enrollment> Enrollments { get; set; } public DbSet<Course> Courses { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Conventions.Remove<PluralizingTableNameConvention>(); } } }

- 현재 만들고 싶은 테이블을 모아놓은 곳!

DAL/SchoolInitializer.cs
using myWebAppWithEF6.Models; using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace myWebAppWithEF6.DAL { public class SchoolInitializer : System.Data.Entity.DropCreateDatabaseIfModelChanges<SchoolContext> { protected override void Seed(SchoolContext context) { var students = new List<Student> { new Student{FirstMidName="Carson",LastName="Alexander",EnrollmentDate=DateTime.Parse("2005-09-01")}, new Student{FirstMidName="Meredith",LastName="Alonso",EnrollmentDate=DateTime.Parse("2002-09-01")}, new Student{FirstMidName="Arturo",LastName="Anand",EnrollmentDate=DateTime.Parse("2003-09-01")}, new Student{FirstMidName="Gytis",LastName="Barzdukas",EnrollmentDate=DateTime.Parse("2002-09-01")}, new Student{FirstMidName="Yan",LastName="Li",EnrollmentDate=DateTime.Parse("2002-09-01")}, new Student{FirstMidName="Peggy",LastName="Justice",EnrollmentDate=DateTime.Parse("2001-09-01")}, new Student{FirstMidName="Laura",LastName="Norman",EnrollmentDate=DateTime.Parse("2003-09-01")}, new Student{FirstMidName="Nino",LastName="Olivetto",EnrollmentDate=DateTime.Parse("2005-09-01")} }; students.ForEach(s => context.Students.Add(s)); context.SaveChanges(); var courses = new List<Course> { new Course{CourseID=1050,Title="Chemistry",Credits=3,}, new Course{CourseID=4022,Title="Microeconomics",Credits=3,}, new Course{CourseID=4041,Title="Macroeconomics",Credits=3,}, new Course{CourseID=1045,Title="Calculus",Credits=4,}, new Course{CourseID=3141,Title="Trigonometry",Credits=4,}, new Course{CourseID=2021,Title="Composition",Credits=3,}, new Course{CourseID=2042,Title="Literature",Credits=4,} }; courses.ForEach(s => context.Courses.Add(s)); context.SaveChanges(); var enrollments = new List<Enrollment> { new Enrollment{StudentID=1,CourseID=1050,Grade=Grade.A}, new Enrollment{StudentID=1,CourseID=4022,Grade=Grade.C}, new Enrollment{StudentID=1,CourseID=4041,Grade=Grade.B}, new Enrollment{StudentID=2,CourseID=1045,Grade=Grade.B}, new Enrollment{StudentID=2,CourseID=3141,Grade=Grade.F}, new Enrollment{StudentID=2,CourseID=2021,Grade=Grade.F}, new Enrollment{StudentID=3,CourseID=1050}, new Enrollment{StudentID=4,CourseID=1050,}, new Enrollment{StudentID=4,CourseID=4022,Grade=Grade.F}, new Enrollment{StudentID=5,CourseID=4041,Grade=Grade.C}, new Enrollment{StudentID=6,CourseID=1045}, new Enrollment{StudentID=7,CourseID=3141,Grade=Grade.A}, }; enrollments.ForEach(s => context.Enrollments.Add(s)); context.SaveChanges(); } } }

- DB를 만들고 초기값으로 넣은 데이터!

아래는 테이블&열

class를 가져온 것을 보고 table간의 관계를 알 수 있다.

Models/Course.cs
using System.Collections.Generic; namespace myWebAppWithEF6.Models { public class Course { public int CourseID { get; set; } public string Title { get; set; } public int Credits { get; set; } public virtual ICollection<Enrollment> Enrollments { get; set; } } }

Models/Enrollment.cs
namespace myWebAppWithEF6.Models { public enum Grade { A, B, C, D, F } public class Enrollment { public int EnrollmentID { get; set; } public int CourseID { get; set; } public int StudentID { get; set; } public Grade? Grade { get; set; } //virtual : 하위 클래스에서 재정의 할 수 있음을 나타냄 (override) public virtual Course Course { get; set; } public virtual Student Student { get; set; } } }

Models/Student.cs
using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace myWebAppWithEF6.Models { public class Student { public int ID { get; set; } public string LastName { get; set; } public string FirstMidName { get; set; } public DateTime EnrollmentDate { get; set; } public virtual ICollection<Enrollment> Enrollments { get; set; } } }

당연히 모든걸 생성한 뒤에는

1) 초기에는

Enable-Migrations -ContextTypeName 프로젝트이름.DAL.SchoolContext

2) 수정한 후에는

add-migration 파일이름

update-database

Web.config

<configuration> <!-- 추가 (App_Data에 추가하기 위해) --> <connectionStrings> <add name="SchoolDBContext" connectionString="Data Source=.;Initial Catalog=Movies;AttachDbFilename=|DataDirectory|\SchoolContext.mdf;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> </configuration> <entityFramework> <!-- 추가 --> <contexts> <context type="myWebAppWithEF6.DAL.SchoolContext, myWebAppWithEF6"> <databaseInitializer type="myWebAppWithEF6.DAL.SchoolInitializer, myWebAppWithEF6" /> </context> </contexts> </entityFramework>

Views/Students/Index.cshtml
@model PagedList.IPagedList<ContosoUniversity.Models.Student> @using PagedList.Mvc; <link href="~/Content/PagedList.css" rel="stylesheet" type="text/css" /> @{ ViewBag.Title = "Students"; } <h2>Students</h2> <p> @Html.ActionLink("Create New", "Create") </p> @using (Html.BeginForm("Index", "Student", FormMethod.Get)) { <p> Find by name: @Html.TextBox("SearchString", ViewBag.CurrentFilter as string) <input type="submit" value="Search" /> </p> } <table class="table"> <tr> <th> @Html.ActionLink("Last Name", "Index", new { sortOrder = ViewBag.NameSortParm, currentFilter = ViewBag.CurrentFilter }) </th> <th> First Name </th> <th> @Html.ActionLink("Enrollment Date", "Index", new { sortOrder = ViewBag.DateSortParm, currentFilter = ViewBag.CurrentFilter }) </th> <th></th> </tr> @foreach (var item in Model) { <tr> <td> @Html.DisplayFor(modelItem => item.LastName) </td> <td> @Html.DisplayFor(modelItem => item.FirstMidName) </td> <td> @Html.DisplayFor(modelItem => item.EnrollmentDate) </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> <br /> <!-- if there are no pages to display page 0 of - is shown --> Page @(Model.PageCount < Model.PageNumber ? 0 : Model.PageNumber) of @Model.PageCount <!-- page button display --> @Html.PagedListPager(Model, page => Url.Action("Index", new { page, sortOrder = ViewBag.CurrentSort, currentFilter = ViewBag.CurrentFilter }))

- Index.cshtml에서 볼 것은 아래 PagedList를 이용한 것이다

++) Logger를 생성하기 위한 폴더를 따로 만들 수도 있다

Logging/ILogger.cs

using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace myWebAppWithEF6.Logging { public interface ILogger { void Information(string message); void Information(string fmt, params object[] vars); void Information(Exception exception, string fmt, params object[] vars); void Warning(string message); void Warning(string fmt, params object[] vars); void Warning(Exception exception, string fmt, params object[] vars); void Error(string message); void Error(string fmt, params object[] vars); void Error(Exception exception, string fmt, params object[] vars); void TraceApi(string componentName, string method, TimeSpan timespan); void TraceApi(string componentName, string method, TimeSpan timespan, string properties); void TraceApi(string componentName, string method, TimeSpan timespan, string fmt, params object[] vars); } }

Logging/Logger.cs
using System; using System.Collections.Generic; using System.Diagnostics; using System.Linq; using System.Text; using System.Web; namespace myWebAppWithEF6.Logging { /* * 사용 방법 * : private ILogger _logger = new Logger(); * _logger.Information("Returning transient error for command: {0}", command.CommandText); */ public class Logger : ILogger { public void Information(string message) { Trace.TraceInformation(message); } public void Information(string fmt, params object[] vars) { Trace.TraceInformation(fmt, vars); } public void Information(Exception exception, string fmt, params object[] vars) { Trace.TraceInformation(FormatExceptionMessage(exception, fmt, vars)); } public void Warning(string message) { Trace.TraceWarning(message); } public void Warning(string fmt, params object[] vars) { Trace.TraceWarning(fmt, vars); } public void Warning(Exception exception, string fmt, params object[] vars) { Trace.TraceWarning(FormatExceptionMessage(exception, fmt, vars)); } public void Error(string message) { Trace.TraceError(message); } public void Error(string fmt, params object[] vars) { Trace.TraceError(fmt, vars); } public void Error(Exception exception, string fmt, params object[] vars) { Trace.TraceError(FormatExceptionMessage(exception, fmt, vars)); } public void TraceApi(string componentName, string method, TimeSpan timespan) { TraceApi(componentName, method, timespan, ""); } public void TraceApi(string componentName, string method, TimeSpan timespan, string fmt, params object[] vars) { TraceApi(componentName, method, timespan, string.Format(fmt, vars)); } public void TraceApi(string componentName, string method, TimeSpan timespan, string properties) { string message = String.Concat("Component:", componentName, ";Method:", method, ";Timespan:", timespan.ToString(), ";Properties:", properties); Trace.TraceInformation(message); } private static string FormatExceptionMessage(Exception exception, string fmt, object[] vars) { // Simple exception formatting: for a more comprehensive version see // http://code.msdn.microsoft.com/windowsazure/Fix-It-app-for-Building-cdd80df4 var sb = new StringBuilder(); sb.Append(string.Format(fmt, vars)); sb.Append(" Exception: "); sb.Append(exception.ToString()); return sb.ToString(); } } }