Fetch Min key in Linq var datatype?

T K

I have declared following dictionary-

Dictionary> dictSource = new Dictionary>

{

{ DateTime.Now.AddDays(1), new List { 1, "Programmers" }},
{ DateTime.Now.AddDays(3), new List { 90, "Testers" }},
{ DateTime.Now.AddDays(2), new List { 1, "Designers" }},

};

Then , I am extracting the records having minimum value of element at zero postion.

int MinValue = dictSource.Min(pair => pair.Value.ElementAt(0));
var filteredresults = dictSource.Where(pair => pair.Value.ElementAt(0) == MinValue);

Above code returns 2 items-

1, "Programmers"
1, "Designers"

Finally, I need to drill the 'filteredresults' collection so that it returns the item having minimum date.

So, I should get the '1, "Programmers"' as final value.

I have tried following but failing-

filteredresults = filteredresults.ToDictionary(s => s.Key, s.Value);

Any help please??

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Khan Abrar Ahmed11y ago
Accepted answer
Hi you can use the order by clause on date time feild and get the firstorbydefulat value.
T K11y ago
In the below example, how to return row have minimum value at element(0) of dictionary?

Dictionary> dictSource = new Dictionary>
{
{ 1, new List { 5, "Programmers" }},
{ 1, new List { 12, "Testers" }},
{ 2, new List { 2, "Designers" }},
};
I want to return the following data from above dictionary-
2, "Designers"

I have written below:
string sminValue= dictSource.Min(pair => pair.Value.ElementAt(0))

But it returns the incorrect results, Can anyone guide here?
T K11y ago
Thanks, it worked.