Convert SQL code to linq (LIKE, SELECT)

Question

How can I do the following sql code with linq?

SQL;

   SELECT BusinessEntityID, FirstName + ' ' + LastName AS "FullName" 
FROM Person WHERE FullName LIKE  'a%'

LINQ;

 using(var db= new db_Context)
 {
      var query = db.Person.Select(q=> q.FirstName  + " "+ q=>q.FullName)
 }

Serkan Arslan · Accepted Answer · 2018-02-21T05:57:50.267

0

Searching after concatenate the strings is not a good idea. I recommend the search for firstname and lastname separately

var query = db.Person.Where (t => t.FirstName.StartsWith("a") || t.LastName.StartsWith("a") )
                     .Select(q=> new { q.BusinessEntityID, Fullname = q.FirstName  + " " + q.LastName })

edited Feb 21 '18 at 05:57

answered Feb 21 '18 at 05:39

Serkan Arslan

13,158
4
29
44

With your condition person like "tom anderson" will be returned, but it is not starts with "a" letter. – Slava Utesinov Feb 21 '18 at 06:14
https://stackoverflow.com/questions/49364735/join-with-comma-separated-values-in-sql-server-linq/49366114#49366114 Serkan abi bu soruda da yardım edebilir misin? – yuksel Mar 19 '18 at 15:30
@yuksel I will try. – Serkan Arslan Mar 19 '18 at 18:34

score 0 · Answer 2 · answered Feb 21 '18 at 06:15

Following code will be helpful to you,

var list1 =  db.Person.Where (t => t.FirstName.StartsWith("a"))
                     .Select(q=> new { 
                             BusinessEntityID = q.BusinessEntityID, 
                             Fullname = q.FirstName + " " + q.LastName 
                      });

Or

var list2 = from psn in db.Person
            where psn.FirstName.StartsWith("a")
            select new {
                  BusinessEntityID = psn.BusinessEntityID, 
                  Fullname = psn.FirstName + " " + psn.LastName 
            };

Convert SQL code to linq (LIKE, SELECT)

2 Answers2