[已解决问题] 这条sql语句转成linq怎么写啊
提问时间: 2008-04-01 16:24
悬赏分：30 浏览:246 次
该表是Northwind中的Products表
最佳答案
var db = new NorthwindDataContext();
var categoryId = (from p in db.Products where p.ProductId equals 1).Single().CategoryId;
var products = from p in db.Products where p.CategoryId equals categoryId;
提问者对于答案的评价：谢谢～～，
var categoryId = (from p in db.Products where p.ProductId equals 1).Single().CategoryId;
var products = from p in db.Products where p.CategoryId equals categoryId;
2008/4/1 19:00:08
回答者：deerchao
提问者对于答案的评价：谢谢～～，
评论
|
3个月前 lexus : 为什么没人帮我啊 |
|
|
3个月前 deerchao : 不好意思,好像少打了几个字: var categoryId = (from p in db.Products where p.ProductId==1 select p).Single().CategoryId; var products = from p in db.Products where p.CategoryId == categoryId select p; |