Requires .NET framework 4 updated to at least 4.0.2. If you have 4.0.2, then you should have HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft.NETFramework\v4.0.30319\SKUs.NETFramework,Version=v4.0.2 If you have installed latest VS 2012 chances are that you already have 4.0.2. Just verify first. Next you need to have an instance of LocalDb. By default you have an instance whose name is a single … Read more
The posted answer is fine but didn’t directly answer the same question I had about reading in a connection string. Through much searching I found a slightly simpler way of doing this. In Startup.cs public void ConfigureServices(IServiceCollection services) { … // Add the whole configuration object here. services.AddSingleton<IConfiguration>(Configuration); } In your controller add a field … Read more
Place single quotes around the Extended Properties: OleDbConnection oconn = new OleDbConnection( @”Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” + path + “;Extended Properties=”Excel 8.0;HDR=YES;IMEX=1;”;”); Try it, it really works.
If your migration does not work correctly try to set Database.Initialize(true) in DbContext ctor. public CustomContext(DbConnection connection) : base(connection, true) { Database.Initialize(true); } I have similar problem with migrations. And in my solution I have to always set database initializer in ctor, like below public CustomContext(DbConnection connection) : base(connection, true) { Database.SetInitializer(new CustomInitializer()); Database.Initialize(true); } … Read more
You need to add a reference to System.Configuration and then use: System.Configuration.ConfigurationManager. ConnectionStrings[“connectionStringName”].ConnectionString;
Assuming your driver is in path, String url = “jdbc:mysql://localhost/test”; Class.forName (“com.mysql.jdbc.Driver”).newInstance (); Connection conn = DriverManager.getConnection (url, “username”, “password”);
You can also use this, it’s simpler. The only thing you need to set is “YourDataBaseName”. <connectionStrings> <add name=”ConnStringDb1″ connectionString=”Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;” providerName=”System.Data.SqlClient” /> </connectionStrings> Where to place the connection string <?xml version=’1.0′ encoding=’utf-8′?> <configuration> <connectionStrings> <clear /> <add name=”Name” providerName=”System.Data.ProviderName” connectionString=”Valid Connection String;” /> </connectionStrings> </configuration>
There is a known bug with specifying default command timeout within the EF connection string. http://bugs.mysql.com/bug.php?id=56806 Remove the value from the connection string and set it on the data context object itself. This will work if you remove the conflicting value from the connection string. Entity Framework Core 1.0: this.context.Database.SetCommandTimeout(180); Entity Framework 6: this.context.Database.CommandTimeout = … Read more
.NET DataProvider — Standard Connection with username and password using System.Data.SqlClient; SqlConnection conn = new SqlConnection(); conn.ConnectionString = “Data Source=ServerName;” + “Initial Catalog=DataBaseName;” + “User id=UserName;” + “Password=Secret;”; conn.Open(); .NET DataProvider — Trusted Connection SqlConnection conn = new SqlConnection(); conn.ConnectionString = “Data Source=ServerName;” + “Initial Catalog=DataBaseName;” + “Integrated Security=SSPI;”; conn.Open(); Refer to the documentation.
A bit late on this answer but I think there’s a potential way to do this with a neat little extension method. We can take advantage of the EF convention over configuration plus a few little framework calls. Anyway, the commented code and example usage: extension method class: public static class ConnectionTools { // all … Read more