Resetting the connection to Oracle schema
Hello,
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.
Thank you.
Comments
You probably need to refresh the connection to regenerate the class objects again for the new schema. Right-click on the connection and click "Refresh" to refresh it.
I saw that and tried it. I will certainly try it again but it did not work for me.
Thanks for the assist. I'll report back.