private int ReadPrimaryKeys(SqlCommand cmd, EntityTable table, string columnName)
        {
            int primaryKeyIndex = 0;

            Logger.Debug($"Reading primary keys inserted into {table.Name}");
            Logger.Debug($"Executing SQL: {cmd.CommandText}");

            using SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                dynamic primaryKey = reader[columnName];

                Logger.Trace($"Inserted '{table.Type.Name}' entity with primary key {primaryKey.ToString()}");

                /*
                 * We need to make sure that the data rows for child entities which have a foreign key relationship
                 * to this newly inserted entity are updated with foreign keys. These are currently set to the default
                 * value of their data type, and so will all be the same - any insert operation attempted at this point
                 * would cause a foreign key exception in SQL.
                 */

                table.UpdatePrimaryKey(primaryKey, primaryKeyIndex);
                table.UpdateForeignKeys(primaryKey, primaryKeyIndex++);
            }

            return(primaryKeyIndex);
        }