Oct 24, 2012 at 5:01 PM
Edited Oct 24, 2012 at 5:01 PM
I've been using the FluentData API for a few days now and I'm very happy with it. However, I've run into one problem. My updates are very very slow.
I'm using the same construct I do for inserts. But, this contstruct is too slow for the updates. Simply put I have a list of objects and I want to use that list to update a table in the data base.
Here is what I'm doing.
using (var command = Context())
foreach (var employee in employees)
int rowsAffected =
.Column(x => x.FirstName) .Where(x => x.EmployeeNumber)
35k records are taking about 20mins to update.
Thank you so much for any input.