Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CommandBehavior.SchemaOnly doesn't work with stored procedures (at least) #189

Open
MaceWindu opened this issue Aug 10, 2020 · 0 comments
Open

Comments

@MaceWindu
Copy link

Describe the bug
Calling procedure with CommandBehavior.SchemaOnly behavior wraps sql with SET FMTONLY ON and SET FMTONLY OFF lines which results in following errors:

// for fully-qualified name (db.schema.proc)
Attempt to locate entry in sysdatabases for database 'SET FMTONLY ON
TestDataCore' by name failed - no entry found under that name. Make sure that name is entered properly

// for procedure name only:
Stored procedure 'SET FMTONLY ON
AddIssue792Record
SET FMTONLY OFF' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

Looks like SET FMTONLY ON/OFF should be sent in separate batches for procedures (at least doing it manually helps).

Environment

  • AdoNetCore.AseClient nuget package version (e.g. 0.18.0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants