Generic Data Access

Dec 15 2004 12:47 PM
I have just read the following article A Generic Data Access Component using Factory Pattern and found it very interesting but I have a question regarding the use of reflection here. If I was to use this example in a project that involved a large amount of database activity would the use of reflection to create every connection, command and parameter object degrade the performance of my app. Is the only alternative to using reflection to use switch statements and hardcode the different return values depending of the specified provider.