Hi,
Why does SP called from EF(I'm using version 6.1.3) takes time as compared toSP execution time of SQLCommand's ExecuteNoNQuery() & Datareader? I'm making an Async call using EF like below-
public async Task<IList<T>> ExecSPAsync<T>(string query)
{
return await Context.Database.SqlQuery<T>(query).ToListAsync();
}
Use of SQLCommand/SQLDatareader seems to be much efficient compared with SP call using EF. What would be the efficient way of calling SP using EF?
Replies
Know the answer? Post it — somebody with the same question will find it here.