Hi everyone,
I wanted to build a custom query builder. I can use do this is by using SetCommandText with RetrievalQuery. However, using RetrievalQuery, the SQLCommand is fixed to a certain database to communicate. It is not flexible when changing other database.
Though, Stored Procedure can be used to fetch data in which it will not call any Entity or Entity Fields but returned as a DataTable or other types instead.But is there other ways to achieve this? How do one can make a custom query builder without using Entity. It is similar to SetCommandText with RetrievalQuery but does it have any functions to use so that it is flexible (can communicate with different database)? Thank you.
