I need to order and filter through over 10 million rows of document names (so I can't modify the string). I currently have around 2 mils of rows and it returns the result in over 10-15 seconds after an order by or where clause. I would prefer an EF solution, not a database one, but I am open to any solution. Here is some code, although i don't consider it useful:I need to order and filter through over 10 mill