I currently have a web API for an ASP.net WebApplication that queries a view of all of our Test Data (About 500k rows) in SQL server 2008 R2 which is referenced in the Web API via Entity Framework Filtering Data has acceptable performance, here is the client side code I am using to debug the Web API: This Query: “../api/TestData?$filter=DeviceTypeID