C# using linq question

Question

I am working in a C#  2010 application where I have written the following lines of linq to sql code:

int TotCount = 0;           
string[] PkgIDs = rptData.Transaction.Where(c =>c.Package_ID.StartsWith("rva") &&
                                c.Received_Date != null ).Select(c => c.Package_ID).ToArray();
            foreach (string PkgID in PkgIDs)
            {
                var eCnt =  rptData.Details.Where(c =>c.Package_ID == PkgID).Select(c =>c.TotalTrans);
                TotCount = Convert.ToInt32(eCnt);
            }


My problem line of code is:    var eCnt =  rptData.Details.Where(c =>c.Package_ID == PkgID).Select(c =>c.TotalTrans);

I want to be able to obtain the value contained in the c.TotalTrans field and place the value in the eCnt field.

When I am stepping through the code and go to the line right after the line I listed above, I only see the sql equivalent value. I want to see the value for c.TotalTrans in the eCnt field.

I know what I need now is to actually make the linq to sql statement actually execute. That would be similar to the 'ToArray()'
statement listed above. However, I do not know what to change in the statement to actually obtain  the value.

Thus can you tell me what else I need to add to this statement so that I get my desired result?