Back to list
Views:   0
Replies:  0
Archived
,
Reply 1
Hello Parity Bit: 

The Art Shop has a example (where you search for products) that demonstrates the use of a SQL LIKE.
You'll find it in the Products action method in the ProductController.

I think where you got confused is the placement of the '%'.
It should be placed on the value, rather than the parameter, something like this:  

var products = db.Products.All( where: "ProductId LIKE @0", parms: "%014%" );

Hope this helps.
 
Jack Poorte, Sep 12, 2013
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas