Hello, we are using the Adapter model with LLBLGen Pro 3.1.

We have a situation where we need to insert thousands or rows at once from another table in the DB. The most efficient way to do this is through an INSERT INTO SELECT statement.

I've come across this post: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=15195&StartAtMessage=0&#85265

It gives a nice code sample to add to the DataAccessAdapter that seems to do the trick. However, the code uses reflection to accomplish the work and I am concerned about reflectively calling a method where the signature may change over time - which will cause our code to have a runtime exception.

Frans mentioned that the feature would be considered for v3 here: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=15195&StartAtMessage=0&#85163

Can someone let me know if the INSERT INTO SELECT feature was added, but I just can't find it? Or if it is something still on the drawing board.

Does anyone have any other alternatives other than using reflection?

Thanks, Adam

There are no plans to support this in the near future. The method reflected is protected now I think (instead of private). Can't you just call it without reflection?

Otis, It doesn't seem to be protected, but I think we are going to take another approach anyway. Thank you for your support (especially on the weekends )