Samples - Adding ChangeTracking Capabilities to Database

[keithnicholson]

I'm looking at running the samples. I noticed that the database scripts in the folders do not implement ChangeTracking at the database or table levels. Are they hidden elsewhere? If not, I can branch off and add them as I write them myself. Then submit a PR for acceptance or denial.

[Charles-Gagnon]

Currently it's just hardcoded as part of our tests - the samples don't include setting that up.

azure-functions-sql-extension/test/Common/TestUtils.cs

Line 120 in 0ec2e69

ExecuteNonQuery(masterConnection, $"ALTER DATABASE [{databaseName}] SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON);", Console.WriteLine);

Having a "General Setup" script to create the database and enable change tracking would definitely be useful if you wanted to look into that! And if you're really looking to make this nice having a SQL Project that users could run to easily set up the DB could be useful!

[keithnicholson]

Working on the SQL project. Would you want it at the root or in the samples folder?

[Charles-Gagnon]

Samples folder makes sense to me!