-
Notifications
You must be signed in to change notification settings - Fork 3.4k
Description
At present we identify the default schema using SELECT SCHEMA_NAME()
But default schema is user specific. So different users may have different schema. This can give rise to different scaffolded code based on who ran the rev eng & cause ugly version control diffs especially once update model for database is implemented.
If we stop scaffolding default schema then if the schema is anything other than "dbo" (which is our default) then it will be used in scaffolding objects. (like ToTable("tablename", "nondefaultschema")) but it will produce more consistent code across users.
Another option is to take command line argument for default schema so user can specify what to consider as default schema as opposed to we trying to guess based on user. But we can defer this to customer feedback.
@bricelam - comments?