repository method implementation

public class QuestionRepository : IQuestionRepository



{

private readonly IAmbientDbContextLocator _ambientDbContextLocator;

private AuthDbContext DbContext



{

get



{

var dbContext = _ambientDbContextLocator.Get<AuthDbContext>();

if (dbContext == null)

throw new InvalidOperationException("No ambient DbContext of type AuthDbContext found. This means that this repository method has been called outside of the scope of a DbContextScope. A repository must only be accessed within the scope of a DbContextScope, which takes care of creating the DbContext instances that the repositories need and making them available as ambient contexts. This is what ensures that, for any given DbContext-derived type, the same instance is used throughout the duration of a business transaction. To fix this issue, use IDbContextScopeFactory in your top-level business logic service method to create a DbContextScope that wraps the entire business transaction that your service method implements. Then access this repository within that scope. Refer to the comments in the IDbContextScope.cs file for more details.");

return dbContext;



}

}

public QuestionRepository(IAmbientDbContextLocator ambientDbContextLocator)



{

if (ambientDbContextLocator == null) throw new ArgumentNullException("ambientDbContextLocator");



_ambientDbContextLocator = ambientDbContextLocator;

}

public List<Question> GetAll()



{

return DbContext.Questions.ToList<Question>();



}

public Question Get(int questionId)



{

return DbContext.Questions.Find(questionId);



}

public Task<Question> GetAsync(int questionId)



{

return DbContext.Questions.FindAsync(questionId);



}

public void Add(Question question)



{

DbContext.Questions.Add(question);

}

public void RemoveUserQuestion(Guid userId, int userQuestionId)



{

var uq = DbContext.UserQuestions.FirstOrDefault(x => x.QuestionId == userQuestionId &&



x.UserGuid == userId);

DbContext.UserQuestions.Remove(uq);

DbContext.SaveChanges();

}

public int AddUserQuestion(UserQuestion userQuestion)



{

DbContext.UserQuestions.Add(userQuestion);

return userQuestion.Id;



}

public IList<UserQuestion> GetUserQuestions(Guid userGuid)



{

var ql = (from u in DbContext.UserQuestions

join q in DbContext.Questions on u.QuestionId equals q.Id

where u.UserGuid == userGuid

select new



{

QuestionId = u.QuestionId,

Answer = u.Answer,

UserGuid = userGuid

}).ToList().Select(q => new UserQuestion(q.UserGuid, q.QuestionId, q.Answer)).ToList<UserQuestion>();

return ql;



}

public void RemoveUserQuestions(Guid userGuid)



{

var uq = DbContext.UserQuestions.Where(x => x.UserGuid == userGuid).ToList();



DbContext.UserQuestions.RemoveRange(uq);

DbContext.SaveChanges();

}

public UserQuestion GetUserAnswer(Guid userGuid, int questionid)



{

var useranswer = DbContext.UserQuestions.Include("Question").FirstOrDefault(x => x.UserGuid == userGuid && x.Question.Id == questionid);

if (useranswer != null)



{

return new UserQuestion



{

Answer = useranswer.Answer,

};

}

return null;



}

　

　

public void Update(Question question)



{

DbContext.Entry(question).State = EntityState.Modified;



DbContext.SaveChanges();

}

}