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

Optionally turn off use of table aliases #10

Open
caseycesari opened this issue Oct 15, 2014 · 1 comment
Open

Optionally turn off use of table aliases #10

caseycesari opened this issue Oct 15, 2014 · 1 comment

Comments

@caseycesari
Copy link

In a join, If you need to preface an ambiguous field with a table name in a handwritten expression, you have to use the table alias, i.e. alias.FieldName. If the join order changes, the alias changes. It would be better to use TableName.FieldName, but once an alias is declared for a table, you can no longer reference the table by name.

There should be an option to turn table aliases off for joins. I'm not exactly sure at the moment where this would be passed, though.

@maurizi
Copy link

maurizi commented Oct 15, 2014

For reference, the code which creates the SELECT statements (and thus the table alises) is https://github.com/azavea/net-dao/blob/nuget/SQL/SqlDaJoinableLayer.cs#L111-L188

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

3 participants