How can I interact with accented letters inside list?

Question

I was assigned to upgrade a web application that was created a long time ago. In that project, data in the database was access and modify and return with a dynamic list. The relationship of some items between tables was not related by Id but rather by their title. It returns me with a list of items in which column title was assigned by item title that unfortunately contain accented letters.

Exammple item return

I can't access these kinds of data since accented letters are either forbidden by coding rule or there's a way but I don't know how to use it, yet. I have tried the following code, surrounding those letters with [] but it doesn't work.

var maBuonList = list.Select(x => x.["Ẩm_Bã bùn"]).ToList();

I have also tried query without dot but it returns me with another error.

var maBuonList = list.Select(x => x["Ẩm_Bã bùn"]).ToList();

The error:

'Cannot apply indexing with [] to an expression of type 'System.Dynamic.ExpandoObject''

Error without dot

Indexer usage would be `x["Ẩm_Bã bùn"]`, not `x.["Ẩm_Bã bùn"]` (no `.` after `x`). — Lance U. Matthews, Apr 08 '21 at 04:44
I also tried that. Let me update my question with returned error. — , Apr 08 '21 at 04:46
cast it to a string, the dynamic things need explicit types when you extract them ```list.Select(x => (string)x["Ẩm_Bã bùn"]).ToList();``` — Keith Nicholas, Apr 08 '21 at 04:58
You need to explicitly cast `x` to an `IDictionary` before you can use `["..."]`. I have linked your question to a duplicate which describes how to do that. — Heinzi, Apr 08 '21 at 07:29

Yiyi You · Answer 1 · 2021-04-08T07:19:21.380

0

If you are getting list from db,you can use Column,and get List<SampleModel> rather than List<dynamic>:

public class SampleModel {
        public string Gio { get; set; }
        [Column("Ẩm_Bã bùn")]
        public double Ẩm_Bã_bùn { get; set; }


    }

edited Apr 08 '21 at 07:19

answered Apr 08 '21 at 07:11

Yiyi You

16,875
1
10
22

How can I interact with accented letters inside list?

1 Answers1