How can I read a connection string from a web.config file into a public class contained within a class library? I’ve tried: WebConfigurationManager ConfigurationManager But these classes are not recognized within my class library. 12 Answers 12
I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this: jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:XYZ XYZ was the Oracle SID. Now I need to connect to a different Oracle database that does not use a SID, but uses an Oracle “Service Name” instead. I … Read more
I am getting timeouts using the Entity Framework (EF) when using a function import that takes over 30 seconds to complete. I tried the following and have not been able to resolve this issue: I added Default Command Timeout=300000 to the connection string in the App.Config file in the project that has the EDMX file … Read more
var connection = ConnectionFactory.GetConnection( ConfigurationManager.ConnectionStrings[“Test”] .ConnectionString, DataBaseProvider); And this is my App.config: <?xml version=”1.0″ encoding=”utf-8″ ?> <configuration> <connectionStrings> <add name=”Test” connectionString=”Data Source=.;Initial Catalog=OmidPayamak;Integrated Security=True” providerName=”System.Data.SqlClient” /> </connectionStrings> </configuration> But when my project runs this is my error: Object reference not set to an instance of an object. 22 Answers 22
I have two apps that use Integrated Security. One assigns Integrated Security = true in the connection string, and the other sets Integrated Security = SSPI. What is the difference between SSPI and true in the context of Integrated Security? 9 s 9 Integrated Security=true; doesn’t work in all SQL providers, it throws an exception … Read more
