With https://github.com/microsoft/durabletask-mssql/pull/110, IDEs like Visual Studio were no longer able to parse the SQL files because the {{ and }} characters were not valid in many contexts. This PR replaces {{ and }} with __ (double underscores) so that IDEs don't flag the placeholders as syntax errors.
With this change, I validated that I was able to execute all the .sql files directly against my local SQL database without doing any text substitution. We'll still do text substitution at runtime. This change is purely to simplify local development of the T-SQL code.
This PR also adds support for custom schema names to Azure Functions via a new schemaName field in the host.json settings.
With https://github.com/microsoft/durabletask-mssql/pull/110, IDEs like Visual Studio were no longer able to parse the SQL files because the
{{and}}characters were not valid in many contexts. This PR replaces{{and}}with__(double underscores) so that IDEs don't flag the placeholders as syntax errors.With this change, I validated that I was able to execute all the .sql files directly against my local SQL database without doing any text substitution. We'll still do text substitution at runtime. This change is purely to simplify local development of the T-SQL code.
This PR also adds support for custom schema names to Azure Functions via a new
schemaNamefield in the host.json settings.