i Need Help Regarding Mvc Entity Framework

Deep Secrets

7y691.NET

I have two Tables in my database one contains User List And Their information.

2nd contains the that submited by them

but these users are under some group

like this

user15 works under User1

user16 works under User1

var t = db.Users.Where(u => u.Under_Control == Undr).Select(u => u.UserName).ToList();

gives me the list of users

then i am trying to to retrieve data from 2nd table by using loop

foreach(var item in db.userdata) {

create new list of all data...

}

i am failed then i tried this way

var test = (from usr in db.Users from data in db.userdata where user.Under_Control==Undr select data).ToList():

but it is giving me 1*5 list

Please help me to solve this i am new to Asp.net

2 Replies

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

Deep Secrets7y ago
why Not.

I have Two tables With data one contains

user Details like

Name| UserName| Work Under => the Group of user are working under one User
eg. some students work under teacher that teacher work under HOD etc.

Now these student are submitting data daily eg there class work or projects. etc

And this data is stored in another table Eg data table

like this

date|submitedby| Project info| more details|......so on..

Now what i wana to do is Get the All the data from table(datatable)

of all users working under that teacher

I am only able to get data of users one by one

But i want all data from datatable

like User1 User2 User3 User4 Working Under Admin1

All i want is Get all data Of these 4 Users from Datatable.

2nd Time Admin2's User's data

I hope U will understand.
Salman Beg7y ago
Hi.
Could you please explain in more detail what exactly you want?
Thanks.