Part 18 GroupBy in LINQ

[@rahulsrivastava4228]

Venkat sir , how do u come to know our requirement ...the level you use in your teaching is amazing because it gets easy to understand each module of the concept..the presentation and voice quality is awesome there is nothing stopping you to get award from Microsoft ...this is our core desire ...can we expect tute on sharepoint in future .

[@saurabhchauhan232]

Bharat Ratna :)

[@jkmalify]

@@saurabhchauhan232 padma sri

[@enricorm75]

All videos of all your playlist are great! Thank you.

[@kamdemkakengne]

Hi Venkat! You make me better programmer with your tutorials

[@Eandia]

You're very knowledgeable. Thanks for the video, I needed this!

[@yashobantadash6670]

great videos as always!

[@martinn.6082]

Loved the explanation, thanks!

[@ialimijororakotoniaina3274]

your tutorials are amazing dude

[@sikeeeee]

Simple and easy to understand. Keep up the good work.

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you kzbin.infoplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat

[@sikeeeee]

Thank you for the links and yes i will share them during suitable situations. If by any chance would you be able to do Asp.net Identity Role Based Authorisation (Not Authentication) tutorials? I see the strong need for that tutorial in the web. As there arent much tutorials.

[@khaledsaleh286]

Hi Kudvenkat, I think there is no difference between GroupBy and ToLookup extension method , I could get the department and the employees who are working for that department by using the following Code : var result = Employee.GetAllEmployees().ToLookup(c => c.Department); And then we need to iterate through the result to get them but the same result with group by the department so, what do u think? Is there any difference?

[@flikcof7910]

Good stuff. Well done

[@ahmettachmuradov8630]

the best teacher

[@solvedplus858]

very good tutorial many thanks for it

[@EricTViking]

Great video - thanks for sharing.

[@zo62]

How do you do the non sql version of that last linq statement

[@emanshedid3469]

+zo62 var result2 = db2.Employees.GroupBy(x => x.Department.Name).OrderBy(f => f.Key); foreach (var group in result2) { var OrderdGroup = group.OrderBy(y => y.FirstName); Label1.Text += group.Key + " _ " + group.Count() + ""; Label1.Text += "------------------------"; foreach (var r in OrderdGroup) { Label1.Text += r.FirstName + " , " + r.Department.Name + ""; } Label1.Text += ""; } i use windows form application it's approximately the same

[@kiranhyde]

var empGroupByDept = Employee.GetAllEmployees() .GroupBy(x => x.Department) .OrderBy(x => x.Key); foreach (var group in empGroupByDept) { Console.WriteLine("{0} - {1}",group.Key,group.Count()); Console.WriteLine("--------------"); foreach (var employee in group.OrderBy(x =>x.Name)) { Console.WriteLine("{0} -- {1}",employee.Name,employee.Department); } Console.WriteLine(); Console.WriteLine(); }

[@rodrigoantweber]

Amazing !

[@skolker]

AMAZING!!!!!!!!!!

[@kevinandressanterohernande6534]

thanks for the video, they are very good

[@saagarsoni3]

thnx a lot sir

[@emanshedid3469]

it's an amazing tutorial :)

[@zeetsoft]

Thank you

[@gouravchouhan9511]

how can we show this group count on web page by grid view or something else

[@KarimAlbakry]

thanks a lot keep going

[@jiturcm1]

nice

[@ahmedgadhassan]

How can Group Dynamic make user to choose any Field to Group @

[@balarajug6143]

Who to print in this data in GridView anybody can explain please ? var employeeGroup = from employee in Employee.GetAllEmployees() group employee by employee.Department; foreach (var group in employeeGroup) { Console.WriteLine("{0} - {1}", group.Key, group.Count()); Console.WriteLine("----------"); foreach (var employee in group) { Console.WriteLine(employee.Name + "\t" + employee.Department); } Console.WriteLine(); Console.WriteLine(); I am getting only Hr Record from below code var employeeGroup = from emp in Employee.GetAllEmployees() group emp by emp.Department; var result = string.Empty; foreach(var group in employeeGroup) { result = group.Key + " " + group.Count(); } GridView1.DataSource = result; GridView1.DataBind();

[@sandeepreddypalannagari8489]

Sir how to do group by item count in rdlc report using asp. Net c#

[@sharmilaramalingam3277]

Asquerable() example

[@nice444b]

Super

[@remiduplan8449]

... and what if I want to retrieve the whole employee in the select new {} ? ... linq keeps me upset. And no tutorial (yours included) have ever change my mind about the stupidity, unlogical "order" of its syntax. or maybe .. unlike many other tuto, you explain badly this one. because if I want to get back the un-ordered employee ... syntax should be obvious. but I ca't even write "select employee" and egroup (if I understand well, is the equivalent of the employee.department) ... so why does it return the whole employee ? Linq is a gadget, not technical, it requires no skills but memory.