EFCore Bulkextension's BulkInsertAsync not setting the id (identity field)

[AnandSonake]

EFCore Bulkextension's BulkInsertAsync not setting the id (identity field).

we are using EFCore.BulkExtensions version 6.3.3 and as per this link this issue is fixed in v5.3.7. Is it really fixed or am I missing anything here ? We are getting negative id in result variable the below code:

public async Task InsertAsync(List users)
{
BulkConfig bulkCOnfig = new BulkConfig()
{
SetOutputIdentity = true
};
await this.BulkInsertAsync(users, bulkCOnfig);

 var result = users.FirstOrDefault().Id;

}
But if I use BulkInsertOrUpdateAsync then I'm getting Ids all records except the last one, not sure why BulkInsertAsync not returning the ids.

[AnandSonake]

Is it possible to update the MERGE operation to make use of OUTPUT clause to return the IDs of records inserted using BulkInsertAsync or BulkInsert ?

Reference:
https://stackoverflow.com/questions/77343372/efcore-bulkextensions-bulkinsertasync-not-setting-the-id-identity-field?noredirect=1#comment136354159_77343372

[AKlaus]

Can confirm the issue on the latest version v8.1.2 against the SQL Server.

Steps to reproduce are as per the OP's code:

BulkConfig bulkCOnfig = new BulkConfig 
{       
   SetOutputIdentity = true.  // This's the culprit
};
await this.BulkInsertAsync(users, bulkCOnfig);
var result = users.FirstOrDefault().Id;  // It's NULL

If the SetOutputIdentity parameter is false, then the Id gets set, but there's no way to fetch the number of affected records.

Here's the OP's post on StackOverflow.