title: Selecting specific row from database .net core 2
body: <p>I want to retrieve a specific row from the database.
  so I'm using this command to retrieve it : </p>
  
  <pre><code> UserOwner userowner =_context.User.FromSql("SELECT * FROM db.user WHERE name = 'username'").FirstOrDefault();
                  return Ok(user);
  </code></pre>
  
  <p>the thing is this returns a list and I return the first on the list, but isn't there a way to return straight from the SQL command one row?</p>