LINQ to SQL收藏
1、LINQ group by分組彙總
public class TestData
{
public string Name{get;set;}
public int Count { get; set; }
public string BatNum { get; set; }
}
protected void Click(object sender, EventArgs e)
{
List<TestData> list = new List<TestData>();
list.Add(new TestData() { Name = "A", Count = 3, BatNum = "001" });
list.Add(new TestData() { Name = "A", Count = 3, BatNum = "001" });
list.Add(new TestData() { Name = "A", Count = 3, BatNum = "002" });
list.Add(new TestData() { Name = "b", Count = 3, BatNum = "001" });
list.Add(new TestData() { Name = "b", Count = 6, BatNum = "002" });
list.Add(new TestData() { Name = "b", Count = 3, BatNum = "003" });
list.Add(new TestData() { Name = "b", Count = 5, BatNum = "001" });
var query = from l in list
group l by new { l.Name, l.BatNum } into g
select new
{
Name = g.Key.Name,
Count = g.Sum(a => a.Count),
BatNum = g.Key.BatNum
};
string result = "";
foreach (var q in query)
{
result += "Name=/"" + q.Name + "/"," + "Count=/"" + q.Count + "/"," + "BatNum=/"" + q.BatNum + " /"<br />";
}
Response.Write(result);
}
//結果:
Name="A",Count="6",BatNum="001 "
Name="A",Count="3",BatNum="002 "
Name="b",Count="8",BatNum="001 "
Name="b",Count="6",BatNum="002 "
Name="b",Count="3",BatNum="003 "
2、
相關文章
- LINQ to SQLSQL
- LINQ系列:LINQ to SQL Transact-SQL函式SQL函式
- LINQ系列:LINQ to SQL Take/SkipSQL
- Linq to SQL 上篇SQL
- LINQ系列:LINQ to SQL Where條件SQL
- LINQ系列:LINQ to SQL Concat/UnionSQL
- LINQ系列:LINQ to SQL Join連線SQL
- LINQ系列:LINQ to SQL Select查詢SQL
- Linq to sql 分頁SQL
- Linq to sql 筆記SQL筆記
- Linq to sql 求和操作SQL
- LINQ系列:LINQ to SQL Group by/Having分組SQL
- LINQ系列:LINQ to SQL Exists/In/Any/All/ContainsSQLAI
- LINQ to SQL 中可以使用的LINQ函式SQL函式
- LINQ to SQL精彩文章收集SQL
- linq to sql 部落格集錦SQL
- Linq to sql 自定義型別SQL型別
- LINQ-to-SQL那點事~LINQ-to-SQL中的併發衝突與應對SQL
- LINQ-to-SQL那點事~LINQ-to-SQL中的資料快取與應對SQL快取
- ASP.Net LINQ to SQl查詢ASP.NETSQL
- 【轉】LINQ to SQL語句(1)之WhereSQL
- 為什麼說 LINQ 要勝過 SQLSQL
- 使用C#+Linq+SQL快速開發業務C#SQL
- LINQ-to-SQL那點事~利用反射在LINQ-to-SQL環境中實現Ado.net的CURD操作SQL反射
- LINQ to SQL語句之Insert/Update/Delete操作SQLdelete
- sql2008bi與EDM & LINQSQL
- Linq to SQL: System.InvalidCastException: Specified cast is not validSQLASTException
- linq to sql的多條件動態查詢SQL
- LINQ系列:LINQ to XML操作XML
- 當 Visual Studio 2005遇上LINQ To SQLSQL
- SQL調優13連問,收藏好!SQL
- LINQ系列:LINQ to XML查詢XML
- LINQ系列:LINQ to DataSet的DataTable操作
- LINQ系列:LINQ to DataSet的DataView操作View
- LINQ系列:Linq to Object投影操作符Object
- LINQ系列:Linq to Object限制操作符Object
- LINQ系列:Linq to Object排序操作符Object排序
- LINQ系列:Linq to Object聚合操作符Object