Linq groupby and count from Table List variable.

Biplob Bipul

11y861.NET

List lst_GrandResultAttendance = new List();

lst_GrandResultAttendanceDetails = GetGrandResultAttendanceDetails(version, session, branch, shift, _class, group, section).ToList();

"lst_GrandResultAttendanceDetails" variable contains below content...

Present	SiNo	Name	Date
1	1	a	1-1-2015
1	1	a	2-1-2015
1	1	a	3-1-2015
1	2	b	1-1-2015
1	2	b	2-1-2015
1	3	c	1-1-2015
1	3	c	2-1-2015

now I want that Grouping by "SiNo" and Count , As like as List New_lst_GrandResultAttendance = new List();

New_lst_GrandResultAttendance= lst_GrandResultAttendance.Group By (SiNo).Count......(How Linq Wrrite there), which output of "New_lst_GrandResultAttendance" below List.

Present	Si	Name	Date
3	1	a
2	2	b

2 3 c

2 Replies

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

Biplob Bipul11y ago
Thanks for your help, my Request is now bellow:

SELECT COUNT(*) AS Present, StudentAutoID, StudentInfo_VersionID, VersionName, StudentInfo_SessionID, Session_Name, StudentInfo_BranchID, Branch_Name, StudentInfo_ShiftID, ShiftSetup_Name, StudentInfo_ClassID, Class_Name, StudentInfo_GroupID, GroupName, StudentInfo_SectionID, SectionName, StudentInfo_SlNo, StudentRoll, StudentInfo_StudentID, StudentInfo_Name, StudentInfo_Roll FROM dbo.Qry_StudentAttendance
GROUP BY StudentAutoID, StudentInfo_VersionID, VersionName, StudentInfo_SessionID, Session_Name, StudentInfo_BranchID, Branch_Name, StudentInfo_ShiftID, ShiftSetup_Name, StudentInfo_ClassID, Class_Name, StudentInfo_GroupID, GroupName, StudentInfo_SectionID, SectionName, StudentInfo_SlNo, StudentRoll, StudentInfo_StudentID, StudentInfo_Name, StudentInfo_Roll

This is SQL Query how can I it converted Linq, Please answer as soon as posible.
Mukesh Kumar11y ago
Hi,

I am not able to understand your question.. but I can believe that you are asking for group by in linq.. Please refer below code for general demo of linq query..
var queryLastNames =
from student in students
group student by student.LastName into newGroup
orderby newGroup.Key
select newGroup;
Hope this will help you.
thanks