title: Elastic search getting response in object
body: <p>I am trying to access elastic search using NEST library.
  I want to use Elastic SQL, I am able to execute query from code and getting response.</p>
  
  <h1>Following is my code.</h1>
  
  <pre><code>public static User GetUserByUserName(string username)
      {
          var client = new ElasticConnectionManager().GetClient("users");
          var query = "SELECT * FROM users where username = 'DummyStudent_6610'";
  
  
          var sqlRequest = new QuerySqlRequest();
          sqlRequest.Query = query;
          sqlRequest.Format = "json";
  
  
          var response = client.QuerySql(sqlRequest);
          //How to convert to User object?
  
          return null;
      }
  </code></pre>
  
  <p>Is there any way to auto map response to c# object? 
  In above example I want to return "User" class object which should be auto mapped from elastic search.</p>