Over a million developers have joined DZone.

How to Return Dictionary As a Result From a LINQ Query in C#?

· Web Dev Zone

Easily build powerful user management, authentication, and authorization into your web and mobile applications. Download this Forrester report on the new landscape of Customer Identity and Access Management, brought to you in partnership with Stormpath.

This article will provide a code snippet and explains how to return Dictionary as result from a LINQ Query in C#.

There are times when you want to retrieve only the ID(distinct) and the name from the database table using LINQ . In scenarios like this , one can use the ToDictionary method to place the necessary properties to the dictionary and return them.

Below is a sample sourecode demonstrating the usage of ToDictionary method in LINQ Query

public class BlockbusterMovie
public string Name { get; set; }
public int ID { get; set; }
public class BlockbusterMovies : List<BlockbusterMovie>
public BlockbusterMovies()
Add(new BlockbusterMovie { Name = "Vishwaroopam", ID = 1 });
Add(new BlockbusterMovie { Name = "Endhiran", ID = 2 });
Add(new BlockbusterMovie { Name = "Thuppaki", ID = 3 });
Add(new BlockbusterMovie { Name = "Mankatha", ID = 4 });

The BlockbusterMovies class has the collection of movies which is used in the below code snippet to return the dictionary based on the ID and Name.

private void Form1_Load(object sender, EventArgs e)


List<BlockbusterMovie> movies = new BlockbusterMovies();

var LstMovies = movies.ToDictionary(Field => Field.ID, mc => mc.Name);


How to return Dictionary as result from a LINQ Query in C# ?

The Web Dev Zone is brought to you by Stormpath—offering a complete, pre-built User Management API for building web and mobile applications, and APIs. Download our new whitepaper: "Build Versus Buy: Customer Identity Management for Web and Mobile Applications".

dotnet,how-to,microsoft,tools,collections,visual studio,.net & windows,c-sharp

Published at DZone with permission of Senthil Kumar , DZone MVB .

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}