Logical Help require to fetch data from db in specific way

[Sudip_inn]

suppose i have a table order where order info stored and i have a console application which is running in 5 pc and this console application will fetch data from table order but in specific way.

suppose if console application running in PC1 fetch those order data which not fetched by other same console application running in other PC. how could i develop this logic as a result if console app1 fetch records 1 to 5 then console application app2 will not fetch records 1 to 5 rather it may fetch available records which is not fetched by other same console application running in other pc.

if my scenario is not clear. then please tell me then i will explain it more elaborately with example.

please give me knowledge to develop this kind of application which will be fetching data from same table but always works with those free data which has not been fetched by other same console application running in other pc.

do i need to maintain any trick at db end or it can be done fully at application level?

do i need to lock db records by select statement and if yes then what isolation level should be followed in my SP for fetching data ?

please share some sample code including C# and sql server relation which help me to design this job.

thanks

Continue reading...