<div>
If I understand correctly you want to try something like this: <pre><code class="code-1 nolinks" id="code-20-43083999-1">string[] selectedInput = { "one", "two", "Three"};
IEnumerable&lt;string&gt; result = from a in selectedInput
where a.Contains(p.Number.ToLower())
select a;
foreach (string item in result)
{
Console.WriteLine(item);
}
</code></pre>.
</div>

<div>
IndexOf is going to provide a like comparison; e.g. - <pre><code class="code-10 nolinks" id="code-20-43084015-1">using System;
using System.Linq;

namespace EE_Q29181714
{
&nbsp; &nbsp; class Program
&nbsp; &nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; static void Main(string[] args)
&nbsp; &nbsp; &nbsp; &nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var inputs = new[] { "OneDayAtATime", "twoCarsInDriveWay", "threEDogNight" };
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var selects = new[] { "three", "TWO", "one" };

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach(var select in selects)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var matches = inputs.Where(i =&gt; i.IndexOf(select, 0, StringComparison.OrdinalIgnoreCase) &gt; -1);
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach (var match in matches)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.WriteLine($"Match Found - Selector: {select}; Match: {match}");
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Console.ReadLine();
&nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; }
}
</code></pre>Provides the following results - <a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455208/Capture.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455208/Capture.PNG" class="fr-fic fr-dii"></a> -saige-
</div>

Capture.PNG

<div>
Thanks for input. Could you provide sample code using table with LINQ' method approach as per provided sample code in question? Assume p.Number is table field.
</div>

<div>
Do you want the entire row, the Number field or a subset of results? -saige-
</div>

<div>
Hi Saige, I've a table and want to search on a field string array values in LINQ with method approach. For example, I can write in T-SQL with below code. Which I want to convert in LINQ with method approach. <pre><code class="code-1 nolinks" id="code-20-43084290-1">select * from [MyTable]
where 
(
&nbsp; &nbsp;[MyField] like '%Henri%'
&nbsp; &nbsp;or
&nbsp; &nbsp;[MyField] like '%Michael%'
&nbsp; &nbsp;or
&nbsp; &nbsp;[MyField] like '%Ram%'
)
</code></pre> Best Regards
</div>

<div>
Did you get chance to look into it?
</div>

MohitPandit

<div>
Thanks. I'll implement and let you know.
</div>

<div>
<div class="content wysiwyg-content">
Hello Folks, 
 
I've a string array and want to search in database table as per LIKE operator in LINQ with method approach not SQL approach in query. 
Could you assist into it? 
 
FYI, below code used IN approach. But I want to use selectedInput array; search like LIKE operator for each value 

<pre><code class="code-1 nolinks" id="code-10-29181714-1">string[] selectedInput
.Where(p =&gt; selectedInput.Contains(p.Number.ToLower()))
</code></pre>
 
Best Regards
</div>
</div>

Hello Folks,

I've a string array and want to search in database table as per LIKE operator in LINQ with method approach not SQL approach in query.
Could you assist into it?

FYI, below code used IN approach. But I want to use selectedInput array; search like LIKE operator for each value 
(CODE)

Best Regards

C#: Write LINQ with method approach to search like LIKE operator for each string array value

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.