WFP Application and Cloud Database

Hi,

I'm looking for some guidance on developing a WPF app that is connected to a cloud database via a WCF service,  Normally if the database is on the client I have a stored procedure to copy all row that have a value of TRUE in the checkbox column,  But having the database in the cloud with multiple users this approach will not work,  What would be the right pattern to use to fix this issue?

Thanks,

Bryan K