How Can I do this command in linq to sql

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.

+1

Satya Karki5y ago

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 })

+2

Rijwan Ansari5y ago

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

+3

Jignesh Kumar5y ago

Hi,

Arjun, Please try this,

string name = "new";
var res = (from _car in _context.cars
here _car.Title.Contains(name)
select _car.Title)
.ToList();

+2

Salman Beg5y ago

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

+2