Can select multiple items in Linq to SQL

See more:

SQL-CE

C#

SQL-Server

LINQ

Hi there,

I am trying to do a join in SQL. I do the join but it always returns the first object instead of a collection of objects. Here is my code:

IEnumerable<FigureModel> data = (from figure in context.Figures
                                                join rarity in context.Rarities on figure.RarityID equals rarity.RarityID
                                                join figureKeywords in context.FigureKeywords on figure.FigureID equals figureKeywords.FigureID
                                                join keywords in context.Keywords on figureKeywords.KeywordID equals keywords.KeywordID
                                                where figure.Name.Contains(QueryString) && ((powerMap & figure.PowerMap) == powerMap) &&
                                                      (SelectedSet == null ? true : figure.SetID == SelectedSet.SetID)
                                                select new FigureModel
                                                {
                                                    Cost = figure.Cost,
                                                    Name = figure.Name,
                                                    Rarity = rarity.Name,
                                                    SetNumber = figure.SetNumber.ToUpper(),

                                                });

A figure links to the FigureKeywords table which then links Keywords table. The problem is that if I try query figureKeywords it isnt giving me a collection its giving me a single instance of FigureKeywords?

Thanks in advance,

- Dom