How Can I do this command in linq to sql

Question

Hey guys How Can I do this command in linq to sql ?select Title from cars where Title like '%New%' and Title like '%Car%'

Rijwan Ansari · Answer

Hi, You can surely do this kinds of queries, or even complex queries in linq as shown: var selectedCars= from car in _db.Cars where car.Title. Contains ( 'New' ) && car.Title. Contains ( 'Car' ) select new { car.Title}; Regards Rijwan

Satya Karki · Answer

Hi, Of course, linq is much flexible for queries sample: var filteredCard = listCars .Where(x=> x.Title.Contains( 'New' ) && x.Title.Contains( 'Car' ) .Select(i => new {i.Title })

Rajanikant Hawaldar · Answer

Hello Arjun, For example, _context.Cars.Where(c=> userString.Any(ustr=>c.Title.ToUpper().Contains(ustr.ToUpper()))) userString is an array that contains the substrings of the string that the user sends you. I do not know if it is the best way to carry out that type of search but it has worked for me.

Jignesh Kumar · Answer

Hi, Arjun, Please try this, string name = "new" ; var res = (from _car in _context. cars here _car. Title .Contains(name) select _car. Title ) .ToList();

Salman Beg · Answer

Hey try the below tool to convert it https://www.linqpad.net/ http://www.sqltolinq.com/

How Can I do this command in linq to sql

Answers (5)