I have a program which should work against multiple DBs. Some the DBs don't have the capability of SP. Because of that I want to store the sql commands inside text files. Now, I want to create a generic method which read the text files and run them but I want this method to be as stupid as possible because I want to reduce any compilation to the code since this program is sent to the end user. I don't want my program to decide which params to send since any change to that will cause to compilation. My initial solution is to put tokens inside the text files which will match the names of the properties of an object I'll send to the generic method and by using reflection I'll replace any token which exists in the specific file. what do you think about my solution, and do you have other ideas?
Tsahi Bar
No comments:
Post a Comment