I would like to translate this query in LINQ ... it is very easy to construct if we do it in pure SQL but in dynamically created LINQ query (building a search query based on user input) it's a whole new story.

SELECT * FROM MyTable 
WHERE 1=1
  AND Column2 IN (1,2,3)
  AND ( Column1 LIKE '%a%' OR Column1 LIKE '%b%' )

Now to try to construct this we tried it this way :

if(myOjb.Column2Collection != null)
    query = query.where(f => f.Column2.Contains(myOjb.Column2Collection));

if(myObj.Column1Collection != null)
{
    // tough part here ?
    //query = query.Where(); ...
}

So what would be the best aproach to this normally ?

Note that I am aware of the SqlMethod.Like, tho I can't figure a way to implement it here ...