CuriousDrive/BookStores — reverse-engineered prompt

Build me a simple BookStores web app as a Blazor Server project with an ASP.NET Core Web API backend and a SQL Server database.

I want it to feel like a small admin system for a bookstore. Users should be able to log in, see protected pages based on authorization, and manage bookstore data through pages that use a data grid. Include normal database operations like viewing, adding, editing, and deleting records. The backend should expose the data through API endpoints, and it would be great if Swagger is available so I can test the API.

Please include a SQL script or setup steps to create and seed a BookStores database. Make the app easy to run locally in Visual Studio or VS Code, with clear connection string settings and basic instructions. If you need current Blazor or ASP.NET Core guidance, look up the docs online.