Ho I can return a list of recordes using LINQ ?

See more:

ASP.NET

SQL

HTML

LINQ

C#5.0

lambda

Hi there,

First thank you to visit my post ..
I just start my way with Linq so I'm sorry if it's stupid question :(

I have this ERD design ..
http://www.m5zn.com/newuploads/2015/05/02/jpg//6fe7a5567905df0.jpg[^]

also I wrote this class:
http://www.m5zn.com/newuploads/2015/05/02/jpg//184c985526142a3.jpg[^]

public List<DivisionInfo> GetDivisionsInfos()
{
}

DivitionInfo represent the class I wrote above which are:

1- DivId
2- DivName
3- ManagerName (manager name must be bring it from UsersInfo table)
4- Active project.(we will calculate this value from column name ProjIsActive in Projects table).
5- Total Project.(we will calculate this value from column name ProjIsActive in Projects table,which is not active).

So how I can write this function with Linq with Lambda expression??

I know this may be stupid for professionals but I'm student and I have to learn from you ..

Thanks a lot