Bug 41569 - SqlBulkCopy is not opening connection if connection string is given in ctor
Summary: SqlBulkCopy is not opening connection if connection string is given in ctor
Status: NEW
Alias: None
Product: Class Libraries
Classification: Mono
Component: System.Data (show other bugs)
Version: master
Hardware: PC Linux
: --- normal
Target Milestone: Untriaged
Assignee: Alexander Köplinger [MSFT]
URL:
Depends on:
Blocks:
 
Reported: 2016-06-07 17:34 UTC by Jan Krivanek
Modified: 2017-09-01 09:29 UTC (History)
2 users (show)

See Also:
Tags:
Is this bug a regression?: ---
Last known good build:


Attachments

Description Jan Krivanek 2016-06-07 17:34:35 UTC
When creating SqlBulkCopy with connection string and calling WriteToServer one will get 'This method should not be called on a closed connection' InvalidOperationException.

Reason:
Exception is thrown here: https://github.com/mono/mono/blob/master/mcs/class/System.Data/System.Data.SqlClient/SqlBulkCopy.cs#L383 After chceking that connection is in Closed state.
However if you use one of the ctor receiving just connection string - e.g. https://github.com/mono/mono/blob/master/mcs/class/System.Data/System.Data.SqlClient/SqlBulkCopy.cs#L88
Connection is only created (which leaves the default value of connection state - Closed. See: https://github.com/mono/mono/blob/master/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs#L108) but never opened

Note You need to log in before you can comment on or make changes to this bug.