How to do a LIKE query with linq

Question

How can i perform an LIKE query within Linq   I have the following query i would like to execute   var results   from c in db costumers               where c FullName LIKE     FirstName      LastName               select c

User · Accepted Answer

You could use SqlMethods Like matchExpression pattern   var results   from c in db costumers               where SqlMethods Like c FullName      FirstName      LastName                select c    The use of this method outside of LINQ to SQL will always throw a NotSupportedException exception

User · Answer

2019 is here    Requires EF6  using System Data Entity  string searchStr   bla bla bla   var result    dbContext SomeTable Where x  gt  DbFunctions Like x NameAr  string Format    0     searchStr     FirstOrDefault

User · Answer

You can use contains   string   example      sample1    sample2     var result    from c in example where c Contains  2   select c      returns only sample2

User · Answer

Try like this  var results   db costumers Where X  gt X FullName Contains FirstName  amp  amp  X  gt X FullName EndsWith LastName                              Select X  gt X

User · Answer

String    obj    from c in db Contacts                            where c FirstName StartsWith prefixText                             select c FirstName  ToArray                return obj    StartsWith   and EndsWith   can help you a lot here  If you want to find data in between the field  then Contains   can be used

User · Answer

var StudentList   dbContext Students SqlQuery  Select   from Students where Email like   gmail     ToList lt Student gt      User can use this of like query in Linq and fill the student model

User · Answer

Try using string Contains    combined with EndsWith   var results   from c in db Customers               where c FullName Contains  FirstName   amp  amp  c FullName EndsWith  LastName                select c

User · Answer

where c FullName Contains  string

[c#] How to do a LIKE query with linq?

Examples related to c#

Examples related to linq-to-sql