Warning
This provider is End of Life and will no longer be maintained or supported.
Microsoft ended extended support in July 2021.
The delimiter in a multi statement script should be on a new-line. I.e:
ALTER TABLE "MyTable" ADD "foo" int default null
;
ALTER TABLE "MyTable" ADD "bar" int default null
;
For successful unit testing install
- SQL Server Compact 4.0 SP1 https://www.microsoft.com/en-us/download/details.aspx?id=30709