SubSonic-3.0

SubSonic-3.0 copied to clipboard

      replies = from n in Note.All()
      where n.ParentNoteId != null && noteList.Contains(n.ParentNoteId.Value)
      select n  

(Where noteList in either a list of strings or Guids)

see http://stackoverflow.com/questions/2073257/subsonic-query-construction-for-containsguid for more info.

Can be worked around, see stackoverflow answer for details

I know a work-around is available. I am the originator of the SO question. Contains support on par with Linq to SQL is desirable - this is just one example.

I built an experimental enhancement to the mysql provider for this. I'm posting it up for review. If it works, it should be pretty easy to apply to the other providers.