Skip to main content

SelectMany operator in Linq C#

SelectMany is an important operator in Linq. It takes each element of a sequence to an IEnumerable and flattens the resulting sequences into one sequence. You can find out more information about different overload list from the below link.

In this post I am going to explain How it can be really useful when you want to find list related to two entities. Practical example will be like a person can have multiple address and if you want to find list of addresses that are used with person then this SelectMany operator can be really useful.

So for this example First, I have create Address class with Street and Postalvcode property
public class Address
    public string Street { get; set; }
    public string PostalCode { get; set; }

Now we are going to create Person class which have Name property and A person can have multiple address so address generic list as property like following.
public class Person
    public string Name { get; set; }
    public List<Address> Addresses { get; set; }
Now our both class are ready so I have created classes for data like following.
private static List<Person> persons;
public static void CreatePersonData() {

    //Creating Address
    Address address1 = new Address {
                            Street = "Stree1",
                            PostalCode = "38050"
    Address address2 = new Address { Street = "Stree2", PostalCode = "38050" };
    Address address3 = new Address { Street = "Stree3", PostalCode = "38050" };

    List<Address> addresses1 = new List<Address> { address1, address2, address3 };
    List<Address> addresses2 = new List<Address> { address1, address2 };
    List<Address> addresses3 = new List<Address> { address1, address3 };

    Person person1 = new Person { Addresses = addresses1, Name = "Person1" };
    Person person2 = new Person { Addresses = addresses2, Name = "Person2" };
    Person person3 = new Person { Addresses = addresses3, Name = "Person3" };

    persons = new List<Person> { person1, person2, person3 };
As you can see I have created 3 address and created 3 address list with various combinations and then I have created 3 persons and added address list to this 3 persons.

Now I want to find the addresses those are used in all the person. So I have written following code in main method of console application.
static void Main() {
    IEnumerable<Address> addresses = persons.SelectMany(p => p.Addresses);
    foreach (var address in addresses) {
        Console.WriteLine("Street:{0} PostalCode:{1}", address.Street, address.PostalCode);

You can see in the above code there are I ahve written p=>P.address to find all the address associated with person.

Let’s run this example and following is output as expected.

SelectMany operator in linq

You can see it’s very easy. That’s it. Hope you like it. Stay tuned for more…

Shout it

kick it on


Popular posts from this blog

How to create Rest API(Web API) with ASP.NET Core 1.0

Recently Microsoft has released ASP.NET Core 1.0 RC2, I am getting lots of request from readers that about creating Web API. So I thought it will be a good idea to write a blog post about how to create Rest API(Web API) with ASP.NET Core 1.0.

So let’s get started via creating an ASP.NET Core 1.0 Web Application like following.

Once you click on ASP.NET Web Application, It will ask whether you need to create Web Application or Web API application. We are going to Web API so I am going to select Web API Application like following. Please note that in ASP.NET Core 1.0 there is no separate libraries or DLLs required for creating web APIs. This is just a project template.

Now once you click on OK It will create a Web API application with default values controller and program.cs.  As you know Program.cs is now starting point for the ASP.NET Core 1.0 application so It contains all the required configuration and startup items. Following is a code for that.
using System.IO; using Microsoft.Asp…

How to use migration with Entity Framework Core

Entity framework core is  the lightweight, extensible and cross-platform version of Entity Framework. Before some time, Microsoft has Released a new version of Entity Framework RC2. I have written a couple of blog post about Entity framework code first migration earlier for Entity framework 6.0. So there was a couple of request coming for writing a blog post about Entity Framework Core RC2 migration. So I thought it will be a good idea to give an overview how database migration works in Entity Framework Core RC2. This post will cover a basic scenario where we are going to create the database with existing ASP.NET Identity migration and then we are going to create a new model and have that migration applied in the database.

How to use Entity Framework Migrations: Let’s get started, To demonstrate entity framework core migrations, I am going to create a sample core web application like following.

Once we select core application it will appear the following dialog.

Now w…

Solution: gulp is not recognized as internal or external command- Visual Studio

Recently, After Upgrading to the newer version of Gulp, I was getting this error.  After doing lots of  finding online and in my system I was able to figure out that Modules like Gulp does not installed to the path. So when you try to run it from the command line it was showing below error.
gulp is not recognized as internal or external command How to solve : gulp is not recognized as internal or external command To solve this error we just need to create a new environment variable and set the NPM modules path there.

To create an environment variable,  Right click My Computer/ This Pc and click on properties.  It will open following windows.

Go to Advance System Settings and it will open system properties windows like below.

Click on Environment Variables it will open an environment and system variables windows like below.

Click on new System variable and put NODE_PATH in system variable name and %AppData%\npm\node_modules into the variable value like below.

Click on Ok. That’s it. N…