score:1

Accepted answer
var products = db.product_procedure(username)
                .where
                        (item => (item.basedescription ?? "").contains(searchword) 
                         || (item.info ?? "").contains(searchword)
                         || (item.itemno ?? "").contains(searchword)
                         || (item.itemno ?? "").contains(searchword.replace("-", ""))
                         || (item.upc ?? "").contains(searchword)).tolist();

Related Query

More Query from same tag