LinQ to SQL "Not IN" clause Long data type RRS feed

All replies

  • Try this:


    from b in db.Books where not selectedBooks.Contains(b.BookID)


    Where selectedBooks is an array of integers
    Saturday, November 22, 2008 4:11 AM
  • SQL Server errors for most operations applied to a long data type.  Though I think LINQ to SQL is giving you this error in expectation that the server would fail.


    Monday, November 24, 2008 3:35 AM