Linq distinct record containing keywords

Linq distinct record containing keywords

To get distinct records containing certain keywords using LINQ in C#, you can use the Where and Distinct extension methods in combination with the Contains method.

Here's an example:

var records = new List<string> { "The quick brown fox", "jumped over the lazy dog", "The quick brown cat", "The quick brown bird", "flew over the lazy dog" }; var keywords = new List<string> { "quick", "dog" }; var result = records .Where(r => keywords.Any(k => r.Contains(k))) .Distinct(); foreach (var item in result) { Console.WriteLine(item); }

In this example, we have a list of records and a list of keywords. We use the Where method to filter the records that contain any of the specified keywords using the Contains method and the Any method to check if any of the keywords are present.

We then use the Distinct method to remove any duplicate records from the filtered result.

Finally, we print out the distinct records containing the specified keywords using a foreach loop.

Note that the Contains method is case-sensitive, so you may need to use a case-insensitive comparison method such as StringComparison.OrdinalIgnoreCase if you want to perform a case-insensitive search.

Examples

  1. "LINQ Distinct Records Containing Keywords"

    • Description: Use LINQ to get distinct records from a collection that contain specific keywords.
    var result = collection .Where(item => item.Description.Split(' ').Any(keyword => keywords.Contains(keyword))) .Distinct();

  2. "C# LINQ: Distinct Records with Case-Insensitive Keyword Matching"

    • Description: Achieve distinct records with case-insensitive keyword matching using LINQ.
    var result = collection .Where(item => item.Description.Split(' ').Any(keyword => keywords.Contains(keyword, StringComparer.OrdinalIgnoreCase))) .Distinct();

  3. "LINQ Distinct Records with Custom Keyword Comparer"

    • Description: Use LINQ to get distinct records with custom keyword comparison.
    var result = collection .Where(item => item.Description.Split(' ').Any(keyword => keywords.Contains(keyword, new CustomComparer()))) .Distinct();

  4. "C# LINQ: Distinct Records Containing All Keywords"

    • Description: Achieve distinct records that contain all specified keywords using LINQ.
    var result = collection .Where(item => keywords.All(keyword => item.Description.Contains(keyword))) .Distinct();

  5. "LINQ Distinct Records with Keyword Count"

    • Description: Use LINQ to get distinct records based on the count of keywords contained.
    var result = collection .Where(item => item.Description.Split(' ').Count(keyword => keywords.Contains(keyword)) > 0) .Distinct();

  6. "C# LINQ: Distinct Records with Minimum Keyword Match"

    • Description: Achieve distinct records with a minimum number of keyword matches using LINQ.
    var result = collection .Where(item => item.Description.Split(' ').Count(keyword => keywords.Contains(keyword)) >= minKeywordMatch) .Distinct();

  7. "LINQ Distinct Records with Keyword Exclusion"

    • Description: Use LINQ to get distinct records excluding those containing specific keywords.
    var result = collection .Where(item => !item.Description.Split(' ').Any(keyword => excludedKeywords.Contains(keyword))) .Distinct();

  8. "C# LINQ: Distinct Records with Keyword Matching and Projection"

    • Description: Achieve distinct records with keyword matching and project specific properties using LINQ.
    var result = collection .Where(item => item.Description.Split(' ').Any(keyword => keywords.Contains(keyword))) .Select(item => new { item.Property1, item.Property2 }) .Distinct();

  9. "LINQ Distinct Records with Keyword Grouping"

    • Description: Use LINQ to get distinct records by grouping based on keywords.
    var result = collection .GroupBy(item => string.Join(",", item.Description.Split(' ').Intersect(keywords))) .Select(group => group.First());

  10. "C# LINQ: Distinct Records with Keyword Matching and Case-Insensitive Projection"

    • Description: Achieve distinct records with case-insensitive keyword matching and project specific properties using LINQ.
    var result = collection .Where(item => item.Description.Split(' ').Any(keyword => keywords.Contains(keyword, StringComparer.OrdinalIgnoreCase))) .Select(item => new { item.Property1, item.Property2 }) .Distinct();

More Tags

angularjs-directive inheritance firemonkey setuptools lldb build.gradle percentile egit atlassian-sourcetree transducer

More C# Questions

More Chemical reactions Calculators

More Livestock Calculators

More General chemistry Calculators

More Transportation Calculators