dictionary table (50 записей)

iddictionary | dictionary_name

word table (130000 записей)

idword | word_name

interpretation table (1 000 000 записей)

idinterpretation | iddictionary | idword | meaning

return dc.interpretations.Where(i => i.iddictionary == iddict).Distinct(new WordsInDictionaryDistinct()).OrderBy(w => w.word.word1).Skip(iSkip).Take(iTake);

    public class WordsInDictionaryDistinct : IEqualityComparer<interpretation>
    {
        public bool Equals(interpretation x, interpretation y)
        {
            return x.idword.Equals(y.idword) && y.idword.Equals(x.idword);
        }

        public int GetHashCode(interpretation obj)
        {
            return obj.idword.GetHashCode();
        }
    }

return dc.interpretations.Where(i => i.iddictionary == iddict).ToList().Distinct(new WordsInDictionaryDistinct()).OrderBy(w => w.word.word1).Skip(iSkip).Take(iTake);

    public class WordsInDictionaryDistinct : IEqualityComparer<interpretation>
    {
        public bool Equals(interpretation x, interpretation y)
        {
            return x.idword.Equals(y.idword) && y.idword.Equals(x.idword);
        }

        public int GetHashCode(interpretation obj)
        {
            return obj.idword.GetHashCode();
        }
    }

IEnumerable<interpretation> res = (from interp in dc.interpretations
                                              group interp by interp.idword into groupedres
                                              select new interpretation
                                              {
                                                  idword = groupedres.Key,
                                                  idinterpretation = groupedres.SingleOrDefault(i => i.idword == groupedres.Key).idinterpretation,
                                                  interpretation1 = groupedres.SingleOrDefault(i => i.idword == groupedres.Key).interpretation1,
                                                  iddictionary = groupedres.SingleOrDefault(i => i.idword == groupedres.Key).iddictionary
                                              }).Skip(iSkip).Take(iTake);

idinterpretation | iddictionary | idword | meaning
1                   1              1115     hello
2                   1              1115     hi
3                   1              1115     hi, bro
5                   1              1118     good bye
6                   1              1118     bye-bye
7                   2              1119     yes 
8                   2              1119     yeah
9                   2              1119     all rigth

idinterpretation | iddictionary | idword | meaning
1                   1              1115     hello
5                   1              1118     good bye
7                   2              1119     yes 

        public IEnumerable<interpretation> GetWords(int iddict, int iSkip, int iTake)
        {
            var query = from row in dc.interpretations
                        where row.iddictionary == iddict
                        group row by row.idword into grouped
                        select grouped.FirstOrDefault();

            return query.OrderBy(w => w.word.word1).Skip(iSkip).Take(iTake);
        
        }