c# - Buffering Data offline when the database server is not available -

i'm new c#, have implemented application read data socket , store using separate thread in oracle db on remote server. question is: when database server down , can not save data in data base, there tools or techniques in c# or .net allow me buffer data locally send server when connection available again. dont want lose information coming socket, @ same time preserve on data consistency in oracle databse becuase have sequence , triggers save additional information after inserting each record.

you trying introduce fault tolerance

approaches:

1. a message queue server (best) msmq, rabbitmq, or similar
2. a local database such sqlite or sql server express.
3. a local file in json, xml, or csv format.

with of these approaches, store records until database server available again. message queue scalable approach.