Comments by AlexHarmes (Top 17 by date)

Id,
Question1,
QuestionOption1(array of all options in QuestionOptions with QuestionId matching Id,
Answer from Response table IF logged user has answered the question.

Uh, how do I do that please?

Did you get it?

I am still struggling. I tried to copy the code you left but it wouldn't build. I have adapted mine further but still fail to get the QuestionOptions array. And I don't know how to post a screen shot here for you. But basically I am NOT building a grid, but a question and answer page. A question can be a simple text box with NO value or row in the QuestionOptions table, or a dropdownlist, a group of radio buttons or checkboxes and each will have its own row. So it should present one question, all the options, if any or a textbox.

The code I posted above works to fill all fields EXCEPT the options array.

By any chance are you around now? I have been up half the night but I still cannot get the results I need;

At first I was using this action;

public ActionResult ViewQuestion(int? id)
{
if (id == null || id == 0 || id > 13)
{
id = 8;
}
Question question = db.Questions.Find(id);
if (question == null)
{
return HttpNotFound();
}
return View(question);
}

It worked fine with the EDMX class Questions, but it was creating screens based on the Id field of Question and one question per screen. What I need is to sort on PageNumber as there can be more than one question on a page and UserId so I can get any answers already submitted by the logged in user. Should I add a screen shot to show you what I mean?

How can I write the query so it only returns one question and many options? I tried Groupby but that didn't work at all. Am I missing some syntax to do this correctly?

Hmmm, this is still not working for me as it is only returning one value for QuestionOption. I seemed to have left it out of my select statement too, it should be QuestionOption1 = qo.QuestionOption1. It does not return a collection or list at all for me.

Also I want to make sure it only returns a single row for question then the list of options. I hope this makes sense to you as I really appreciate the help.

In my view it is breaking on this line;
@foreach (var item in q.QuestionOptions.OrderBy(o => o.QuestionOptionRanking))

what is the query returning - and how can you try it without the DB behind?

When my View Returns, there are no values for join qo in db.QuestionOptions on q.Id equals qo.QuestionId but I know there is data in there. As I said it is a one to many relationship and it should be returning a list of QuestionOptions for reach question.

Many thanks - I've been working on this for days!

Yes, thanks. This is the article to disable, however I need to know how to ENABLE if I have added the <sessionstate> to OFF in the web.config. Ideas?