SQL语句的类型转换

Question

 PsProductDataContext db = new PsProductDataContext();

 public List<PsProduct> StaticReport()
        {
            return (from c in db.PsProduct
                   select c.ShCompanyName).ToList();
        }

这段代码系统报 无法将类型“system.collection .generic.list<string>隐士转换为system.collection .generic.list<qdrkProductMvc.Models.PsProduct>，我把代码改为

  public IQueryable<PsProduct> StaticReport()
        {
            return from c in db.PsProduct
                   select c.ShCompanyName;
        }

还是报相同的错，请高手指教

Answer 1

linq to sql没弄过，估计应该是这样写：return (from c in db.PsProdcut select c).ToList(),你那样写仅仅只返回一个ShCompanyName字段