C# 2010 linq to sql question

Question

In a C# 2010 application, I am trying to use the following linq to
sql statment. However I am getting an error message on the select statement listed below.

eDataContext eData = new eRPTDataContext();

var eRPTRVWRun = eData.Client_Schedules.Where(c => c.Review_month == selMonth && c.Review_year == selYear).Select(c => c.Review_id).FirstOrDefault();

Thus can you tell me what I can change so that select statement in the linq to sql builds clean?

Answer 1

try this

eDataContext eData = new eDataContext();

var eRPTRVWRun = eData.Client_Schedules.Where(c => c.Review_month == selMonth && c.Review_year == selYear).Select(c => c.Review_id).FirstOrDefault();

if still having issue show us error detail.............

---

Abdul Jabbar

Answer 2

Hi Wendy;

Can you please post the exact exception message and inner exception message so that we can understand what is happening.

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".