search list objects inside strings using LINQ to SQL

Question

I have a list of string like this

List<string> list1 = new List<string>();

For example my list is

{one , two , three , four , five}

In database I have a string like this

"five-six-seven-eight"

How I can use Linq to SQL to search between my string in database and my list. For example my query search should be true because "five" is common on both. My query is this:

var q = from p in m.ViewAbuseReports where
 (list1.Contains(p.Abuse.ToString().Split('-')) || list1.Count == 0)
    select new
    {
        Col2 = p.FirstName + " " + p.LastName,
        Col3 = p.DateTakhalof,
        Col4 = p.DateReturn
    };

I didn't get the question, would you kindly clarrify some more. — Ovis
– Ovis, Commented Feb 18, 2016 at 7:56
@Ovis I want to search a list of string in a string , My string in database splitted with "-" — mosyflasher
– mosyflasher, Commented Feb 18, 2016 at 7:59
@mosyflasher example added. Let me know if that fits what you need. — Ian
– Ian, Commented Feb 18, 2016 at 8:01

Ian · Accepted Answer · 2016-02-18 08:01:13Z

3

You may consider using LINQ Intersect.

var q = from p in m.ViewAbuseReports
 let ps = p.Abuse.ToString().Split('-')
 let i = list1.Intersect(ps).ToList() //here you get if there is any intersect (common elements) between the two `IEnumerable`
 where (i.Count > 0 || list1.Count == 0)
 select new
 {
    Col2 = p.FirstName + " " + p.LastName,
    Col3 = p.DateTakhalof,
    Col4 = p.DateReturn
 };

answered Feb 18, 2016 at 8:01

Ian

30.9k20 gold badges76 silver badges112 bronze badges

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

4 Comments

teo van kot Over a year ago

Intersect will not work with local collection in LinQToSQL.

Ian Over a year ago

@mosyflasher great! Glad that my solution fits your need. ;)

mosyflasher Over a year ago

But we should consider that use .AsEnumerable() to work

Ian Over a year ago

@mosyflasher use .AsEnumberable()? @.@?

Alexander Derck · Accepted Answer · 2016-02-18 08:16:11Z

2

var q = from p in m.ViewAbuseReports where
(list1.Any(l => p.Abuse.ToString().Contains(l)) || list1.Count == 0)
select new
{
    Col2 = p.FirstName + " " + p.LastName,
    Col3 = p.DateTakhalof,
    Col4 = p.DateReturn
};

If any of the strings in list1 is in p.Abuse this will be true. This way you don't have to take care of splitting the string (which would be a hard thing to do in database).

answered Feb 18, 2016 at 8:16

Alexander Derck

14.7k5 gold badges61 silver badges78 bronze badges

Collectives™ on Stack Overflow

search list objects inside strings using LINQ to SQL

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related