Greetings,
I'm trying to connect my Firebird database to Visual Studio; the connection from Firebird console shell, works and the service is active; it gives me exception error when connecting in Visual STudio; what happens in your opinion and how can I find the error?
Place the connection string in :
appsettings.json
{
"ConnectionStrings": {
"DefaultConnection": "Database=C:\\Progetti\\;DataSource=localhost;User=SYSDBA;Password=masterkey;Port=3050;Role=;CharSet=NONE;"
},
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft.AspNetCore": "Warning"
}
},
"AllowedHosts": "*"
}
IN THE FILE SERVICES :
THE CODE :
......
using (var conn = CreateConnection())
{
return (await conn.QueryAsync(sql)).ToList();
}
}
catch (Exception)
{
return new List();
}
After the execution,
using (var conn = CreateConnection()) the state of database is CLOSED
WHY?
The same project and same DB on another Visual Studio Platform on WIN works.
Thanks
-------------------------------->
This morning I launched the project and now it works I don't understand what it can be. I think perhaps of some Firbird service that I had checked and it was active that did not work, so it may have affected the restart of my machine also I downloaded a certificate at the start of VS
