Difference between IEnumerable vs. IQueryable
I was working in a .Net shop helping a medical insurance company rewrite their “legacy” system from the database all the way to the front end web site. The database was SQL Server. The project manager was set on Entity Framework, IIS, and Web API. Looking at their middleware code, I noticed that they were using IEnumerable when querying the database for a lists of information. This is bad practice because using IEnumerable in this context results in large amounts…