'CREATE TABLE permission denied in database' despite using 'UseTempDB'

[cmCJP]

The agent account does not have table permissions. The same code is executed elsewhere, but with different models. The only notable difference is the second model contains a discriminator.

Despite setting the "BulkConfig":

        public void Execute(IList<GroupPupil> Model)//this works
        {
            var now = DateTime.UtcNow;
            Context.BulkInsertOrUpdate(Model.Where(a => a.End == DateTime.MaxValue).ToList(), new BulkConfig { UseTempDB = true });
            Context.BulkDelete(Model.Where(a => a.End < DateTime.MaxValue).ToList(), new BulkConfig { UseTempDB = true });
        }

        public void Execute(IList<Pupil> Model)//this fails
        {
            var now = DateTime.UtcNow;
            Context.BulkInsertOrUpdate(Model, new BulkConfig { UseTempDB = true });
        }

Non-temp table is created and insert fails:

SELECT TOP 0 T.[Id], T.[Discriminator], T.[GivenName], T.[Guid], T.[PreferredName], T.[SourceType], T.[Surname] INTO [Organisation].[PersonTemp280004e2] FROM [Organisation].[Person] AS T LEFT JOIN [Organisation].[Person] AS Source ON 1 = 0;

Using Latest - 2.3.6

Any advice?

[borisdj]

There is remark about this in README:

UseTempDB when set then BulkOperation has to be inside Transaction.

[cmCJP]

Thanks, my bad. Great library though.

[borisdj]

You are welcome. Glad it was useful.