Hi, We have a Customer entity which has 100 properties/columns. At some business, some set of columns need to be updated with customer based custom data. Think about that we have a fund batch and this batch create funds and updates Customer with latest fund amount "LastFundAmount".
Customer No Last Fund Amount Last Fund Date 100 333 20190916 101 342 20190916 102 404.3 20190916 103 500 20190916 We don't want to update Customer all properties which may create unnecessary index rebuild on db site, we need to update just changed data, but we don't want to use dynamic update. IQuery query = ISession.CreateQuery(Update Customer Set LastFundAmount = :LastFundAmount, LastFundDate = :LastFundDate where CustomerNo = :CustomerNo); Above hql IQuery api does not have method that we can send list of object? Also Batcher makes some database specific thinks for bulk insert/update so, this hql needs to be send batcher with some "ExecuteUpdateBulk()" method. Our application runs with 3 customer with 3 different database:Oracle, SQLServer, PostgresSql -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/nhusers/4ec41124-a14e-4dce-8f49-6ef5c1e63327%40googlegroups.com.
