Do any OR Mappers provide Asynchronous Methods?

Question

Do any .Net O/R (object/Relational) Mappers provide Asynchronous methods out of the box?

I don't want to have to write the boiler plate for the asynchronous method if possible

I have rolled my own DAL with Asynchronous methods using the CCR framework. The CCR basically demands that I don't block any of it's threads waiting for IO responses.

The good part about my solution so far is that it is down to the bare minimum. But as this project grows in terms of scale and functionality, I am facing the mildly daunting task of maintaining raw SQL queries and boiler plate code.

BUT on the other hand if the O/R mapper Asynchronous methods are really just a messy hack that adds oddles of complexity I am not better off.

Please don't focus on alternatives to Asynchronous programming.

Answer 1

Yes, for SQLAlchemy (one of the best ORMs), there is sAsync:

http://foss.eepatents.com/sAsync

and NADBAPI:

http://developer.berlios.de/projects/nadbapi/

Answer 2

I think you got it wrong. My understanding is that asynchronous execution in your case should be handled at architecture level instead of ORM level i.e. message queue driven architecture. What I see is that your webserive will only place a message in the queue and there is some kind of background agent does the asynchronous processing off the queue.

Since I don't have enough reputation to comment and Stackoverflow is alerting me inserting another "answer" I will leave my comment here.

Lee B: SQLAlchemy? How do you use it with .NET???