What method of EF 6 is better to use for get data from database async?

Question

I have next code

public async Task<IEnumerable<MyTabel>> GetData() { try { var dbCtx = new myEntities(); return await dbCtx.MyTabel.ToListAsync(); //return await dbCtx.MyTabel.ToArrayAsync(); } catch (Exception ex) { throw ex; } }

I am wondering what is ToListAsync or ToArrayAsync method is better for perfomance ? does anyone know ?

Thanks.

UPDATE

for me performance is equal to less memory usage, faster query times, higher concurrency

"better" is very subjective here. What defines "better performance"? Less memory usage? Faster query times? Higher concurrency? You need to be a lot more specific about what you're trying to optimise for. — Paul Turner
– Paul Turner, Commented Aug 7, 2013 at 15:52

SLaks · Accepted Answer · 2013-08-07 15:49:16Z

ToList() is faster than ToArray(), because the array needs to be copied a second time once the size is known. (unlike List<T>, arrays cannot have extra space)
The same is true for async versions.

However, you may not want this function at all.
Unless you really need to get all of the data on the client, it will be much more efficient to use LINQ to entities to run SQL queries in the database.

Collectives™ on Stack Overflow

What method of EF 6 is better to use for get data from database async?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related