I'm developing a WinForms application that uses the OR mapper against an Oracle db. I have a query that could potentially return millions of rows, so I want to provide a way for the user to cancel the query if it´s taking too long.

I'm calling the Objectspace.GetCollection() method on a separate thread, and all I can think of is to abort that thread and return control to the user, leaving the query running in the database until it completes.

Is there any better way to do it?