Ef. Join
public IListGetRenkMappings(int urunId) { var renks = repository.GetAll (); var query = repository.GetQuery (x => x.UrunId == urunId); var jq = query.Join(renks, p => p.RenkId, c => c.Id, (p, c) => new UrunRenkMappingJoinModel{ Id = p.Id, Adet = p.Adet, RenkAd = c.RenkAd} ); return jq.ToList(); }