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字段