Stack Overflow Clone using ASP.NET Core MVC and SQL Server

---

Simulating StackOverflow search using StackOverflow data upto 2010.

Demo Link: https://stack-overflow-clone.azurewebsites.net/

Key Features:

1. ASP.NET Core MVC application hosted on Azure App Service powered by SQLServer database also hosted on Azure.
2. Relevant search results returned in order of relevance to search query using Full-text search and CONTAINSTABLE/RANK constructs.
3. Offset-based Pagination with progressive loading
4. Authentication and Authorization implemented with ASP.NET Identity
5. EF Core Reverse Engineering to build models based on the pre-existing database schema
6. Periodic server push notifications using SignalR
7. Optimized database performance with relevant indexes added.

Data Source