Why does the GET method on asp.net web API return IQueryable?

Question

In asp.net Web Api2, when you create an async ASI controller for an entity infrastructure model, by default the first method in the new controller looks like this:

 public IQueryable<MyModel> GetMyModel()
 {
     return db.MyModel;
 }

The JSON output from this method is just an array of all the records MyModel. Meanwhile, all other methods for POST, PUT, GET (int id) and DELETE are marked as asyncreturn Task<IHttpActionResult>. Why not the first GET method in the same style, something like this:

 public async Task<IHttpActionResult> GetMyModel()
 {
     return Ok(await db.MyModel.ToArrayAsync());
 }

I tried this and it produces identical JSON output.

Answer 1

-API , .

ToArrayAsync(), , .

Answer 2

IQuerable, API , dBset, . . , MyModal 3 Id, Name, Deleted. , , . IQuerable .

• : {host}/api/MyModal
• : {host}/api/MyModal? $filter (Deleted eq false)

, top, skip, lineCount. IQureable. Web API Async, Async.