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
Operations

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: 5.1.1.0
Fix Version/s: 5.7.0.0

Environment: Windows 10


 Description  « Hide
CREATE TABLE A (A integer)
CREATE VIEW V AS SELECT * FROM A
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 made changes - 31/Oct/16 02:28 PM
Field Original Value New Value
Status Open [ 1 ] In Progress [ 3 ]
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.

Jiri Cincura made changes - 11/Nov/16 03:03 PM
Status In Progress [ 3 ] Resolved [ 5 ]
Fix Version/s vNext [ 10790 ]
Resolution Fixed [ 1 ]