C# 8: Linq Select, Parse String into Nullable Int

Question

I am trying to Parse a String into Nullable int, with Linq select. The following last line is not working in Select. Receiving Error below. How can it be fixed?

Resource: https://stackoverflow.com/a/45066/13889515

var aviationInfo = _dbContext.Cpamlt
                    .Where(c=> c.Account == bppInfoRequestDto.AccountNumber)
                    .Select(cpamlt => new BppAviationInfoDto()
                    {
                        AccountNumberIdentityId = cpamlt.Cpamltid,
                        SerialNumber = cpamlt.Vinserno,
                        Manufacturer = cpamlt.Manmod,
                        MakeModel = cpamlt.Manmak,
                        YearManufactured = Int32.TryParse(cpamlt.Manyr, out tempVal) ? Int32.Parse(cpamlt.Manyr) : (int?)null,

Error: The name 'tempVal' does not exist in the current context

Trying to avoid Extension Methods if possible

Using Net Core 3.1 with C#8

Can't you just create a method CanBeParsed that wraps TryParse — Hayden
– Hayden, Commented Sep 27, 2020 at 2:47
This looks like an EF Core query, where EF will try to "translate" expression into sql query. You should load result into memory before doing any "not SQL related" manipulations on the result. — Fabio
– Fabio, Commented Sep 27, 2020 at 3:14

Jonesopolis · Accepted Answer · 2020-09-27 02:51:50Z

1

The syntax requires you to define the variable, if you haven't previously. So use

Int32.TryParse(cpamlt.Manyr, out int tempVal)

But, your code can be shortened, as tempVal will contain the value you want, you don't need to parse again -

YearManufactured = Int32.TryParse(cpamlt.Manyr, out int tempVal) ? tempVal : (int?)null,

answered Sep 27, 2020 at 2:51

Jonesopolis

25.4k12 gold badges72 silver badges115 bronze badges

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

2 Comments

user13889515 Over a year ago

hi getting new error, Error CS8198 An expression tree may not contain an out argument variable declaration.

user13889515 Over a year ago

gave points and accepted answer, feel free to thumbs up question, thanks !

Hayden · Accepted Answer · 2020-09-27 02:58:54Z

1

You can create a new method which should wrap this operation.

static int? NullableParse(string input)
{
    int output = 0;

    if (!int.TryParse(input, out output))
    {
        return null;
    }

    return output;
}

answered Sep 27, 2020 at 2:58

Hayden

3,0162 gold badges18 silver badges33 bronze badges

2 Comments

user13889515 Over a year ago

forgot to mention, trying to avoid extension methods if possible

Hayden Over a year ago

Technically not an extension method, and you can't declare out variables in Linq. Alternative is to do this in a foreach loop, where this would work

Collectives™ on Stack Overflow

C# 8: Linq Select, Parse String into Nullable Int

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related