C#.NET LINQ / Entity Framework | Group by in LINQ
Group by in LINQ
Posted Date Unknown Sonia George Sonia George 1 Comment

Hi All,

How can I use "Group by" clause in LINQ?
See All Responses Below...
Author
Message Rating
Posted on: 05/06/2012
This is the format..

var results = from r in objDataContext.EMPLOYEE_TBs                             
                             group r by r.Dept into grouped                            
                             select new 
{ 
Department= grouped.Key, 
TotalEmployee = grouped.Count() 
};
Please Login to Post Your Comments
Name (Max. 100 characters)
Please post your comments here
Select Language
Comments
   Design  HTML
Attach File(Max. Size: 2 MB)
A few simple rules when posting your Comments,
  1. Please post only answers relevant to the topic of discussion.
  2. Please dont misuse this site or do not be abusive, offensive, inappropriate,harass anyone on the boards or post ads or spam. Doing so will delete your inappropriate messages and will block or delete your account on this site. 
Related Threads
LINQ & Stored Procedures

TekTipsDownload
GateExam
Academic Projects
TekTipsExperts
 
Site optimized for IE7, 1280 X 768 and above. Copyright © 2010 - 2018 KTS InfoTech
 		Site Developed Using KTS WebCloud