04 2009 档案
摘要:优酷 - 歌曲:http://v.youku.com/v_playlist/f2054483o1p10.html
阅读全文
摘要:join语句: join语句 Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> var query = from tblMaterialInZhiSi in objPlantDataClassesDataContext.tbl_Materia...
阅读全文
摘要:Linq 增删改查例子 Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->public class WorkshopDAL { PlantDataClassesDataContext objPlantDataClasse...
阅读全文
摘要:多个条件查询(相当于根据多个条件进行合并一些相同的元素,个人觉得分组统计时用到)
var q =
from p in db.Products
group p by new
{
p.CategoryID,
p.SupplierID
}
into g
select new
{
g.Key,
g
};
求最大值(按照相同的做法可以,求最小值,求和 ,求平均值...
var q =
from p in db.Products
group p by p.CategoryID into g
select new {
g.Key,
MaxPrice = g.Max(p => p.UnitPrice)
};
对于统计的数据进行遍历
foreach (var gp in q)
{
if (gp.Key == 2)
{
foreach
阅读全文
摘要:http://book.51cto.com/art/200812/100240.htm
阅读全文

浙公网安备 33010602011771号