带有LINQ和ASP.NET MVC的存储过程多表输出

this article here 解释一切。这是我链接的同一篇文章,在你的 previous SO question .

这里有一篇关于Linq to SQL和存储过程的文章,特别是“处理存储过程中的多个结果形状”一节: LINQ to SQL - Retrieving Data Using Stored Procedures .

这对你的案子有用吗?

否则,不使用linq to sql,可能使用 SqlDataReader 的 NextResult 要查看结果,例如:

IList<Employee> employees = new List<Employee>();
IList<Customer> customers = new List<Customer>();
using (SqlConnection connection = new SqlConnection
    (Properties.Settings.Default.NorthwindConnectionString))
using (SqlCommand command = new SqlCommand
    ("GetEmployeesAndCustomers", connection))
{
    command.CommandType = CommandType.StoredProcedure;
    connection.Open();
    using (SqlDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            Employee e = new Employee{EmployeeID = (int)reader["EmployeeID"]};
            employees.Add(e);
        }
        reader.NextResult();
        while (reader.Read())
        {
            Customer c = new Customer{CustomerID = (string)reader["CustomerID"]};
            customers.Add(c);
        }
    }
}

编辑:如何处理不容易适应域模型对象的自定义数据组合的示例;在本例中,检索订单以及订单的客户:

namespace Company.Application.ViewModel
{
    public class CustomerOrder
    {
        public string CustomerID { get; set; }
        public string CustomerName { get; set; }
        public int OrderID { get; set; }
        public DateTime? OrderDate { get; set; }
    }
}
namespace Company.Application.Repository
{
    public class CustomerOrderRepository
    {
        public IList<CustomerOrder> GetCustomerOrders()
        {
            NorthwindDataContext db = new NorthwindDataContext();
            var custorders = from customer in db.Customers
                             join order in db.Orders
                             on customer.CustomerID equals order.CustomerID
                             select new CustomerOrder
                             {
                                 CustomerID = customer.CustomerID,
                                 CustomerName = customer.CompanyName,
                                 OrderID = order.OrderID,
                                 OrderDate = order.OrderDate
                             };
            return custorders.ToList();
        }
    }
}

灵感来源:在 chapter 关于 NerdDinner ScottGuthrie谈到了如何创建自定义的“ViewModel”对象来保存来自连接的数据,例如那些不容易放入域模型对象的连接。