title: Only display certain columns in DataGrid from an Entity Object
body: <p>I am trying to populate a DataGrid with a SQL query on an Entity Model created in VS2010. </p>
  
  <pre><code>    public List&lt;MovieTable&gt; LoadMoviesMethod()
      {
          ObjectQuery&lt;MovieTable&gt; _movies = dataEntities.MovieTables;
  
          var query =
              from MovieTable in _movies
              //where MovieTable.Rating == "R"
              //orderby MovieTable.id
              select MovieTable;
  
         return query.ToList();
      }
  </code></pre>
  
  <p>The object MovieTable is automatically generated when I import my database, but when it displays on the grid it shows the more information than I would like (id, EntityKey and EntityState). Trying to select certain properties in the object I get strings back and the return statement complains. Is there a way to select certain members of the MovieTable for display on the datagrid? Maybe specify the columns I would like to display? Seems simple enough, but I guess I'm not good enough to figure it out!!!!</p>