Add generator option for newlines between statements

[Stefan-Puskarica]

Currently the generator only generates one newline between statements which leads to code like this:

CREATE TABLE [MyTable] (
  ...
);
ALTER TABLE [MyTable]
  ...;

Which can be unfavourable, I've added a script generator option that allows you to specify how many newlines you want so you can get something like this instead:

CREATE TABLE [MyTable] (
  ...
);

ALTER TABLE [MyTable]
  ...;

[Stefan-Puskarica]

@microsoft-github-policy-service agree

[llali]

Please also add tests to verify the new option

[Stefan-Puskarica]

the new option is not added to SqlScriptGeneratorOptions so this will have build error.

Hi, I'm not sure what you mean, it was added to the .xml file. As far as I can see there is no tracked .cs equivalent to be generated rather it is generated at build time. When I built and tested locally it worked for me

[Stefan-Puskarica]

Please also add tests to verify the new option

Where should this go? I don't see any current tests for SQL generation

[Stefan-Puskarica]

@llali can I get an update on this?

[llali]

the new option is not added to SqlScriptGeneratorOptions so this will have build error.

Hi, I'm not sure what you mean, it was added to the .xml file. As far as I can see there is no tracked .cs equivalent to be generated rather it is generated at build time. When I built and tested locally it worked for me

you are right my bad.

[llali]

@llali can I get an update on this?

Please add test for this new option. Thanks

[Stefan-Puskarica]

@llali can I get an update on this?

Please add test for this new option. Thanks

I've added a test