Resetting the connection to Oracle schema
I am new to Linq and LinqPad so I apologize for asking the obvious.
I have a Linq query set up to point to an Oracle schema, let is call it schema1. All works as expected and now I want to apply that same query to Schema2. I go to the config file that is pointed to by the connection and update the connection string appropriately and save it. I then go back to LinqPad and refresh the connection.
However, I am finding that the results I receive seem to still be coming from schema1. I close LinqPad and re-open it with my query and I get the results I expect.
I perceive that I should not have to close the app to get this to work but I am at a loss to figure out what I am doing incorrectly. Your assistance will be appreciated.