mhdi
asked on
C# Console App - Producer / Consumer using database as a queue.
Hi,
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.