C# Console App - Producer / Consumer using database as a queue.
Posted on 2014-01-07
I'm looking at creating two C# console applications. The first console app will produce text records (possibly multiple records concurrently) and write them to a database. The second app will take each record in the database (queue) and consume them in order that they were created deleting each record as it is processed. The two applications will run concurrently on the same machine.
Is MS SQL CE a good fit for holding this 'record queue'?
How can I safely produce and consume the records without running to any conflicts?
Thanks for any input