How to achieve Stack Overflow style reputation using RavenDB?

[Chase Florell]

I've got a project that is very similar to SO. So taking SO as an
example, how can I achieve this use case in Raven?

A user gains reputation for doing various activities on the site.
As their rep increases, each post they make has their rep associated
with their name.

In SQL server, I have a Rep table with each single activity
represented and a TotalRep field in the users table.

If I use RavenDB, the relevant user details will be stored in the
document with each post... How then would you insert the dynamically
changing reputation into the ViewModel? The best I can think of is to
have a separate query for each user that's being displayed on the
page. The problem with this is that if there are 30 comments to a
question, then there will be one query for the question and an
additional 30 queries to get the reputation.

Is there a better way to achieve this?

[Oren Eini (Ayende Rahien)]

Here is one option. The User's reputation is stored inside the User document.

Each question/comment include the user's id.

You can then query it using:

session.Query<Question>()

   .Customize(x=>x.Include("UserId").Include("Answers,UserId").Include("Answers,Comments,UserId") )

   .ToList();

This will load the user who asked the question, the users who answered the question and all of the comments in a single query to the database.

[Chase Florell]

Here's how I expected the json to look for the [question] document
(incomplete, but you get the point)

{
"userId": 1,
"questionId": 1,
"questionTitle": "MyTitle",
"question": "howdoImanageRavenDB?",
"questionDate": "4/26/09",
"questionAnswers": [
{
"answerId": 1
"userId": 2,
"answer": "Here's an answer to your question",
"answerDate": "4/26/09"
}
]

On Feb 26, 1:16 pm, "Oren Eini (Ayende Rahien)" <aye...@ayende.com>
wrote:

> Here is one option. The User's reputation is stored inside the User
> document.
> Each question/comment include the user's id.
>
> You can then query it using:
>
> session.Query<Question>()
>

>  .Customize(x=>x.Include("UserId").Include("Answers,UserId").Include("Answer s,Comments,UserId")

> )
>    .ToList();
>
> This will load the user who asked the question, the users who answered the
> question and all of the comments in a single query to the database.
>

[Chris Marisic]

I don't think you want to have answers as part of the question document. These posts should be very helpful to you:

http://codeofrob.com/entries/ravendb---document-design-with-collections.html
http://codeofrob.com/entries/ravendb---stackoverflow-style-voting-with-live-projections.html
https://groups.google.com/forum/?fromgroups#!topic/ravendb/SLKVZ_lIoNk