Linq: How to get information from a child class

Question

2.33/5 (2 votes)

See more:

HI

I have 2 Classes with following properties

VB

ClsEmployee
(
   EmpID: Integer
   Gender:  integer( 0 means male, 1 means female)
   Name: String
   Children: listOf ClsChildren
}

ClsChildren
(
   ChildName String
   Gender integer( 0 means boy, 1 means girl)
   Age integer
)

I have a list of Employees using which

I need to get the Max,Min, and average age of female children for female employee.

Thanks
Ninad

[edit]Code block added[/edit]

Posted 17-Feb-14 0:13am

Member 9657520

Updated 19-Feb-14 18:20pm

v4

Add a Solution

Comments

Nelek 17-Feb-14 6:59am

This is not how CP usually works. Most important goal here is to learn and help learning.
You are supposed to try it on your own, and come here when you got stuck with something, with a concrete question about your code, design, etc.
Please have a look to What have you tried?[^] to see a good explanation about what I mean.
Don't forget people here don't get payed. And besides, if we give you a ready-to-go solution, it is not going to help you because you are not going to learn anything from it.

Nelek 17-Feb-14 7:00am

By the way... didn't you forgot the ":" in the second class? and the format of "age"?

Member 9657520 20-Feb-14 0:21am

Hi nelek,

we had tried for multiple options which did not work. so the intention was not to get a ready to go solution.

you are absolutely right that I should have provided the options that were tried. this would have also helped us point to the problem.

Finally we were able to solve it.

I have added to the solution

Thanks for the tip. will keep this in mind.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 9657520 · Answer 1 · 2014-02-19T18:26:00

Solution 2

SQL

(From Employee As ClsEmployee In lstEmployee Where Employee.Gender = 1 Select _
     (From Children As clsChildren In Employee.Children Where Children.Gender = 1 _
            Select Children.Age).SingleOrDefault)

similarly .Average and .Min commands will give the other two results

Posted 19-Feb-14 18:26pm

Member 9657520

Serge Desmedt · Answer 2 · 2014-02-17T01:01:00

Solution 1

I am not familiar with vb.net syntax, but i think,you will need to take a look at the SelectMany statement in LINQ

Posted 17-Feb-14 1:01am

Serge Desmedt