如何围绕 linq 中的每条记录旋转并在视图中显示该记录

Question

我的数据库中有四个表，我想加入它并返回记录并将其显示到 searchController 中！

我的查询是这样的：

public IQueryable PerformSearch(string query)
{
    if (!string.IsNullOrEmpty(query))
    {
        var results = from tbl1 in context.Table1
                      join tbl2 in context.Table2 on tbl1.Id equals tbl2.Id
                      join tbl3 in context.Table3 on tbl2.Id equals tbl3.Id
                      join tbl4 in context.Table4 on tbl3.Id equals tbl4.Id
                      where tbl1.col2.Contains(query)
                      orderby tbl1.Count descending
                      select new
                      {
                          col1 = tbl1.Col1,
                          col1 = tbl1.Col1,
                          col1 = tbl1.Col1,
                                  .
                                  .
                                  .
                      };
        return results.AsQueryable();
    }
    else return null;
}

这个方法在 SearchController 中调用如下：

public class SearchController : System.Web.Mvc.Controller
{
    public System.Web.Mvc.ActionResult Search(System.String query)
    {
        var search = new Search();
        ViewData["result"] = search.PerformSearch(query);
        return View("Search");
    }
}

我不知道如何围绕 PeformSeach 方法返回的每条记录（加上与智能感知功能）进行旋转并在视图中显示！这也是个好办法吗？

提前致谢

Answer 1

我建议为此使用强类型视图。

首先从 PerformSearch 返回一个模型对象而不是 IQueryable。将此模型对象设置为您的视图。

一旦您的视图知道需要显示什么类型的数据，您就可以使用智能感知。

public class Record
{
    public int Col1 { get; set; }
    public string Col2 { get; set; }
    ...
}

public IList<Record> PerformSearch(string query)
{
    var records = new List<Record>();

    if (!string.IsNullOrEmpty(query))
    {
        return (from tbl1 in context.Table1
                join tbl2 in context.Table2 on tbl1.Id equals tbl2.Id
                join tbl3 in context.Table3 on tbl2.Id equals tbl3.Id
                join tbl4 in context.Table4 on tbl3.Id equals tbl4.Id
                where tbl1.col2.Contains(query)
                orderby tbl1.Count descending
                select new Record
                {
                    col1 = tbl1.Col1,
                    col1 = tbl1.Col1,
                    col1 = tbl1.Col1
                }).ToList();
    }

    return records;
}

//ActionMethod
public System.Web.Mvc.ActionResult Search(System.String query)
{
    var search = new Search();
    var model = search.PerformSearch(query);
    return View(model);
}

//View
<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<System.Collections.IList<Record>>" %>

<% foreach (var record in Model) { %>
    <%= Html.Encode(record.Col1) %> --this will now give you intellisense
<% } %>