In EF why should a DB contexts not persist?

Are the reasons for why Microsoft states that DB contexts should not be long lived because of measurable effects (memory leak, resource hog, increased probability of data corruption, …) or is it because of a more subjective reasons (anti pattern, hard to manage multiple instances of the same record, increased complexity in multi threaded applications, …).

How to make the orderby dynamic with the model data

var baseQuery = _dbContext.tablename.AsQueryable(); var AllSales = await ( from obj in baseQuery select new model() { column1= obj.column1, column1= obj.column1, } ).OrderBy().Skip(model.Start).Take(model.Length).ToListAsync(); I tried to add orderbydynamic function in place of orderby but it says this IQueryable does not contain the definition of orderbydynamic i want to add order by within model columns please…