Getting comma separated distinct values from columns in C#

Question

I have a stored procedure that returns the below sample result set. This is what I get in my code.

Resource  |  ResourceGroup  |  ResourceType
----------|-----------------|----------------
 R1       |    RG1          |    RT1
 R1       |    RG2          |    RT1
 R2       |    RG2          |    RT2
 R3       |    RG3          |    RT2
 R4       |    RG1          |    RT2
----------|-----------------|---------------

I would like to manipulate the result set to get the below result preferably in 3 different variables.

String resource = "R1, R2, R3, R4"  // Distinct values in Resource column
String resourceGroup = "RG1, RG2, RG3" // Distinct values in ResourceGroup column
String resourceType = "RT1, RT2" // Distinct values in ResourceType column

We are required to use LINQ to get this. Any help would be appreciated.

resource = string.Join(", ", setOfData.Select(z => z.Resource).Distinct()); — mjwills
– mjwills, Commented Mar 14, 2018 at 6:33

PSK · Accepted Answer · 2018-03-14 06:51:38Z

5

You can try like following.

   String resource = String.Join(",", resources.Select(x => x.Resource).Distinct());
   String resourceGroup = String.Join(",", resources.Select(x => x.ResourceGroup).Distinct());
   String resourceType = String.Join(",", resources.Select(x => x.ResourceType).Distinct());

Complete Example:

class Program
    {
        static void Main(string[] args)
        {
            List<Resources> resources = new List<Resources>();
            resources.Add(new Resources { Resource = "R1", ResourceGroup = "RG1", ResourceType = "RT1" });
            resources.Add(new Resources { Resource = "R2", ResourceGroup = "RG1", ResourceType = "RT1" });
            resources.Add(new Resources { Resource = "R3", ResourceGroup = "RG3", ResourceType = "RT2" });
            String resource = String.Join(",", resources.Select(x => x.Resource).Distinct());
        }
    }

    class Resources
    {
        public string Resource { get; set; }
        public string ResourceGroup { get; set; }
        public string ResourceType { get; set; }
    }

answered Mar 14, 2018 at 6:51

PSK

18k5 gold badges35 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nisha Over a year ago

Thanks. This is exactly what I was looking for.

Abhilash Ravindran C K · Accepted Answer · 2018-03-14 06:52:41Z

1

Following code will be helpful to you,

 String resource = string.Join(",", your_context_table.Select(x => x.Resource).Distinct());
 String resourceGroup  = string.Join(",", your_context_table.Select(x => x.ResourceGroup).Distinct());
 String resourceType= string.Join(",", your_context_table.Select(x => x.ResourceType).Distinct());

answered Mar 14, 2018 at 6:52

Abhilash Ravindran C K

1,8562 gold badges17 silver badges24 bronze badges

Collectives™ on Stack Overflow

Getting comma separated distinct values from columns in C#

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest