Pastable version of How can i use generic class to write useful codes via linq?

<pre class='prettyprint' language='cs'>public  class EngGetCalculatedTaskField
    {
        private static TaskMaintenanceDataDataContext engTaskCtx { get; set; }

public EngGetCalculatedTaskField()
        {
            engTaskCtx = new TaskMaintenanceDataDataContext();
        }
        public   string GetMaintData(int taskID)
        {
               var query = engTaskCtx.TaskRelations.Where(r =&gt; r.TaskId == taskID &amp;&amp;
                    r.RelTypeId == 12).Select(r =&gt; r.RefMaintenance.shortdesc);
                return string.Join(&quot;; &quot;, query.ToArray());
        }
        public  string GetAliSpReqs(int taskID)
        {
             var query = engTaskCtx.TaskRelations.Where(r =&gt; r.TaskId == taskID
                                           &amp;&amp; r.RelTypeId == 13)
                               .Select(r =&gt; r.RefAliSpReq.shortdesc);
                return string.Join(&quot;; &quot;, query.ToArray());
        }
        public  string GetAccess(int taskID)
        {
             var query = engTaskCtx.TaskRelations.Where(r =&gt; r.TaskId == taskID
                                     &amp;&amp; r.RelTypeId == 15)
                         .Select(r =&gt; r.RefAccessPanel.shortdesc);
             return string.Join(&quot;; &quot;, query.ToArray());
        }
        public  string GetZone(int taskID)
        {
            var query = engTaskCtx.TaskRelations.Where(r =&gt; r.TaskId == taskID
                                    &amp;&amp; r.RelTypeId == 14)
                        .Select(r =&gt; r.RefZone.shortdesc);
            return string.Join(&quot;; &quot;, query.ToArray());
        }</pre>
<a href="http://www.refactormycode.com/codes/1395-how-can-i-use-generic-class-to-write-useful-codes-via-linq" 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 use generic class to write useful codes via linq?