Add support for custom `BulkIdStrategy`

[sebastieno]

Hello all,

I have this kind of code :

this.session.Query<EventEntity>()
     .Where(e => [...])
     .Update(c => new { Enabled = true });

which generate the following SQL :

insert into HT_event SELECT evententit0_.Id as Id FROM event evententit0_ WHERE [...]
UPDATE event SET Enabled=? WHERE (Id) IN (select Id from HT_event)

My EventEntity is a base class (I have inheritance using table per class hierarchy inheritance mapping with mapping by code). I just tried to update a field on the base class, according to a simple where clause and I want to avoid the creation of a temp table.

I found that Hibernate offer a way to modify the BulkIdStrategy to use an inline clause for example : http://in.relation.to/2017/02/01/non-temporary-table-bulk-id-strategies/

When do you plan to add this feature to NHibernate ? Thanks a lot for your help.

[fredericDelaporte]

As far as I know, no one works on this. It can be you.

But can you please clarify the issue you have opened? It seems you are requesting some way to customize the bulk id strategy, but the title and most of the description is about the trouble pushing you to ask for that feature. For a feature request, the issue title and description should be about the requested feature, with eventually a side note in the description explaining why the feature is useful (so here, the case causing you to ask this).

[sebastieno]

Hello,

Thanks for your reply. Indeed, I was just searching how to customize the bulk id strategy (I change the issue title). I don't know if I am capable to work on that feature but I will try soon :).