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𔴑
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𔲫
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