Yes you're right
The first thing i was trying to test, is get connection with database just with the same connection string using the method constructor with nameOrConnectionString param, but i can't connect, as i described in above post, so the next step is pass user and password as parameters, in fact i don't know how neither.
Thanks a lot for your help
This is how we did it with no success :( ...
public Backend_MintDbContext(string nameOrConnectionString) : base(CreateDynamicConnectionString()) {
}
private static string CreateDynamicConnectionString() { return "DATA SOURCE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx.xxx.xxx)(PORT=xxxx)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxxx)));PASSWORD=xxxx;PERSIST SECURITY INFO=True;USER ID=xxxx; enlist=dynamic;"; }
This is our currently working default connection string, we are using the same connection string on above method
<connectionStrings> <add name="Default" connectionString="DATA SOURCE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx.xxx.xxx)(PORT=xxxx)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxxx)));PASSWORD=xxxx;PERSIST SECURITY INFO=True;USER ID=xxxx; enlist=dynamic;" providerName="Oracle.ManagedDataAccess.Client" /> </connectionStrings>
And we remove this constructor
public Backend_MintDbContext() : base("Default") {
}
So it's not working in that way ... what can be wrong ? thanks for your help
Sure ! thank you so much for your time
I'm have uploaded tree images with the important stuff.
This is the detailed exception (just let me know if you need more details, i've been stucked on that :cry: , so any extra info, i'll reply, as soon as possible) <a class="postlink" href="https://www.dropbox.com/s/vzas0r5aqmvlz47/1.jpg?dl=0">https://www.dropbox.com/s/vzas0r5aqmvlz47/1.jpg?dl=0</a>
Caused by getAll query <a class="postlink" href="https://www.dropbox.com/s/6ntu9t8irh8kw59/2.jpg?dl=0">https://www.dropbox.com/s/6ntu9t8irh8kw59/2.jpg?dl=0</a>
And this is my model <a class="postlink" href="https://www.dropbox.com/s/x3bazvhi5rlr8i4/3.jpg?dl=0">https://www.dropbox.com/s/x3bazvhi5rlr8i4/3.jpg?dl=0</a>
I'm using entity framework 6, and ODP 12.1.022 ... could you tell me please which versions are u using ? x86 or x64 ?
Thanks a lot :D
Url for image <a class="postlink" href="https://www.dropbox.com/s/bkmntfzgojuzc61/Captura.PNG?dl=0">https://www.dropbox.com/s/bkmntfzgojuzc ... a.PNG?dl=0</a>