llblgen 2.5
adapter model
SQLServer 2008
Say I need to add an error record if that error record does not yet already existed.
To check whether the record exists in SQL, we can do something like IF EXIST (SELECT * FROM ERROR WHERE ERRROR_CODE='123')
How do I do that in LLBLGEN? The only thing I find is closest to achieving this is use GetDbCount and if the result is 0 then proceed. This results in SELECT COUNT(*) in SQL.
My understanding is SELECT COUNT is not as efficient as EXIST( ).
How do I check if EXIST in LLBLGEN?
Thanks