Multiple writes in temp tables

[innuendonh]

Hello, is there any way to write into the same temp table multiple times?

For example, I would like to bulk insert different batches of data (potentially large, i do not want to concat them in memory) into the same temp table, then use the table to perform queries, and finally dispose it.

Specifically, I use Sqlite as a containter to move data between different MS SqlServer databases in different hosts, and I need a way to load and write potentially big tables without worrying about the memory occupation, so this kind of functionality would be extremely useful.

Thank you!

[PawelGerr]

Currently, there is no api to provide the name of existing (temp) table to methods like BulkInsertAsync.

[PawelGerr]

I've added multiple overloads of BulkInsert*IntoTempTable in version 8.4.0/9.2.0

// creates a new temp table and inserts 1 record
await using var tempTable = await ActDbContext.BulkInsertIntoTempTableAsync(new List<CustomTempTable> { new(1, "value") });

// insert another record into exising `tempTable`
await ActDbContext.BulkInsertIntoTempTableAsync(new List<CustomTempTable> { new(2, "value2") }, tempTable);