I'm building an application (C#, VS 2005) that performs approximately 50,000 inserts into a database (for now, it is in MS Access) each time it executes. For smaller DB applications, I typically use typed datasets with the auto-generated TableAdapters. However, I'm seeing that inserting this many rows using the TableAdapters is quite inefficient (this insert is taking 30 mins to complete).
I'm wondering which path to take...should I customize the TableAdapters (I read that using OleDbTransaction may help), or is there an ORM, like NHibernate, that would be more beneficial to me. I'd hate to go down the path of using/learning an ORM, just to find out that it is as inefficient as the TableAdapters I started out with. Thanks in advance.
