TranslationGuideLine

1, Translation is always from left to right.
2, Child relation is always tranlsated into a join to a sub-select.
3, Whenever a column is created with a DbReference which is referring a sub-select, we will need to add the colum into the sub-select. This process of adding columns into sub-select is recursive. 
4, Column will be created if they are directly used in expression or it is required by relationship. Doing group-by or select on entities will also require primary key to be created and added.

commands:
dotnet pack ../EFSqlTranslator.Translation/ -o ../nuget-packages/ --version-suffix rc2
dotnet pack ../EFSqlTranslator.Translation/ -o .
nuget push EFSqlTranslator.Translation.1.2.0.nupkg
git tag -a v1.2.0 -m "Include and OrderBy"
git push --tags
dotnet ef migrations add testPG
dotnet ef database update
dotnet test EFSqlTranslator.Tests/EFSqlTranslator.Tests.csproj

commands to run ConsoleApp:
open postgresql
docker run -p 5432:5432 --name pqsql -e POSTGRES_PASSWORD=mysecretpassword -d postgres