1.通过nuget安装System.Linq.Dynamic.Core
2.C#代码
lpm是数据源 条件和查询语句可以使用字符串进行拼接
using System.Linq.Dynamic.Core;
var dynamicQuery = lpm.AsQueryable()
.GroupBy("new (Drug as Drug,Department,Area)","it")
.Select("new(it.Key,it.Key.Drug,it.Key.Department,it.Key.Area, Count() AS count)")
.OrderBy("count desc")
.ToDynamicList();
datagrid.ItemsSource = dynamicQuery;