gistfile1.scala

// simple query
db.inTransaction { q =>
  q.select("select * from emp") { row =>
    User(row.id, row.name)
  }
}

// many to one
dbinTransaction {
  q => for(p <- q.select("select * from emp limit 3") { r =>
    (r.string(2), r.manyToOne(3) { (q, id) =>
      q.select("select * from dept where id = " + id) { r =>
        r.string(2)
      }
    })
  }) yield (p._1, p._2.get.toList.head)
}