Fix the redundant space when convert to pivot table with multiple row selector.

DotNetNext / SqlSugar

.Net aot ORM Fastest ORM Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping

https://www.donet5.com/Home/Doc

MIT License

5.19k stars 1.32k forks source link

Fix the redundant space when convert to pivot table with multiple row selector. #1212

Closed haib0 closed 6 months ago

haib0 commented 6 months ago

When use ToPivotTable, if the row selector parameter has multiple fields, like

xxx.ToPivotTable(t1 => t1.A, t1 => new { t1.B, t1.C }, t1 => xxx);

, then the value of result DataTable will has a redundant space in front of it, while the last column also has a redundant space in end.