OK, amongst a good bit of feedback, let me clarify my previous comments regarding COM+ and EnterpriseServices.  If you are doing simple transactions against a single database and have no requirements regarding complex transactions, activation, out of proc (cross machine), role based security, component load balancing, etc…then you do not need to consider COM+, ADO.NET can handle it just fine.

 

However, I have seen people write their own infrastructure, that COM+ will provide them for free, if they DO have one of these requirements simply because they do NOT require distributed transactions.  In my opinion, they should have considered COM+, it would have saved them a good bit of time with (arguably: prove it for your scenario) little performance cost.

 

This posting is provided "AS IS" with no warranties, and confers no rights.