How to get Last Hierarcial based records

[Learning Rocks]

Hello Everyone,

I have records in my db fields with these fields. same way i have created my model like below.

Country_id
State_id
District_id

here i need to get records based on the above fields. Here Only the last hierarchy of my model should be considered and get the records.
i.e if 'District_id' is not null, i need to show 'District_id' based records,
'State_id' is not null and 'Distirct_id' is null i need to get 'State_id' records and
'Country_id' is not null, 'State_id' and 'District_id' is null, i need to get 'Country_id' records.

How to do it with linq or any feasible approach here?

Thanks

Continue reading...