Modifications in json format

Question

This is my api in json format

[{"tu_id":1,"tu_name":"Akhil","tu_usrname":"Akhl","tu_pwd":"1234","tu_cntno":"423433"}]

I want ID instead of tu_id and Name instead of tu_name

this is my code in controller

public IEnumerable<TestUser> Get()
    {
        DataTable dt = new DataTable();
        TestUserBL userbl = new TestUserBL();
        dt = userbl.TestUserSel();
        var user = dt.AsEnumerable().Select(x => new TestUser
        {


              tu_id = x.Field<int>("tu_id"),
              tu_name = x.Field<string>("tu_name"),
              tu_usrname=x.Field<string>("tu_usrname"),
              tu_pwd=x.Field<string>("tu_pwd"),
              tu_cntno=x.Field<string>("tu_cntno")
            // like wise initialize properties here
        });

        return user;
    }

Here I cant change tu_id?

please follow coding conventions in your code as it matters a lot in case of clean code https://stackoverflow.com/a/1618325/5621827 — jitender, Jun 02 '17 at 11:02

jitender · Answer 1 · 2017-06-02T11:07:44.643

1

Change property names(tu_id to ID and tu_name to Name etc) in TestUser class they don't follow the conventions conventions then do mapping as follow:-

 var user = dt.AsEnumerable().Select(x => new TestUser
        {

              Id= x.Field<int>("tu_id"),
              Name = x.Field<string>("tu_name")
        });

edited Jun 02 '17 at 11:07

answered Jun 02 '17 at 10:39

jitender

10,238
1
18
44

Why copy-pasting my anser? – Sergey Berezovskiy Jun 02 '17 at 10:42
@jitender that's a definitely copy-paste :) you didn't even mention newtonsoft or attributes – Sergey Berezovskiy Jun 02 '17 at 10:50
@SergeyBerezovskiy ok bro if you think so(Am still not saying this) I edited my answer – jitender Jun 02 '17 at 10:56

score 1 · Accepted Answer · answered Jun 02 '17 at 10:39

1

You can use serialization attributes applied to properties of your TestUser class:

 [JsonProperty("ID")]
 public int tu_id { get; set; }

 [JsonProperty("Name")]
 public string tu_name { get; set; }

answered Jun 02 '17 at 10:39

Sergey Berezovskiy

232,247
41
429
459

header file to use this attribute – Akhil George Jun 02 '17 at 10:52
As he is a beginner I would still suggest renaming class properties as that will follow the code convention as well.Clean coding is what i am suggesting here – jitender Jun 02 '17 at 10:59
@jitender mixing original `tu_XXX` and 'pretty' property names is not clean coding. Renaming *all* properties - that is clean coding. – Sergey Berezovskiy Jun 02 '17 at 11:03
@SergeyBerezovskiy Why he will mix them(he should rename all off them) – jitender Jun 02 '17 at 11:05
@jitender check your answer please – Sergey Berezovskiy Jun 02 '17 at 11:06
@SergeyBerezovskiy Updated my answer also any beginner can know that all prop name should follow the same convention and if he goes with your approach what if he need this in future what we will do will he write [JsonProperty("")] on all props? – jitender Jun 02 '17 at 11:10

Modifications in json format

2 Answers2