I need a report that shows the number of unique visitors each day. Here is the query:

```
SELECT User.Name
       ,Visit.VisitDate
       ,COUNT(Visit.Id) AS NumOfVists
FROM Visit JOIN User ON Visit.UserId = User.Id
GROUP BY User.Name, Visit.VisitDate

```

I have created the User(table) model and the Visit(table) model using code-first. I also have the dbcontext class which references these two models(tables). In my controller, I need to pass the results of this query into a View.

First of all, do I have to create a MODEL of this recordset? If yes, do I create a model named say, REPORT with 3 members called Name, VisitDate, and NumOfVisits? 

If that's the case, what will the LINQ version of this query look like? and how do I pass it to the view?