摘要: select REPLICATE(0,5); 五个零 阅读全文
posted @ 2015-03-05 15:28 JJ.Net 阅读(270) 评论(0) 推荐(0)
摘要: var average = list.Select(e => e.PROPERTY3).Average(); average = list.Average(e => e.PROPERTY3); 阅读全文
posted @ 2015-03-04 15:17 JJ.Net 阅读(184) 评论(0) 推荐(0)
摘要: var min = list.Select(e => e.PROPERTY3).Min(); min = list.Min(e => e.PROPERTY3); 阅读全文
posted @ 2015-03-04 15:09 JJ.Net 阅读(113) 评论(0) 推荐(0)
摘要: var max = list.Select(e => e.PROPERTY3).Max(); max = list.Max(e => e.PROPERTY3); 阅读全文
posted @ 2015-03-04 15:08 JJ.Net 阅读(165) 评论(0) 推荐(0)
摘要: 类似 select top1 var take = list.Take(10); 2 take = (from e in list select e).Take(10); 阅读全文
posted @ 2015-03-04 14:24 JJ.Net 阅读(197) 评论(0) 推荐(0)
摘要: 1 var count = (from e in list select e).Count(); 阅读全文
posted @ 2015-03-03 11:48 JJ.Net 阅读(193) 评论(0) 推荐(0)
摘要: 1 var d = (from e in list 2 select e.PROPERTY).Distinct(); 阅读全文
posted @ 2015-03-02 16:00 JJ.Net 阅读(219) 评论(0) 推荐(0)
摘要: 1 var c = from e in list2 select new3 {4 e.PROPERTY,5 ... 阅读全文
posted @ 2015-03-02 15:58 JJ.Net 阅读(126) 评论(0) 推荐(0)
摘要: 1 public class Class1 2 { 3 public string PROPERTY 4 { 5 get; 6 set; 7 } 8 public string ... 阅读全文
posted @ 2015-03-02 13:32 JJ.Net 阅读(122) 评论(0) 推荐(0)
摘要: 注意表设计允许null属性,空数据录入失败,而且有时错误在程序中抛不出,很难查找错误 阅读全文
posted @ 2015-02-28 15:28 JJ.Net 阅读(123) 评论(0) 推荐(0)