Junction of 2 Linq Queries

Question

I am using the mysql database. I have 2 tables one of questions and options related to the question. For every access I make to the system I need to take the questions randomly and obviously the related options. I found in google a way to take the questions randomly because mysql does not have the Guid as in Sql server. Below the code:

var teste = (from q in db.Questoes orderby rnd.Next() select q).Take(2)

Now how do I Join this query with my options table? Join is done with the field Questoes.Id and Opcoes.QuestoesId

public class QuestaoModel
{
    public int Id { get; set; }
    [Column(TypeName = "varchar(MAX)")]
    public string Pergunta { get; set; }
    public int TemaId { get; set; }
    public virtual TemaModel Tema { get; set; }
    public virtual ICollection<OpcaoModel> Opcoes { get; set; }
    public virtual RespostaModel Resposta { get; set; }
}

public class OpcaoModel
{
    public int Id { get; set; }
    public string opcaoResposta { get; set; }
    public int QuestaoId  { get; set; }
    public virtual QuestaoModel Questao { get; set; }
}

Can someone give me a hand?

Answer 1

Try to use something like db.Questoes.Include(i => i.Opcoes) to bring the options in the result.

Answer 2

From what you described I think that’s it:

var teste = 
    (from q in db.Questoes 
    join op in db.Opcoes on q.Id equals op.QuestoesId 
    orderby rnd.Next() select q)
    .Take(2)