title: How to Except Property instead of Select in Lambda LINQ
body: <p>I have a code that fetching a table. Here's my sample code:</p>
  
  <pre><code>public IQueryable&lt;MyItem&gt; MyItems(){
      return context.MyItem;
  }
  </code></pre>
  
  <p>Here are the sample properties of MyItem</p>
  
  <pre><code>public int Id {get;set;}
  public byte[] Image {get;set;}
  public string Name {get;set;}
  </code></pre>
  
  <p>Since, <code>byte[]</code> can have multiple characters, I don't want to include then in searching because it will take so long if I have a records like 10,000 items.</p>
  
  <p>Typically, I would <code>Select</code> like this:</p>
  
  <pre><code>public IQueryable&lt;MyItem&gt; MyItems(){
      return context.MyItem.Select(item=&gt;new MyItem{
          Id=item.Id,
          Name=item.Name
      });
  }
  </code></pre>
  
  <p>This is okay for few properties, but what I have a 10-20 properties, it would be hassle to write them one by one. </p>
  
  <p>Is there any way like, I just Except the property <code>Image</code> in lambda for shorter code?</p>