sqladapter

hi

we are using sql adapter of type receive we are polling data from a database after each 3 minutes but data comingg has multiple records in result set

for eg we are using a query

select orderid from a tablename where someflag = ‘0’

so we are getting multiple records

so we are breaking them using a scope type and a loop inside it

we are requring scope because to break message into individual records we have used a enumerator which is not serializable so in scope with transaction type atomic we are able to do

but in that scope we are not able to use a sqladapter of request response type because atomic transaction are not able to handle it

so each breaked individual record we are sending to next orchestration to give input to sqladapter of type send but it does not work

in next orchestration if message is given to a folder it goes correctly but to sqladapter it is not going

is approach correct