ASP. net mvc Entity Framework getting started tutorial and source code, mvcentity
The main purpose of this article is
1. describes how to use Entity Framework Power Tools.
2. Entity Framework quick door
Lab environment:
OS: Windows Server 2012, Windows 7
DE: VS2013 + MVC 6.0 + Entity Framework + SQL Server 2012
Preparations
To generate a POCO data class and database context based on an existing database, you must use the Entity Framework Power Tools (a Code First reverse engineering tool) Extension of Visual Studio ). Enter "Entity Framework Power" in the Visual Studio extension to search for the latest extension.
Var Courses = db. courses. where (c => c. title = "Physics "). orderBy (c => c. title); foreach (var c in Courses) {Console. writeLine (c. title );}Add
Models.Course model = new Course();model.Title = "test";model.DepartmentID = 1;model.CourseID = 4;db.Courses.Add(model);db.SaveChanges();
Modify
Models.Course model = new Course();var result = (from r in db.Courses where r.Title.StartsWith("test") orderby r.Title descending select r).FirstOrDefault();model = (Course)result;model.Credits = 4;model.Title = "good job";db.SaveChanges();
Delete
var result = from r in db.Courses where r.CourseID == 4 select r;foreach (var c in result) { db.Courses.Remove(c); }db.SaveChanges();
Simple Function compute (count, min, max, sum)
var result = (from r in db.StudentGrades where r.StudentID == 2 select r).Sum(p=>p.Grade);Console.WriteLine(result);var result = (from r in db.StudentGrades where r.StudentID == 2 select r).Max(p => p.Grade); Console.WriteLine(result);
Paging Data Query
var result = (from r in db.People orderby r.LastName ascending select r).Skip(5).Take(5);foreach(var c in result) { Console.WriteLine(c.LastName); }
Group
var ss = from r in db.StudentGrades orderby r.StudentID descending group r by new { r.StudentID, r.CourseID } into g select new { g.Key, grade = g.Sum(r => r.Grade) };foreach (var r in ss) { string output = "StudentID:" + r.Key.StudentID + " CourseID:" + r.Key.CourseID+" grade"+r.grade; Console.WriteLine(output); }
Complex association query
var d = db.Database.SqlQueryForDynamic(@"SELECT c.CourseID,d.[Name] as department,c.TitleFROM Course c INNER JOIN Department d ON c.DepartmentID = d.DepartmentID"); foreach (dynamic item in d) { var s = item.Title;Console.WriteLine(s); }Console.ReadLine();
Welcome to The Penguin Group 238473238
Http://files.cnblogs.com/williamzhu/EFPowerToolsSample.zip