MVC Linq多表联查

最新推荐文章于 2021-11-10 20:07:29 发布

yyixin

最新推荐文章于 2021-11-10 20:07:29 发布

阅读量5k

点赞数

文章标签： linq mvc string equals class join

本文链接：https://blog.csdn.net/yyixin/article/details/5810520

版权

public class ResultAdList { public int A_Id; public string A_userid; public int B_Id; public string B_typename; } public class AdRepository { private DataAdDataContext db = new DataAdDataContext(); public IQueryable<ResultAdList> AdList { get; private set; } public AdRepository() { this.AdList = from a in db.R_ad_list join b in db.R_ad_type on a.A_typeid equals b.id select new ResultAdList { A_Id = a.id, A_userid = a.A_userid, B_Id = b.id, B_typename=b.T_ad_typename }; } }

public ActionResult Index() { return View("Index", new AdRepository()); }

<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage<Dmj.Models.AdRepository>" %>

<% foreach (var item in Model.AdList) { %>

-----------------

<% } %>