DataGrid SortBy Func #7597

Bug type

Component

Component name

DataGrid

What happened?

Here you can how im using the PropertyColumn component. When i try to sort by the Bank property of my data model its not working, the Column name being sent by the data grid is CurrencyExchangeRate.MiddleRate.
I cant reproduce the same thing on trymudblazor so ill paste in an empty link. I believe i have explained everything in such detail that it can be understood without a demo and i have provided what i believe is a solution to the issue. I will also try to create a PR and try to fix it myself.

Expected behavior

I would expect that the DataGrid sends the column defined in the SortBy property instead of the one defined in the Property property. I Belive the issue is in the picture. The higlighted property called PropertyColumn has the value "CurrencyExchangeRate.MiddleRate". You should use Column.SortyBy to get the name of the column i want to sort by.
In the second picture you can see how the PropertyName is being retrieved, i believe you could retrieve the SortBy property name in the same way.

Column.SortBy should be changed from Func to Expression

Now you could use the same logic applied to Property to SortBy

Refactor the code in places where you currently have the call to Column.SortyBy property to call the Func. So you should have a field of type Func which u initialize like - field = SortBy.Compile(); Now you can use the func where you need. You can find those places by searching for SortBy references.

Reproduction link

https://try.mudblazor.com/snippet/tVhbb-JGFH4OfyIjqw9Gapxtpb4kQCFskk21uWiN-lJV0WAmMM3YY82MAyTiv_fMxfgGJkitHwKZc5vznat5fr7HNAkEfufidJhJmsxRuJaKxMEDUcE3pdLgD8mTjqPdZ7MrppmD6xWOU0Zk8BUrHNzzGWGyM6TJPyRSSMuNGSWJQovt106nB-Ka_VbQGZr0vWtGYiB46A4Myr43dAfSQzeUKSLwlJG-p0RG8hNtCBhzLcVhMOYsixN78IMvvUEHwdOzx9L-Z06eBE-JUGtLQfm_fW-F-gO0Ch6yeEqEhyZUaesPonqbF8wkXOf8CI0hnSdewW9krMoJARCxIlWiYQCs7iKeXGVK8QQ9JgBi9AquP6bEeQm4AQMcPVP49FBI3zU2-iMIY8xY5ZZlxY9vRDC8Rn9SSY1Tw-cXo1Ir90rGfL-rXShRUR8ZBLp7lT_xlIN-pLnrmkdJtODiUdA5BZr9DK44uBiPIfAGdoET-cJFXOOa8NSxNKzqJ1Rr7ciSztTi4pffvqQrQPzkpHa3UOHoFYUpjiCb-94Xr-lCiXu8INHrFV_pXJ1yDnh-x1PC-l5ImE7zkYZ4B-pGjsy089Jwjkqn4wVO5oYYFrQdULbdOvdW4_zC-PJsfYEzxS9jvDpbEDpfqItfHQR71OpnCCgTHC2Q_4YFolCDiCYIUkmRlQpMTXbb5D_aiAcxHPo_eR_aqCmPjdc9AKXvsCQzczOo90RB75K-1tHt7s6K2tMIgQ-us4yYJA-deke1lJ-RU98SIv1s9sbvPA_gJ0IMfcu1u1ZjRqLRGFytjhnBwjaIkVwnke8CCj4MDM3cyEp_2gp0Ni7AhvkMngSNsVjvaBSjNGXrPcbt8WesH8CsTD5pEFz7qbXb8339tnde7d7HDAocHzkInrikiupefYzUPWe4mEfmPxRjKY_Tcit4lm61jAGEOdcxdDp655VJ2XvCcyJ0jUHPLVkpTXDDURnjW1VVYROWXGrQ6QwjmNeue9xdJ1lsR2vP6RmgfA2AWZOQJfpOpdoS_e6lEfyG5SIkxTmqtgcrup_ZDqUdrDZPvpIXmphQNWQKkhXQTQ0VfR606QK2NKmE3prMfAaCHtcyuAfoBcUseMwUowmZBa5gmLrslFQ2Z64jp4Ir4ynSiQ6YEoR1saEJlq9Qk3f6ephBF53ZIrRdvGjXJXzxEtPykhbcEnUjeKyXPiPcq6A_8L0lmeKUnkNyUT6jkdKh8xx4-mnEIbcGE9zFwS-zVyPxKeYiBC5D9gZtK1mdVZb_Jksip2RV2nJq42VVzMCNvcnGhuGNwxZbbGMNlKsBLJJik0eRvkEmWDX12WMywA0g54sdRDUb9AW5CVbxrzYqR7OZnZIFkrCtkzaRHySG5MqlKvYacziDy_VLoTMnfnfnleoV0nYXy-syfwdypaRvDD37fWynT1HD-Tiqh-r_zNnPF38uYosyX8RGJkkB1rqPjWpoXrHaPdoxbMzuIzGsglLLklZoaoW3J5_Q74cxRBd1HiCxY1BuoPBfoFyqcUjqUnXvSUSb-YajVny1Yv9oqeGDmbnZXYFtOm0SNpVsOptTZyyI5GnlhwTYK7QGg-4tSSAs0WWnwjHRAdATJwhN0Og7tvO1k8CKJeG9hxz65cFeOs2msI-iiMF2lDtfQ9ixuMlsliL0geZEXSKp_2zqnBSyMd_b2jmdTr0WHlZpf2Wo8W0Z_9Jo5CucVuh70rwQdf_eY1W_RLVbnXH4BCDN_tjKeWdmPnWrWKQEhG7fTZ3IdhNx15nw0Hzx9-WqICoTCYJ3QPP6h87Qh_Zz4-1IrX8B

Reproduction steps

I try to sort the CurrencyExchangeRate column and i get the explained error.

Relevant log output

No response

Version (bug)

6.0.9

Version (working)

No response

What browsers are you seeing the problem on?

Chrome, Microsoft Edge

On what operating system are you experiencing the issue?

Windows

Pull Request

I would like to do a Pull Request

Code of Conduct

I agree to follow this project's Code of Conduct