Hey guys! Building an app using Lightswitch to automate inventory and ordering. Running into a problem with searching for inventory by description. In SQL, I would concat LIKE statements using the OR operator, but in Lightswitch, I'm at a complete loss. My google-foo is quite good, but I'm coming up empty.
I have a table called "Items" The field I'd like to search is called "Description" My query has a parameter called "searchParam"
So for an example item, its description is "Jumbo Wax Ring with Horn".
If I search: "Wax Ring" or "Jumbo Wax", I'll get the intended item. However, if I were to search "Jumbo Ring" or "Wax Horn", I'll get no result. The search is very literal and I can't find an elegant way around this problem. Any suggestions would be greatly appreciated! FYI, Lightswitch uses LINQ instead of SQL.
Current environment: Visual Studio 2013, Lightswitch HTML Application Web (VB, LINQ, JS)