I've decoupled my user model from the main domain model that represents a 'person' and wonder how to retrieve personalized user data in the controller context.

Question

Example:

[Authorize]
public ActionResult Index()
{
    var person = _userPersonalizationService.GetPersonForUser(User.Identity.Name);
    var campaigns = _campaignRepository.GetCampaignsByCompanyId(person.Company.CompanyId);
    return View(campaigns);
}

Basically every user is tied to a person model, and in this instance, I want the retrieve the campaigns of a user's associated company.

How would you wrap this retrieval mechanism so that I don't have to call the database every time and have a UserPersonalizationService in the controllers? Create a base UberController from which every controller is derived? Should I save the authorized user's Person data in the session container?

Answer 1

I would store it in Cache.. then attach a cache dependency to the database, in the event those campaigns in the DB change, the dependency will break and the campaigns will be refreshed in cache.