Hi roshanbudh,
Yes. It is possible by synchronizing data between online database and local database.
Refer below link.
How to synchronize two SQL Server Databases automatically using C# .Net
Or for data synchronization you need to make use of Bidirectional Sync.
Bidirectional Synchronization between a local and online database means ensuring that the changes made in one database are updated in the other database, and vice versa.
For implementing Bidirectional Sync you can use Microsoft Sync Framework.
For more details on Bidirectional Sync and Microsoft Sync Framework please following links.
https://en.wikipedia.org/wiki/Microsoft_Sync_Framework
https://www.merge.dev/blog/bidirectional-synchronization
