我可以使用LINQ返回记录列表吗？ [英] Ho I can return a list of recordes using LINQ ?

问题描述

您好，



首先感谢您访问我的帖子..

我刚开始使用Linq，所以我是对不起，如果这是一个愚蠢的问题:(



我有这个ERD设计..

http://www.m5zn.com/newuploads/2015/05/02/jpg//6fe7a5567905df0.jpg [<一个href =http://www.m5zn.com/newuploads/2015/05/02/jpg//6fe7a5567905df0.jpgtarget =_ blanktitle =新窗口> ^ ]



我也写了这堂课：

http://www.m5zn.com/newuploads/2015/05/02/jpg//184c985526142a3.jpg [ ^ ]

  public 列表< DivisionInfo> GetDivisionsInfos（）
 {
} 

DivitionInfo代表我上面写的课程它们是：



1- DivId

2- DivName

3- ManagerName（必须带经理姓名）它来自UsersInfo表）

4-活动项目。（我们将从Projects表中的列名ProjIsActive计算这个值）。

5- Total Project。（我们将计算）这个值来自Projects表中的列名ProjIsActive，它不活动）。



那么我如何用Linq和Lambda表达式编写这个函数？



我知道这可能对专业人士来说很愚蠢，但我是学生，我必须向你学习..



非常感谢

解决方案

看看这里：

101 LINQ样本 [ ^ ]

LINQ - 示例查询 [ ^ ]

如何：在查询中使用Lambda表达式（C＃编程指南） [ ^ ]

Lambda表达式（C＃编程指南） [ ^

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

解决方案

Have a look here:
101 LINQ Samples[^]
LINQ - Sample Queries[^]
How to: Use Lambda Expressions in a Query (C# Programming Guide)[^]
Lambda Expressions (C# Programming Guide)[^]

这篇关于我可以使用LINQ返回记录列表吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！