-
Notifications
You must be signed in to change notification settings - Fork 345
-
Setting CommandBehavior.KeyInfo in SQLServer will include the primary key column (composite primary key), even if the column is not queried, and the IsHidden column is True
select Id,DvTitle from TempExample
MySQL
image
SQLServer
image
Beta Was this translation helpful? Give feedback.
All reactions
Replies: 1 comment
-
CommandBehavior.KeyInfo isn't supported in MySqlConnector. (Based on https://learn.microsoft.com/en-us/dotnet/fundamentals/runtime-libraries/system-data-commandbehavior#notes-on-individual-enumeration-members, that enum member sounds like a very SQL-Server-specific flag.)
Beta Was this translation helpful? Give feedback.
All reactions
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment