{"issue":{"state":"closed","created_at":"2011-12-07T16:05:31Z","updated_at":"2011-12-08T08:41:41Z","comments":6,"user":{"gravatar_id":"14fc9cd33a79a06db4309889a98c3bb8","id":1247569,"url":"https://api.github.com/users/nkaiseng","avatar_url":"https://secure.gravatar.com/avatar/14fc9cd33a79a06db4309889a98c3bb8?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"nkaiseng"},"body":"Hi All,\r\n \r\nCan you help me with this one! \r\nI know you can do something like, //LIKE \r\n{ \r\n  var results = \r\ndb.priorityTypes.FindAll(db.priorityTypes.PriorityType.Like(\"monitoring\")); // \r\nFrom priorityTypes \r\n} \r\nBUT how about NOT LIKE \r\nselect * from prioritytypes where PriorityType not like \"monitoring\"\r\n","assignee":{"gravatar_id":"d1db67946c125e5eb77c5694a152337c","id":1157451,"url":"https://api.github.com/users/richardhopton","avatar_url":"https://secure.gravatar.com/avatar/d1db67946c125e5eb77c5694a152337c?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"richardhopton"},"id":2476226,"number":131,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"labels":[],"title":"SQL NOT LIKE","html_url":"https://github.com/markrendle/Simple.Data/issues/131","closed_at":"2011-12-07T20:10:32Z","url":"https://api.github.com/repos/markrendle/Simple.Data/issues/131","milestone":null},"action":"created","comment":{"created_at":"2011-12-08T08:41:41Z","updated_at":"2011-12-08T08:41:41Z","user":{"gravatar_id":"14fc9cd33a79a06db4309889a98c3bb8","id":1247569,"url":"https://api.github.com/users/nkaiseng","avatar_url":"https://secure.gravatar.com/avatar/14fc9cd33a79a06db4309889a98c3bb8?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"nkaiseng"},"body":"It looks like all you'd need to do is add \"notlike\" to AdoAdapter.IsExpressionFunction as it's already been provided for it in ExpressionFormatterBase.FunctionExpressionToWhereClause. It seems to work in my ad-hoc tests.\r\n\r\nHOW DO I DO THAT?","id":3059371,"url":"https://api.github.com/repos/markrendle/Simple.Data/issues/comments/3059371"}}