Issue Details (XML | Word | Printable)

Key: DNET-701
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Jiri Cincura
Reporter: fish
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
.NET Data provider

No exception with ExecuteReader()

Created: 27/Sep/16 04:50 AM   Updated: 11/Nov/16 03:03 PM
Component/s: ADO.NET Provider
Affects Version/s:
Fix Version/s:

Environment: Windows 10

 Description  « Hide
CREATE TABLE A (A integer)
DROP TABLE A //with ExecuteReader() -> No exception
DROP TABLE A //with ExecuteNonQuery() -> throw the excaption: cannot delete COLUMN A.A there are 1 dependences.

If you use ExecuteNonQuery() then the exception will come up but if you use ExecuteReader() it will not come up.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jiri Cincura added a comment - 31/Oct/16 02:29 PM
Isn't it weird to call DDL statement using ExecuteReader?

fish added a comment - 31/Oct/16 11:39 PM
Sometime you may need to get a recordset without knowing the SQL command type.