npgsql: NpgsqlDataAdapter doesn't support batches

Attempt to set NpgsqlDataAdapter.UpdateBatchSize fails with Specified method is not supported.. This implementation inherited from DbDataAdapter.UpdateBatchSize . Is it possible to implement batch support similar to SqlDataAdapter?

About this issue

Original URL
State: open
Created 6 years ago
Comments: 21 (15 by maintainers)

Most upvoted comments

I’ll have a look at this if nobody objects.

Brar on Jul 6, 2018

It turns out that this issue notoriously drops off the list when I prioritize my work (pretty much a legacy API, a lot of work, rarely requested), so I’ve unassigned myself.

Brar on Aug 19, 2020

Whether they are in need of batching support is anyone’s guess.

At least we had one feature request so I think it’s worth some consideration.

Up to you if you want to take a stab at it 😃

Thank you. Writing parsers has always been my nemesis. I can do for loops over characters with a few states but this is definitely more. I really want to tackle this but I can’t promise anything 😉

Brar on Jul 26, 2018

@msvprogs I agree, https://github.com/dotnet/corefx/issues/3688 is about having a better standard API for batching in ADO.NET, but for now that’s what we have.

Keeping this issue open to track implementation NpgsqlDataAdapter.UpdateBatchSize.

roji on May 18, 2018