SQL Server Reactive view.

Hi,
With SQL Server, I want to display the result of a query, and have dynamic update of the query.
So when I insert a line, the line would immediately show up in my webapp.
I don't use EFCore/EF but dapper. Multiple servers may update the DB.
Ideally i'd like something where I don't update existing business logic, and not adding too much overhead.