UniDataAdapter.UpdateBatchSize throws NotSupportedException
Posted: Fri 12 Jan 2018 10:10
Whenever I call UniDataAdapter.UpdateBatchSize with a value other than 1, a NotSupportedException is thrown. This happens when connecting both to Sql Server and Oracle. I setup UniConnection to support both databases and code look similar to this:
Used connectionstrings:
Provider=SQL Server;Data Source=(localdb)\MSSQLLocalDB;AttachDbFilename=D:\Databases\Test.mdf;Integrated Security=True;
Provider=Oracle;Data source=TEST;User Id=TEST;Password=TEST;Unicode=true
Am I doing something wrong?
Code: Select all
using (var conn = new UniConnection(universalConnectionString))
{
conn.Open();
..... snip .....
using (var adapter = new UniDataAdapter())
{
adapter.SelectCommand = selectCommand;
adapter.InsertCommand = insertCommand;
selectCommand.UpdatedRowSource = UpdateRowSource.None;
insertCommand.UpdatedRowSource = UpdateRowSource.None;
adapter.UpdateBatchSize = 20; // throws 'Specified method is not supported.' at System.Data.Common.DbDataAdapter.set_UpdateBatchSize(Int32 value)
Provider=SQL Server;Data Source=(localdb)\MSSQLLocalDB;AttachDbFilename=D:\Databases\Test.mdf;Integrated Security=True;
Provider=Oracle;Data source=TEST;User Id=TEST;Password=TEST;Unicode=true
Am I doing something wrong?