Pastable version of How can i shorter my linq codes?

<pre class='prettyprint' language='cs'>public void LoadById(string SearchItem)
        {
            var myTechnicTasks = engTaskCtx.Tasks.Where(task =&gt; task.MyTechnicReference.StartsWith(SearchItem)).Select(task =&gt; new MyTask()
            {
                id = task.id,
                MyTechnicReference = task.MyTechnicReference,
                MPDReference = task.MPDReference,
                tasktypeid = task.tasktypeid,
                shortdesc = task.shortdesc,
                interval = task.interval,
                critical = task.critical,
                mandatory = task.mandatory,
                dupinsp = task.dupinsp,
                dualsystemmaint = task.dualsystemmaint,
                MPDSkill = task.MPDSkill,
                MPDCrew = task.MPDCrew,
                MPDAccessMH = task.MPDAccessMH,
                MPDTotalMH = task.MPDTotalMH,
                extratime = task.extratime,
                Team = task.Team,
                MaintData = EngGetCalculatedTaskField.GetMaintData(task.id),
                AliSpReqs = EngGetCalculatedTaskField.GetAliSpReqs(task.id),
                Access = EngGetCalculatedTaskField.GetAccess(task.id),
                preperation = task.preperation,
                longdesc = task.longdesc,
                applnotes = task.applnotes
            });
            MyTechnicTaskList = myTechnicTasks.ToList();
        }

public static class EngGetCalculatedTaskField
    {
        private static TaskMaintenanceDataDataContext engTaskCtx { get; set; }
        public static string GetMaintData(int taskID)
        {
            try
            {
                using (TaskCardContext.TaskMaintenanceDataDataContext dc = new TaskCardContext.TaskMaintenanceDataDataContext())
                {
                    string maintenanceData = String.Empty;

foreach (var item in dc.TaskRelations.Where(tableRaletions =&gt; tableRaletions.TaskId == taskID &amp;&amp; tableRaletions.RelTypeId == 12))
                    {
                        maintenanceData += item.RefMaintenance.shortdesc + &quot;; &quot;;
                    }

return maintenanceData.Substring(0, maintenanceData.Length - 2);
              }
            }
            catch
            {
                return String.Empty;
            }
            
        }
        public static string GetAliSpReqs(int taskID)
        {
            #region Old
            try
            {
                using (TaskCardContext.TaskMaintenanceDataDataContext dc = new            TaskCardContext.TaskMaintenanceDataDataContext())
                {
                    string aliSpReqs = String.Empty;

foreach (var item in dc.TaskRelations.Where(tableRaletions =&gt; tableRaletions.TaskId == taskID &amp;&amp; tableRaletions.RelTypeId == 13))
                    {
                        aliSpReqs += item.RefAliSpReq.shortdesc + &quot;; &quot;;
                    }
                    return aliSpReqs.Substring(0, aliSpReqs.Length - 2);

}
            }
            catch
            {
                return String.Empty;
            } 
            #endregion

}
        public static string GetAccess(int taskID)
        {
            #region Old
            try
            {
                using (TaskCardContext.TaskMaintenanceDataDataContext dc = new TaskCardContext.TaskMaintenanceDataDataContext())
                {
                    string access = String.Empty;

foreach (var item in dc.TaskRelations.Where(tableRaletions =&gt; tableRaletions.TaskId == taskID &amp;&amp; tableRaletions.RelTypeId == 15))
                    {
                        access += item.RefAccessPanel.shortdesc + &quot;; &quot;;
                    }
                    return access.Substring(0, access.Length - 2);

}
            }
            catch
            {
                return String.Empty;
            } 
            #endregion
          
        }
}</pre>
<a href="http://www.refactormycode.com/codes/1393-how-can-i-shorter-my-linq-codes" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of How can i shorter my linq codes?