How to connect to mysql using mysql connector via C# without actually installing the connector?

Try something like this (I didn't check any possible versions/configurations, but it works currently on my Vista x64 for MySql some 5.5... and . Net connector 6.4.3.0 - using mysql.data. Dll for v4 from .

Net/mono download).

Try something like this (I didn't check any possible versions/configurations, but it works currently on my Vista x64 for MySql some 5.5... and . Net connector 6.4.3.0 - using mysql.data. Dll for v4 from .

Net/mono download). Make sure the referenced mysql.data. Dll assembly below is in your current directory.

Using(var dt = new DataTable()) { dt.Columns. Add("Name"); dt.Columns. Add("Description"); dt.Columns.

Add("InvariantName"); dt.Columns. Add("AssemblyQualifiedName"); dt.Rows. Add("Mysql something", "mysql more", "mysqlClient", "MySql.Data.MySqlClient.

MySqlClientFactory, MySql. Data, Version=6.4.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"); var f = DbProviderFactories. GetFactory(dt.

Rows0); using(var conn = f. CreateConnection()) { conn. ConnectionString = "your string here"; conn.Open(); // and do your work here.Console.

WriteLine(conn); } }.

It has worked for me. Is there is drawback in using this method than installing the connector, like in terms of coding, performance or security etc – Kalpak Jul 10 at 18:32 No drawback to this method other than you'll have to duplicate mysql.data. Dll for all applications that need it.So if you only have one, then this is perfectly fine.

In my case there are several so I ended up putting mysql assemblies in GAC and modifying machine. Config's in all the right places so I could just use DbProviderFactories. GetFactory("string here I gave in configs") to obtain the factory and go from there.

I just like to use those dll's from . Net/mono distribution, having to manually set things up as a result. – Sergei Z Jul 11 at 4:19.

This page doesn't go into much detail about . NET Framework dependency, but I suspect that the Mysql connector might be dependent on a later version of the . NET framework.In other words, your application uses Framework 2, but what version does the Mysql connector use?

It is compatible with v2 as well as v4 of dot net. – Kalpak Jun 18 at 12:17 6.3. * is compatible with ADO.NET version 2. X+, .

NET Framework version 2. X+, 4. X+ for VS 2010 support and MySQL Server version 5.0, 5.1, 5.4, 5.5 as per mysql website – Kalpak Jun 18 at 12:18 I am referring the link dev.mysql.

Com/doc/refman/5.0/en/connector-net-versions. Html – Kalpak Jun 20 at 11:55 It clearly states that the connector work on . Net framework 2.0.

We even tried the same with version 6.0.3 of the connector but it gives the same error – Kalpak Jun 20 at 11:55.

This entry: ... needs to be written into your machine.config. I believe the default path should be something like: C:\WINDOWS\Microsoft. NET\Framework\v2.0.50727\CONFIG Update You should be able to include MySQL .

Net/Connector installer as part of your installation package. The entry in the machine. Config is required for the same reasons that information is required in a web.config.

The people who install the software are not technically sound. So we cant give them to add this entry manually. Is this entry possible via NSIS installer.

– Kalpak Jul 1 at 10:41 Why this entry is required in the first place would be my question – Kalpak Jul 1 at 10:42.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.