I couldn't spot it in the help file but is there a way of doing more complicated LIKE's then offered by Contains, StartsWith or EndsWith? See http://blogs.microsoft.co.il/blogs/bursteg/archive/2007/10/16/linq-to-sql-like-operator.aspx

Could you please post some example of what are you trying to achieve?

daelmo wrote:

Could you please post some example of what are you trying to achieve?

I'm not trying to achieve anything - just want to know if the example in the link can be done.

Oh, I see Sure, you can do that. See these examples:

StartsWith

var q = from c in metaData.Customer
        where c.Country.StartsWith("A")
        select c;

EndsWith

var q = from c in metaData.Customer
        where c.Country.EndsWith("A")
        select c;

Contains

var q = from o in metaData.Order
        where o.Customer.Country.Contains("land")
        select o;

Like

var query = from c in ctx.Customers
            where SqlMethods.Like(c.City, "L_n%")
            select c;

above (LINQ2SQL) is the same to (LINQ2LLBL):

var query = from c in metaData.Customers
            where c.City.StartsWith("L_n")
            select c;

You can find some examples at [LLBLGenPro intallation folder]\Sourcecode\LinqUnitTests\AdapterTests

Indeed, StartsWith/EndsWith/Contains are the 3 methods to use for Like operator behavior. If you want, you can also map a different method to LIKE in your own functionmappings

I am using following line of Code

        var colContent = from content in metaData.Content
                             where SqlMethods.Like(content.TitleBrief, "Men%")
                             select content;

I am geeting an Error

The binary expression '(Like(EntityField(LPLA_1.TitleBrief AS TitleBrief), "Men%") == True)' can't be converted to a predicate expression.

Am i doing something wrong

Answered in other thread with same message.

Please don't re-open old threads.