C# EF Sphinx Web Updates

I need to modernise ten existing ASP.NET pages and the work is entirely about functionality. Each page must transition from legacy ADO.NET to Entity Framework so that every data retrieval, update and deletion call is handled through a clean DbContext.

While doing that, I also want full-text search added: the Sphinx daemon is already running and indexing; your task is to write the C# client queries, bind the results to the page and expose filters so users can search across multiple tables instantly.

A light touch on the interface is necessary—mainly new filter panels, refreshed grids and clear success/error messages—so users feel the power of the new features without a wholesale redesign.

Deliverables (pull-request format)
• Ten updated .cshtml / code-behind files using Entity Framework for all CRUD operations
• Sphinx search integration with <200 ms response for a 10 k record set
• UI tweaks (Bootstrap or similar) that surface the new database and search functions cleanly
• Clear, atomic commits against my Git repo and passing unit tests I will provide

All work should target C# 10 on .NET 6. Once these points are met and the application logs stay error-free in Chrome dev-tools, the job is done.