What solutions to choose for storing large volumes of ASP.NET data?

Question

Database

Hello!
I have data that is stored in a TSV file (~120.000 entries). I need to write a server (ASP.NET Web API) that will update the database every day, using TSV files, downloading them from an FTP server. As well as providing an API for processing this data, the main functionality of the API is to search for data in two columns and then return the search results in JSON format. The size of the database is expected to be about ~1.5 TB, actual data. What solutions would you recommend to choose for processing such volumes of data?
Thanks in advance!

Answer 1

ASP.NET is .NET, what solutions can there be?
Call ADO.NET storages or slightly slower than EF.
And a DB at the price and preference.
After all, they didn’t come up with anything new, whatever they choose will be the same but on different software.
Or is there something super fast and different from this?