|That is like a huge project, sadly, discussions are not that much broad to cover every aspect of this project. I will like to talk about a few key areas here,
Your best bet would be on an ORM, consider using something like Entity Framework and develop your website on top of that. It can help you with most of the SQL stuff that you will have to do yourself.
Quote:I need to create a database-driven website
Entity Framework | Microsoft Docs
Please also study the publisher-consumer pattern, this seems to be moving toward that—something like a blog website where a few users are publishing content, and almost every user is reading it.
Quote: where a number of users will capture data, and where many users will be able to view the results of a large number of different database queries
Producer–consumer problem - Wikipedia
CMS or page builder? Both these have their own libraries and tools that you can use in ASP.NET.
Quote:CMS capability would be a plus.
That is what Bootstrap is there for.
Quote:I want a responsive interface from the word go
Bootstrap · The most popular HTML, CSS, and JS library in the world.
Quote:Is there a website template available, with user management, and with the basic site infrastructure available, or should I use one of the ASP.NET CMSs, like Umbraco?
Yes, Umbraco is your only bet for the time being. And lastly, do not just depend on your extensive SQL knowledge and try to jump in the wild west of the Internet. There are several things that you need to know before you can publish the website, especially a website that is going to have a huge amount of user base and queries to database.
There are several concepts like, scaling, caching, security, responsiveness (as you have mentioned), and much more. Best bet is to consider an open source solution and leave everything to it. If you cannot then please study these concepts before moving forward.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~