joins for reporting descriptions of look up table

[David]

I am quite new to the entity frame work my context has created the following for me  and i am trying to retrieve the values from the following to tables as well AppraisalReadiness  and AppraisalTalentRating which are both lookup tables with the descriptions in them and a code my question is using the query below how to add the reference in for the above to table but still having it return a list.

   public List<appraisal> GetAppraisal(int employeeId)
        {
            List<appraisal> Appraisals = new List<appraisal>();

            try
            {

                Appraisals = pamsEntities.appraisals.Where(a => a.emp_no == employeeId).ToList();
            }
            catch (Exception ex)
            {
                throw new EntityContextException("GetAppraisal failed.", ex);
            }


            return Appraisals;
        }

[IvanY]

Hello David,

It is not very clear to us what you are trying to achieve. It seems that you are managing the lifecycle of the context object by yourself and you are creating specific methods based on it. This means that you can use ObjectDataSource and it will be easier for you to do so. In case you start using or you are using directly the members of the context it will be easier for you to use the EntityDataSource.

You can have a look at both data sources in the ObjectDataSource Component and EntityDataSource Component help articles and the related subarticles.

Regards,
IvanY
Telerik