ASP-.NET在MVC中使用LINQ实现多表联查.doc

1. 使用到的数据库：2. 程序文件：a) Model：teacherModel.cs3. using System;4. using System.Collections.Generic;5. using System.ComponentModel.DataAnnotations;6. using System.ComponentModel.DataAnnotations.Schema;7. using System.Data.Entity;8. using System.Globalization;9. using System.Web.Security;10. using System.Data.SqlClient;11. using MvcApplication3.publicclass;12. using System.Linq;13.14.15. namespace MvcApplication3.Models16. 17. 18. public class TeacherDbContext : DbContext19. 20. public TeacherDbContext()21. : base(TeacherDbContext)22. 23. 24. public DbSet teachers get; set; 25. public DbSet tasks get; set; 26.27. 28. 29.30. Table(teacherInfo)31. public class teacherInfo32. 33. Key34. DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)35. public string tid get; set; 36.37. Required38. Display(Name = 用户名)39. public string userName get; set; 40.41. Required42. Display(Name = 密码)43. public string pwd get; set; 44.45. Required46. Display(Name = 姓名)47. public string name get; set; 48.49. Required50. Display(Name = 性别)51. public string xingbie get; set; 52.53. Required54. Display(Name = 系部)55. public string xibu get; set; 56.57. Required58. Display(Name = 电话)59. public string phone get; set; 60. 61. Table(task)62. public class task63. 64. Key65. DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)66. public string id get; set; 67.68. Required69. Display(Name = 作业)70. public string zuoye get; set; 71.72. Required73. Display(Name = 教师编号)74. public string tid get; set; 75.76. 77.78. Required79. Display(Name = 次数)80. public string countnumber get; set; 81.82. Required83. Display(Name = 识别码)84. public string keytodiff get; set; 85.86. 87. 88. public class teacherAndTask89. 90.91. public string userName get; set; 92.93. 94. public string pwd get; set; 95.96. 97. public string name get; set; 98.99. 100. public string xingbie get; set; 101.102. 103. public string xibu get; set; 104.105. 106. public string phone get; set; 107.108. 109. public string id get; set; 110.111. 112. public string zuoye get; set; 113.114. 115. public string tid get; set; 19. public string countnumber get; set; 120.121. 122. public string keytodiff get; set; 123.124. 125. 126.127. public class Login128. 129. DBClass dbObj;130. public Login()131. 132. dbObj = new DBClass();133. 134. 135.136. a) View: Index.cshtml137. model IEnumerable138.139. using System.Collections140. using MvcApplication3.Models141. 142. 143. ViewBag.Title = Index;144. TeacherDbContext db =new TeacherDbContext();145. 146. 147.148. Index149.150. 151. Html.ActionLink(Create New, Create)152. 153. 154. 155. 156. Html.DisplayNameFor(model = model.userName)157. 158. 159. Html.DisplayNameFor(model = model.pwd)160. 161. 162. Html.DisplayNameFor(model = )163. 164. 165. Html.DisplayNameFor(model = model.xingbie)166. 167. 168. Html.DisplayNameFor(model = model.xibu)169. 170. 171. Html.DisplayNameFor(model = model.phone)172. 173. 174. Html.DisplayNameFor(model = model.zuoye)175. 176. 177. Html.DisplayNameFor(model = model.tid)178. 179. 180. Html.DisplayNameFor(model = model.countnumber)181. 182. 183. Html.DisplayNameFor(model = model.keytodiff)184. 185. 186. 187.188. foreach (var item in Model) 189. 190. 191. 192. Html.DisplayFor(modelItem = item.userName)193. 194. 195. Html.DisplayFor(modelItem = item.pwd)196. 197. 198. Html.DisplayFor(modelItem = )199. 200. 201. Html.DisplayFor(modelItem = item.xingbie)202. 203. 204. Html.DisplayFor(modelItem = item.xibu)205. 206. 207. Html.DisplayFor(modelItem = item.phone)208. 209. 210. Html.DisplayFor(modelItem = item.zuoye)211. 212. 213. Html.DisplayFor(modelItem = item.tid)214. 215. 216. Html.DisplayFor(modelItem = item.countnumber)217. 218. 219. Html.DisplayFor(modelItem = item.keytodiff)220. 221. 222. Html.ActionLink(Edit, Edit, new id=item.id ) |223. Html.ActionLink(Details, Details, new id=item.id ) |224. Html.ActionLink(Delete, Delete, new id=item.id )225. 226. 227. 228.229. a) Controler: TTController.cs230. using System;231. using System.Collections.Generic;232. using System.Data;233. using System.Data.Entity;234. using System.Linq;235. using System.Web;236. using System.Web.Mvc;237. using MvcApplication3.Models;238.239. namespace MvcApplication3.Controllers240. 241. public class TTController : Controller242. 243. private TeacherDbContext db = new TeacherDbContext();244.245. /246. / GET: /TT/247.248. public ActionResult Index()249. 250. 251. var temp = from a in db.tasks252. join b in db.teachers253. on a.tid equals b.tid254. select255. new teacherAndTask256. 257. userName=b.userName,258. pwd=b.pwd,259. name=,260. xingbie =b.x