Asp.net web api MVC

Question

我想在此方法中添加另一个查询，即

从产品 ID =+ID 中选择product_name

但它给出了错误，因为列表sales_line表.. 如何解决这个问题？ 谁能帮我？

public List<sales_line> Get(int id)
{
using (project_smartEntities entities = new project_smartEntities())
{
entities.Configuration.ProxyCreationEnabled = false;
return entities.sales_lines.SqlQuery("Select * from sales_line where sales_id=" + id).ToList<sales_line>();
}
}

Answer 1

你使用Union SQL

Select *,'a' as type_select from sales_line
union all
Select *,'b' as type_select from sales_line1