Linq to SQL Select Query explanation.

Question

Amrith Chandran · Answer

LINQ Concat() in C#
The Concat() method in LINQ is used to combine two sequences (collections) into a single sequence without removing duplicates.
Basic Syntax
var CombineCollection = firstCollection.Concat(secondCollection);
Returns a new sequence that contains all the elements of firstCollection, followed by all the elements of
secondCollection.Does not modify the original collection.Does not remove duplicates (unlike Union()).
Example with int type collection-
using System;
using System.Collections.Generic;
using System.Linq;
namespace MyConsoleApplication
{
   class MindStickSoft
   {
       static void Main()
       {
           Listandlt;intandgt; numbers1 = new Listandlt;intandgt; { 1, 2, 3 };
           Listandlt;intandgt; numbers2 = new Listandlt;intandgt; { 4, 5, 6 };
           var combined = numbers1.Concat(numbers2);
           Console.WriteLine("Concatenated List: " + string.Join(", ", combined));
           // Output: Concatenated List: 1, 2, 3, 4, 5, 6
       }
   }
}
The above program combines the two integer list into a new integer list.
Example with string type collection
using System;
using System.Collections.Generic;
using System.Linq;
namespace MyConsoleApplication
{
   class MindStickSoft
   {
       static void Main()
       {
           Listandlt;stringandgt; names1 = new Listandlt;stringandgt; { "Alice", "Bob" };
           Listandlt;stringandgt; names2 = new Listandlt;stringandgt; { "Charlie", "David" };
           var result = names1.Concat(names2);
           Console.WriteLine("Concatenated Names: " + string.Join(", ", result));
           // Output: Concatenated Names: Alice, Bob, Charlie, David
       }
   }
}
When to use Concat()
When you want to merge two collections while keeping duplicates.When working with different types of sequences.When you need to preserve the order of both collections.
Also, read: 
How to use DefaultIfEmpty() function in LINQ with C#?and

forum

Linq to SQL Select Query explanation.

Ashutosh Kumar Verma

Can you answer this question?

1 Answers

LINQ Concat() in C#

Liked By