Use SQL Server

Grindstone 4 Extension Gallery
4

I am getting the following error when activating Use SQL Server. I think it is trying to insert data out of sequence, inserting into ListValueProperties before the child value has been inserted in ListValues, maybe.

I see that WorkItems is completely populated. I expected to see ListValues and TextProperties to be fully populated. Time slices is not yet populated.

(I get the feeling I am going to be a thorn in your side.)

-- SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ListValues_ListValueProperties". The conflict occurred in database "Grindstone4", table "dbo.ListValueProperties", column 'Id'.
The statement has been terminated.
   at void System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
   at void System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
   at void System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, bool callerHasConnectionLock, bool asyncClose)
   at bool System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, out bool dataReady)
   at void System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, string resetOptionsString, bool isInternal, bool forDescribeParameterEncryption, bool shouldCacheForAlwaysEncrypted)
   at SqlDataReader System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(bool isInternal, bool forDescribeParameterEncryption)
   at object System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, string endMethod, bool isInternal)
   at int System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at int System.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
   at void System.Threading.Tasks.TaskFactory<TResult>.FromAsyncCoreLogic(IAsyncResult iar, Func<IAsyncResult, TResult> endFunction, Action<IAsyncResult> endAction, Task<TResult> promise, bool requiresSynchronization)
   at async Task Submission#0+SqlServerTransactor.ApplyChangesToSqlAsync(ChangeSet changes)
   at async Task Submission#0+SqlServerTransactor.ConnectToSqlServerAsync(string connectionString)
   at async Task Submission#0+SqlServerTransactor.ConnectToSqlServerAsync(string connectionString)
   at void Submission#0+<<<Initialize>>b__0_1>d.MoveNext()