Hi!
Maybe I am just dreaming. But can this be a way to use your own Sql-statement but within the LLBLGen framework?
I sometimes have queries that either are too hard to convert to predicates or (from reading the forums) sometimes are not even possible to convert. That is unless I resort to sprocs or views, but I am not willing to do that since I am working on an enterprise level product with nearly 200 tables. If I had to add a sproc or view everytime I could not solve something with predicates it would be very messy indeed. To me manageability is everything and wading through sprocs and views in order to work out what a small little getXXXX function returns is simply not manageble.
I can obviously use .NET's own SQLClient capabilities to return DataTables. But I have not yet been able to work out how I can invoke a LLBLGen Transaction into it. If somebody can give me a pointer towards how that can be done I would probably simply just do that.
If however, that is not possible, then I wonder if deriving a class from Predicate would give me the freedom to come up with any SQL-query and be able to attach my LLBGen transaction to it. That would possibly be even better. Since then I could perhaps use the GetMulti to return Entity Collections, and perhaps use GetScalar for simple getXXX functions.
If it is possible to use a derived Predicate class for this I would be very grateful for some example code. That is, what the class would look like and how it would be used.
Hopefully,
!Rob