There has been a few times I needed to do a like statement in LINQ, but didn’t know exactly how to go about it. Just in case there are you out there looking for the same, I thought I would post what I did. For example, say you had this SQL statement :
SELECT * FROM Autos WHERE Manufacturer LIKE '%Fo%'
This would translate to LINQ code in C# like the following