Question

Update query class

Hi Community. 
I have this piece of code: 

segmentationBatch is List 

but postgres throws an error that it can't compare uuid with uuid[] - which is understandable, but how do I pass a list of Id's into the update? 

Has anyone came accross this issue? 

 

P.S. I need it that way because it's a batch of records that I need to update and I need to keep those Id's for the following logic so I cannot rebuild the filtering criteria here.

var update = new Update(UserConnection, EntitySchemaName)
                .Set("UsrProfitCenter", Column.Parameter(segmentation.ProfitCenter))
                .Where("Id").In(Column.Parameter(segmentationBatch)) as Update;
            return update.Execute();
Like 0

Like

1 comments

Upd: 
Figured it out myself

 

 .Where("Id").In(Column.Parameters(segmentationBatch))
Show all comments