I recently used Slick a bit in combination with Play.
On one hand I was really impressed by its capabilities, on the other hand the documentation is unfortunately lacking...
I think Slick has great potential and hope that typesafe brings the documentation onto a quality level similar to Play. If you want to try it out today and get stuck, after some time I found it quicker to look at their test cases first before googling, much more info there than in the docu and example projects.
The project is new, being at RC1 for the first stable release and relies heavily on Scala 2.10, so it is understandable that it lacks documentation. On the other hand, Slick is the only alternative to LINQ that I know of.
The documentation has never been good, Zeiger is a genius who clearly has little interest in revealing the inner workings of his mind; instead, he let's you figure it out, which is a mixed blessing -- ScalaQuery source code was basically my intro to Scala
It's worth mentioning that Slick is a lot like .NET's LINQ to SQL.
[0] http://slick.typesafe.com/