String replace, strip one value from another in LINQ query

Question

I have the following controller method where the AppVersion contains the exact value in Name, with some other string, like Name: Some Application, AppVersion: Some Application - Production. I need to strip the value of Name from the value of AppVersion. I tried to search but not sure what I am looking for.

public IActionResult GetByAppId(string Id)
{
    return new JsonResult(_db.Applications
        .Select(a => new
        {
            a.Id,
            a.AppId,
            a.Name,
            a.AppVersion
        })
        .Where(a => a.Id == Id)
        .SingleOrDefault()
    );
}

Examples of current output:

Name: Employee Recognition
AppVersion: Employee Recognition - Acceptance

Name: Content Delivery Platform (CDP)
AppVersion:  Content Delivery Platform (CDP) - pod 2 - Production

Some example current output and desired output would be good. — Magnus
– Magnus, Commented Aug 6, 2018 at 13:49
Can you please provide at least 2 example-values for AppVersion? — Dominik
– Dominik, Commented Aug 6, 2018 at 13:50
Don't mix the query with the JsonResult call. Store the result in a variable and modify the properties. — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Aug 6, 2018 at 13:51

Tomas Smagurauskas · Accepted Answer · 2018-08-06 13:55:10Z

5

You can replace it with nothing:

public IActionResult GetByAppId(string Id)
{
    return new JsonResult(_db.Applications
        .Select(a => new
        {
            a.Id,
            a.AppId,
            a.Name,
            AppVersion = a.AppVersion.Replace(a.Name, "")
        })
        .Where(a => a.Id == Id)
        .SingleOrDefault()
    );
}

answered Aug 6, 2018 at 13:55

Tomas Smagurauskas

7066 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Connie DeCinko CS Over a year ago

Thanks! Exactly what I was looking for, just could not quite get the syntax right.

Collectives™ on Stack Overflow

String replace, strip one value from another in LINQ query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related