What technologies are currently used to work with the database?

Question

Database

There is an old application, something like home accounting, it was written quite primitively, wpf + ado + sqlite. I want to rewrite it to learn how to use up-to-date technologies and use it as some kind of portfolio when applying for a job.

Answer 1

Throw an ORM on top, instead of direct ADO.Net, and you will have modern technologies. The trend is obviously Entity Framework, although NHibernate is an ageless classic.
You can get confused over the architecture, up to the division into client and server - then there will be a place for the Web API.
Or another option is to drag a documentary database, although for accounting it is not a fact that this is a good solution (unless in a pair with a relational one, to store the characteristics of your goods).