LINQ2SQL - How to detect mutiple instances of one string within another

Question

I'm trying to determine a way to find all words in a database table called 'Word' that contain certain letters which is easy enough for single instances of letters, for example if I want to find all words that contain 'L' and 'I' I would use:

Words.Where(w => w.Word_value.IndexOf("I") > 0 && w.Word_value.IndexOf("L") > 0)

However, if I needed to find all words containing the letter 'I' and three instances of the letter 'L' (e.g. 'LILLY'), I am at a loss. Is there a way I can do a count of instances of a string within another?

Any help would be greatly appreciated.

duplicate my friend. i am not marking it for closing anyway. stackoverflow.com/questions/9144169/… and stackoverflow.com/questions/541954/… — codeandcloud
– codeandcloud, Commented Mar 15, 2012 at 15:05

codeandcloud · Accepted Answer · 2012-03-15 15:06:13Z

2

Try this.

int count = Words.Length - Words.Replace("L", "").Length;

answered Mar 15, 2012 at 15:06

codeandcloud

55.6k47 gold badges169 silver badges259 bronze badges

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

1 Comment

codeandcloud Over a year ago

I hope you checked why i stick to this method. stackoverflow.com/questions/541954/…

Phil · Accepted Answer · 2012-03-15 14:58:52Z

1

I would recommend using SQL Server's full text search capabilities.

Create a stored procedure that implements the functionality you require using full text search and then expose that using Linq to Sql or Linq to Entities.

Also see the CONTAINS predicate.

answered Mar 15, 2012 at 14:58

Phil

43.2k9 gold badges102 silver badges102 bronze badges

Collectives™ on Stack Overflow

LINQ2SQL - How to detect mutiple instances of one string within another

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related