MySQL Forums - C#, Mono, .Net

Add Reference Confusion (VSE 2012) (1 reply)

Bob Anonymous — Fri, 03 May 2013 16:16:39 +0000

I am trying to following an example here
http://www.dreamincode.net/forums/topic/115753-use-vbnet-to-connect-to-mysql/
to create my first ever VB.Net app which can talk to MySQL.

I've downloaded and installed the connector.

The Add Reference on my VSE 2012 looks different than the one in the example (no .NET category!). But in Assemblies:Extensions I find 7! entries named MySqlsomething: MySql.Data (twice!), MySql.Data.CF, MySql.Data.Entity (twice!), and MySql.Web (twice!). All are identified as Version 6.6.5.0. Which one(s) do I need to specify?

Thanks Much, Bob

MySQL Connector/Net 6.7.2 Beta has been released (no replies)

Fernando Gonzalez Sanchez — Tue, 30 Apr 2013 19:09:45 +0000

MySQL Connector/Net 6.7.2, a new version of the all-managed .NET driver for MySQL has been released. This is the first beta release intended to introduce users to the new features in the release. This release is feature complete, it should be stable enough for users to understand the new features and how we expect them to work. As is the case with all non-GA releases, it should not be used in any production environment. It is appropriate for use with MySQL server versions 5.0-5.7.

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The 6.7 version of MySQL Connector/Net brings the following new features:
- WinRT Connector.
- Load Balancing support.
- Entity Framework 5.0 support.
- Memcached support for Innodb Memcached plugin.
- This version also splits the product in two: from now on, starting version 6.7, Connector/NET will include only the former Connector/NET ADO.NET driver, Entity Framework and ASP.NET providers (Core libraries of MySql.Data, MySql.Data.Entity & MySql.Web). While all the former product Visual Studio integration (Design support, Intellisense, Debugger) will be released in a separated plugin for Visual Studio product.

WinRT Connector
-------------------------------------------
The major feature introduced in this Beta. Now you can write MySql data access apps in Windows Runtime (aka Store Apps) using the familiar API of Connector/NET for .NET.
The following features are supported:
- Open a connection using most of the connection string attributes: (database, pooling, user variables, etc)
- Execute queries using MySqlDataReader: it can execute queries and show commands
- Execute non queries: it can execute DML statements: Insert, delete, update
- Change database
- Password expiration
- Basic connection attributes (connector name and operating system only)
- Authentication plugins (mysql native password only)
- Connections pool
- Connection clone
- Connection timeout
- Abort connection
- Ping

Features not supported in this release:
- Authentication with other protocols than native mysql (specifically sha256 & windows integrated security).
- SSL encryption for connections.

Known issues:
- Due to indeterministic RT Garbage Collection, is better to explicitely call Close/Dispose on a connection than setting reference to null.

Other features not planned to be supported:
- MySqlCommandBuilder
- Entity Framework
- ASP.NET Providers.

Load Balancing Support
-------------------------------------------
Now you can setup a Replication or Cluster configuration in the backend, and Connector/NET will balance the load of queries among all servers making up the backend topology.

Entity Framework 5.0
-------------------------------------------
Connector/NET is now compatible with EF 5, including special features of EF 5 like spatial types.

Memcached
-------------------------------------------
Just setup Innodb memcached plugin and use Connector/NET new APIs to establish a client to MySql 5.6 server's memcached daemon.

Enjoy and thanks for the support!

Data Module using MySQL (1 reply)

Ricardo Jacobs — Mon, 29 Apr 2013 19:04:21 +0000

I think I'm re-inventing the wheel. But I do not know which wheel is currently the standard. I am developing an application that uses MySQL as the database server. In this way, this application can be used on multiple computers on the network.

To use the database throughout the application I thought being smart by writing a class that connects and perform queries but unfortunately more difficult steps are needed in order to make my class work perfectly. The **2** problems I currently have:

I can only query one query at the time.
---------------------------------------

For example: The user that start-up the application needs to login. After that is successful, the application sets some variables that can be used throughout the whole application. See the code:

profile.gebruikersID = SQLHook.Results("SELECT * FROM tblgebruikers WHERE GebruikersNaam = '" & TextGebruikersNaam.Text.Replace("'", "''") & "'", "GebruikersID")
profile.gebruikersNaam = SQLHook.Results("SELECT * FROM tblgebruikers WHERE GebruikersNaam = '" & TextGebruikersNaam.Text.Replace("'", "''") & "'", "gebruikersNaam")
profile.gebruikersRole = SQLHook.Results("SELECT * FROM tblgebruikers WHERE GebruikersNaam = '" & TextGebruikersNaam.Text.Replace("'", "''") & "'", "gebruikersRole")

`profile.` is a class that uses get and set. SQLHook is a variable set for the MySQL Class `Dim SQLHook As New MySQL()`

SQL Injection
-------------

I think I'm pretty much don't know anything how to protect from injections. I have read an article about [parameterized SQL][1] but I understood a little and I was demotivated because my class is not good enough.

My MySQL Class:
---------------

Imports MySql.Data.MySqlClient

Public Class MySQL
Public Function Connect()
Dim verbinding As MySqlConnection

verbinding = New MySqlConnection()
verbinding.ConnectionString = "Server=localhost; uid=root; pwd=root; database=test;"

Try
verbinding.Open()

Return verbinding
Catch myerror As MySqlException
verbinding.Close()
verbinding.Dispose()

Return myerror.Message
End Try
End Function

Public Function Datagid_Result(ByVal sql)
Try
Dim conn = Connect()

Dim myAdapter As New MySqlDataAdapter
Dim myData As New DataTable
Dim myCommand As New MySqlCommand()

myCommand.Connection = conn
myCommand.CommandText = sql
myAdapter.SelectCommand = myCommand

myAdapter.Fill(myData)

Return myData
Catch myerror As MySqlException
Debug.Print("De server retourneerde de volgende foutmelding: " & myerror.Message)

Return DBNull.Value
End Try
End Function

Public Function num_results(ByVal sql)
Try
Dim conn = Connect()

Dim myAdapter As New MySqlDataAdapter
Dim myCommand As New MySqlCommand()

myCommand.Connection = conn
myCommand.CommandText = sql
myAdapter.SelectCommand = myCommand

Dim myData As MySqlDataReader
myData = myCommand.ExecuteReader()

Return myData.GetInt32(0)

Catch myerror As MySqlException
Debug.Print("De server retourneerde de volgende foutmelding: " & myerror.Message)

Return 0
End Try
End Function

Public Function Counter(ByVal sql)
Try
Dim conn = Connect()
Dim myCommand As New MySqlCommand(sql, conn)
Dim count = myCommand.ExecuteScalar()

Return count
Catch myerror As MySqlException
Debug.Print("De server retourneerde de volgende foutmelding: " & myerror.Message)

Return 0
End Try
End Function

Public Sub Query(ByVal sql)
Try
Dim conn = Connect()
Dim myCommand As New MySqlCommand

myCommand.CommandText = sql
myCommand.Connection = conn

myCommand.ExecuteNonQuery()
Catch myerror As MySqlException
Debug.Print("De server retourneerde de volgende foutmelding: " & myerror.Message)

Exit Sub
End Try
End Sub

Public Function Results(ByVal sql As String, ByVal fieldName As String) As String
Dim conn As MySqlConnection = Connect()
Dim myCommand As New MySqlCommand(Sql, conn)
Dim myData As MySqlDataReader = myCommand.ExecuteReader()

Try
myData.Read()

Dim fieldValue As Object = myData.Item(fieldName)

myData.Close()

Return fieldValue.ToString
Catch myerror As MySqlException
Debug.Print("De server retourneerde de volgende foutmelding: " & myerror.Message)

myData.Close()

Return ""
End Try
End Function
End Class

I hope somebody could advise/solve my problems above and suggest something. Thank you. A visual basic beginner.

[1]: http://www.codinghorror.com/blog/2005/04/give-me-parameterized-sql-or-give-me-death.html

MySQL Connector/Net 6.7.1 Alpha 2 has been released (no replies)

Fernando Gonzalez Sanchez — Fri, 12 Apr 2013 18:40:01 +0000

MySQL Connector/Net 6.7.1, a new version of the all-managed .NET driver for MySQL has been released. This is the second of two alpha releases intended to introduce users to the new features in the release. This release is not feature complete and there are significant limitations but it should be stable enough for users to understand the new features and how we expect them to work. As is the case with all non-GA releases, it should not be used in any production environment. It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The 6.7 version of MySQL Connector/Net brings the following new features:

- Load Balancing support.
- Entity Framework 5.0 support.
- Memcached support for Innodb Memcached plugin.
- This version also splits the product in two: from now on, starting version 6.7, Connector/NET will include only the former Connector/NET ADO.NET driver, Entity Framework and ASP.NET providers (Core libraries of MySql.Data, MySql.Data.Entity & MySql.Web). While all the former product Visual Studio integration (Design support, Intellisense, Debugger) will be released in a separated plugin for Visual Studio product.

Load Balancing Support
-------------------------------------------
Now you can setup a Replication or Cluster configuration in the backend, and Connector/NET will balance the load of queries among all servers making up the backend topology.

Entity Framework 5.0
-------------------------------------------
Connector/NET is now compatible with EF 5, including special features of EF 5 like spatial types.

Memcached
-------------------------------------------
Just setup Innodb memcached plugin and use Connector/NET new APIs to establish a client to MySql 5.6 server's memcached daemon.

The following bug fixes are provided in this 6.7.1 release:
- Fix for Bug Assemblies for .net 4.5 are not included in the installation (Oracle Bug #16463655).
- Fix for Bug Geometry Provider Incompatible Exception (Oracle Bug # 16453250).

Enjoy and thanks for the support!

Can I embed MySQL (5.6, Community) in a C# app (1 reply)

Roy Wilkinson — Mon, 08 Apr 2013 15:17:50 +0000

I'm trying to embed MySQL (Community edition) in a C#/Windows app. Is there some straightforward/easy way to do this in 5.6? I can't tell if this version of MySQL supports being embedded, let alone figure out how to interface to it from C#. Any info/leads would be appreciated.

Get C# Event when table trigger is up. (1 reply)

Nadav Wolfin — Mon, 01 Apr 2013 18:24:40 +0000

Hello,
I writing a simple c# application whose aim is to display logs tablet and act in accordance with any new log record entering.
In case of error do A...
In case of warning do B..
and so on.

Is there a way to get an event in c # when trigger activated in DB?

Thanks,
Nadav.

MySQL Connector/Net 6.5.6 Maintenance Release has been released (no replies)

Fernando Gonzalez Sanchez — Sun, 24 Mar 2013 01:13:00 +0000

MySQL Connector/Net 6.5.6, a new maintenance release of our 6.5 series, has been released. This release is GA quality and is
appropriate for use in production environments. Please note that 6.6 is our latest driver series and is the recommended product for development. It is now
available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

While 6.5.6 is recommended over 6.5.5, for the most feature complete & stable Connector/NET version for production we recommend 6.6.5.

The 6.5.6 version of MySQL Connector/Net brings the following fixes:
- Fix internal bug "Parser cannot recognize row_count in grammar version 5.6" (id task 326).
- Fixed missing keywords not working as ids (without quoting) in parser: value, status, unknown & some unit tests.
- Fix for Datetime precision doesn't work with code first or model first. (Oracle bug #15972773).
- Fix for Support for current_timestamp as default for datetime with ef for server 5.6 (Oracle bug #15935094).
- Adding support for Geometry type. Unit Tests included. Supporting server 5.1 and further.
- Added support for new connect attributes feature in server 5.6 (Oracle bug #15935112).
- Added protocol support for password expiration (Oracle bug #15935104).
- Added to parser missing "alter user ... password expire".
- Fix for "Debugger error on stored procedure", which is actually a parser bug (parser was expecting decimal both precision & scale),
(bug MySql #67975, Oracle bug #16079735).
- Added support for password hashing with appropriate strength for server 5.6 (Oracle bug #15935128).
- Fix for GetSchema returning MySqlException instead of ArgumentException when passing an invalid collection name
(Oracle bug #16271425, MySql bug #67901).
- Fix for EF 4.3 failing when FK identifiers are too long (MySql bug #67285, Oracle bug #16286397).
- Fix for race condition on ConnectionStringBuilder when using multiple threads
(MySql bug #68217, Oracle bug #16310698).
- Fix for stored routines being edited from Server explorer appear as ALTER, which may led
to syntax errors, which may led to Intellisense to stop working (Oracle bug #16357595).
- Fix for Error in Server Explorer when refreshing a table or view (Oracle bug #16363908).
- Fix for Intellisense not available for Views (Oracle bug #16384218).
- Fix for "When saving a new stored procedure, it raises a windows error message", due to
using definer (Oracle bug #16363828).
- Fix for "The first time a new stored routine is saved, after save, Intellisense doesn't work (Oracle bug #16384238).
- Fix for "Error when saving after changing an existing stored routine name in SQL in the editor" (Oracle bug #16390757).
- Fix for server explorer error opening a remote connection (Oracle bug #16357786).
- Fix for password expiration, new password dialog failed (Oracle bug #16357752).
- Fix for InvalidCastException thrown when executing an stored function (MySql bug #64633, Oracle bug #13864627).
- Fix for Default Command Timeout not applying for EFMySqlCommand (MySql bug #67171, Oracle bug #14825670).

The release is available to download at
http://dev.mysql.com/downloads/connector/net/6.5.html

Documentation
You can view current Connector/Net documentation
at http://dev.mysql.com/doc/refman/5.5/en/connector-net.html

You can find our team blog at http://blogs.oracle.com/MySQLOnWindows.
You can also post questions on our forums at http://forums.mysql.com/.

Enjoy and thanks for the support!

MySQL Connector/Net 6.7.0 Alpha has been released (no replies)

Fernando Gonzalez Sanchez — Fri, 22 Mar 2013 18:04:09 +0000

MySQL Connector/Net 6.7.0, a new version of the all-managed .NET driver for MySQL has been released. This is the first of two alpha releases intended to introduce users to the new features in the release. This release is not feature complete and there are significant limitations but it should be stable enough for users to understand the new features and how we expect them to work. As is the case with all non-GA releases, it should not be used in any production environment. It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The 6.7 version of MySQL Connector/Net brings the following new features:

Load Balancing support.
Entity Framework 5.0 support.
Memcached support for Innodb Memcached plugin.
This version also splits the product in two: from now on, starting version 6.7, Connector/NET will include only the former Connector/NET ADO.NET driver, Entity Framework and ASP.NET providers (Core libraries of MySql.Data, MySql.Data.Entity & MySql.Web). While all the former product Visual Studio integration (Design support, Intellisense, Debugger) will be released in a separated plugin for Visual Studio product.

Load Balancing Support
-------------------------------------------
Now you can setup a Replication or Cluster configuration in the backend, and Connector/NET will balance the load of queries among all servers making up the backend topology.

Entity Framework 5.0
-------------------------------------------
Connector/NET is now compatible with EF 5, including special features of EF 5 like spatial types.
A known issue is that in this release you'll need to use MySql.Data.Entity assembly for .NET 4.0 with EF 5, in the future we will include a version of that assembly for .NET 4.5.

Memcached
-------------------------------------------
Just setup Innodb memcached plugin and use Connector/NET new APIs to establish a client to MySql 5.6 server's memcached daemon.

Enjoy and thanks for the support!

MySQL Connection string to Context (3 replies)

Samantha Martin — Sat, 27 Apr 2013 04:46:08 +0000

I am trying to figure out how to pass a MySQL connection string through a datacontext. I keep getting a exception thrown when it gets to the DataContext "login failed at user: root". I believe it thinks im using SQL Server and I do not know where I am going wrong. Any guidance would be appreciated.
Its an app the the user plugs in the values to the database and it gets the info to and from the database.

//This gets the values the user enters to access the databse and returns the //string to where its needed

private string MustangConnString()
{
string connStr = ("persist security info = true;server=" + Server + ";uid=" + username + ";database=" + Database + ";pwd=" + Password + );

MySqlConnection myConnectionString = MySqlConnection(connStr);

myConnectionString.Open();

return myConnectionString.ConnectionString;
}

//This is where the connection string is needed
private void ect (bool oneanddon)
{

MySqlConnection myConnectionString = new MySqlConnection(ConnectionString);
myConnectionString.Open();

//I am getting the error here, Like I said I believe it thinks im trying to log //into an SQL servr database and I don't know how to solve this.
using (var MessageConn = new DataContext(myConnectionString.ConnectionString))
{
var cos = MustangConn.COS.ToList();
}

}

MySQL stops responding due to many connections (1 reply)

Jose Joseph — Mon, 25 Feb 2013 22:40:07 +0000

Hi All,

I have a client-server application in C#.NET with MySQL as database. After some time, there will be many processes in the MySQL processlist and it stops working. Is there any way to remove the old processes on regular intervals? Can anyone suggest me other best practices to improve the performance of the system?

Thank you very much in advance
Jo

On Connector/NET dropping support for VS2005 (Poll) (no replies)

Fernando Gonzalez Sanchez — Fri, 08 Feb 2013 22:18:49 +0000

Hi,

As you may know Connector/NET 6.4.x is that last version of Connector/NET supporting Visual Studio 2005.
Currently we don't have plans to add support for Visual Studio 2005 in 6.5.x or 6.6.x (both of which support VS2008, VS2010 & VS2012).

But we want to hear feedback from the community... is there still interest in VS2005?

MySQL Connector/Net 6.6.5 MR has been released (no replies)

Fernando Gonzalez Sanchez — Wed, 06 Feb 2013 00:39:05 +0000

MySQL Connector/Net 6.6.5, a new version of the all-managed .NET driver for MySQL has been released. This is a maintenance release for 6.6.x.
This release is feature complete. It is recommended for use in production environments.
It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The 6.6.5 version of MySQL Connector/Net brings full support for MySql 5.6, including the following new features:
- Fix for Support for current_timestamp as default for datetime with ef for server 5.6 (Oracle bug #15935094).
- Added support for new connect attributes feature in server 5.6 (Oracle bug #15935112).
- Added protocol support for password expiration (Oracle bug #15935104).
- Added support for password hashing with appropriate strength for server 5.6 (Oracle bug #15935128).

As well the following bug fixes:
- Fix for bug Keyword not supported. Parameter name: AttachDbFilename (Mysql bug #66880, Oracle bug #14733472).
- Added support to MySql script file to retrieve data when using "SHOW" statements.
- Fix for Package Load Failure in Visual Studio 2005 (MySql bug #63073, Oracle bug #13491674).
- Fix for bug "Unable to connect using IPv6 connections" (MySQL bug #67253, Oracle bug #14835718).
- Added auto-generated values for Guid identity columns (MySql bug #67450, Oracle bug #15834176).
- Fix for method FirstOrDefault not supported in some LINQ to Entities queries (MySql bug #67377, Oracle bug #15856964).
- Fix internal bug "Parser cannot recognize row_count in grammar version 5.6" (id task 326).
- Fixed missing keywords not working as ids (wihout quoting) in parser: value, status, unknown& some unit tests from Arnaud feedback.
- Fix for Datetime precision doesn't work with code first or model first. (Oracle bug #15972773).
- Adding support for Geometry type. Unit Tests included. Supporting server 5.1 and further.
- Added to parser missing "alter user ... password expire".
- Fix for "Debugger error on stored procedure", which is actually a parser bug (parser was expecting decimal both precision& scale), (bug MySql #67975, Oracle bug #16079735).
- Added a more friendly message for error when trying to authenticate with old password.

The release is available to download
at http://dev.mysql.com/downloads/connector/net/6.6.html

Documentation
-------------------------------------
You can view current Connector/Net documentation
at http://dev.mysql.com/doc/refman/5.5/en/connector-net.html

You can find our team blog at http://blogs.oracle.com/MySQLOnWindows.
You can also post questions on our forums at http://forums.mysql.com/.

Enjoy and thanks for the support!

VB.NET, MySQL and Scripts (1 reply)

Nivaldo Ribeiro — Tue, 22 Jan 2013 16:31:56 +0000

hI,

I'm trying to insert a lots of rows from my program, but I can't do it one by one, because is very slow.

I tried to concatenate the inserts but doesn't work, It works if I do in the MySQL Workbench. but not sending the same script from the source code.

I'm using ADODB connection in Visual Basic 2010.

Someone know how to do that?

Thanks.

A request to send or receive data was disallowed because the socket is not connected (2 replies)

Zed Lands — Mon, 21 Jan 2013 23:04:53 +0000

Hello,

I get the folowing error when attempting from a local computer (w7 64bit), .net application to connect to a mySql database on a server.

" A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied. "

I am not having this error on any other OS, including w8 but just with w7 64bit.

Local computer firewall is off, antivirus is temporary deactivated, looks like there is nothing blocking the connection.

Some other forum discussions mention it as a threading problem. But this application does not make use of multi threading.

Any ideas would be deepply appreciated.

Regards.

C# SQL Select using where as variable (4 replies)

Ajay Baldeo — Wed, 19 Dec 2012 23:49:25 +0000

Hi All,

I'm new to working with SQL and I'm not writing this select statement properly because it's caught as an Exception.

string commandText = "select weight" +
"from inv" +
"where item_num = @inumber";

cmd = connection.CreateCommand();
cmd.CommandText = commandText;
cmd.Parameters.AddWithValue("@inumber", txt_item1.Text);
try
{
connection.Open();
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
MessageBox.Show(rdr["weight"].ToString());
}
rdr.Close();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}

This is not the end purpose of the db read but a way of testing my syntax and progress.

MySQL Connector/Net 6.5.5 Maintenance Release has been released (no replies)

Fernando Gonzalez Sanchez — Mon, 03 Dec 2012 19:42:43 +0000

MySQL Connector/Net 6.5.5, a new maintenance release of our 6.5 series, has been released. This release is GA quality and is appropriate for use in production environments. Please note that 6.6 is our latest driver series and is the recommended product for development. It is now available in source and binary form from
http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites
(note that not all mirror sites may be up to date at this point-if you
can't find this version on some mirror, please try again later or choose
another download site.)

The 6.5.5 version of MySQL Connector/Net brings the following fixes:
- Fix for ArgumentNull exception when using Take().Count() in a LINQ to Entities query (bug MySql #64749, Oracle bug #13913047).
- Fix for type varchar changed to bit when saving in Table Designer (Oracle bug #13916560).
- Fix for error when trying to change the name of an Index on the Indexes/Keys editor; along with this fix now users can change the Index type of a new Index which could not be done
in previous versions, and when changing the Index name the change is reflected on the list view at the left side of the Index/Keys editor (Oracle bug #13613801).
- Fix for stored procedure call using only its name with EF code first (MySql bug #64999, Oracle bug #14008699).
- Fix for List.Contains generates a bunch of ORs instead of more efficient IN clause in
LINQ to Entities (Oracle bug #14016344, MySql bug #64934).
- Fix for performance issue in generated EF query: .NET StartsWith/Contains/EndsWith produces MySql's locate instead of Like (MySql bug #64935, Oracle bug #14009363).
- Fix for script generated for code first contains wrong alter table and wrong declaration for byte[] (MySql bug #64216, Oracle bug #13900091).
- Fix and code contribution for bug Timed out sessions are removed without notification which allow to enable the Expired CallBack when Session Provider times out any session (bug MySql #62266 Oracle bug # 13354935)
- Fix for Exception thrown when using cascade delete in an EDM Model-First in Entity Framework (Oracle bug #14008752, MySql bug #64779).
- Fix for Session locking issue with MySqlSessionStateStore (MySql bug #63997, Oracble bug #13733054).
- Fixed deleting a user profile using Profile provider (MySQL bug #64470, Oracle bug #13790123)
- Fix for bug Cannot Create an Entity with a Key of Type String (MySQL bug #65289, Oracle bug #14540202). This fix checks if the type has a FixedLength facet set in order to create a char otherwise should create varchar, mediumtext or longtext types when using a String CLR type in Code First or Model First also tested in Database First. Unit tests added for Code First and ProviderManifest.
- Fix for bug "CacheServerProperties can cause 'Packet too large' error". The issue was due to a missing reading of Max_allowed_packet server property when CacheServerProperties is in true, since the value was read only in the first connection but the following pooled connections had a wrong value causing a Packet too large error. Including also a unit test for this scenario. All unit test passed. MySQL Bug #66578 Orabug #14593547.
- Fix for handling unnamed parameter in MySQLCommand. This fix allows the mysqlcommand to handle parameters without requiring naming (e.g. INSERT INTO Test (id,name) VALUES (?, ?) ) (MySQL Bug #66060, Oracle bug #14499549).
- Fixed inheritance on Entity Framework Code First scenarios. Discriminator column is created using its correct type as varchar(128) (MySql bug #63920 and Oracle bug #13582335).
- Fixed "Trying to customize column precision in Code First does not work" (MySql bug #65001, Oracle bug #14469048).
- Fixed bug ASP.NET Membership database fails on MySql database UTF32 (MySQL bug #65144, Oracle bug #14495292).
- Fix for MySqlCommand.LastInsertedId holding only 32 bit values (MySql bug #65452, Oracle bug #14171960) by changing
several internal declaration of lastinsertid from int to long.
- Fixed "Decimal type should have digits at right of decimal point", now default is 2, but user's changes in
EDM designer are recognized (MySql bug #65127, Oracle bug #14474342).
- Fix for NullReferenceException when saving an uninitialized row in Entity Framework (MySql bug #66066, Oracle bug #14479715).
- Fix for error when calling RoleProvider.RemoveUserFromRole(): causes an exception due to a wrong table being used (MySql bug #65805, Oracle bug #14405338).
- Fix for "Memory Leak on MySql.Data.MySqlClient.MySqlCommand", too many MemoryStream's instances created (MySql bug #65696, Oracle bug #14468204).
- Added ANTLR attribution notice (Oracle bug #14379162).
- Fixed Entity Framework + mysql connector/net in partial trust throws exceptions (MySql bug #65036, Oracle bug #14668820).
- Added support in Parser for Datetime and Time types with precision when using Server 5.6 (No bug Number).
- Small improvement on MySqlPoolManager CleanIdleConnections for better mysqlpoolmanager idlecleanuptimer at startup (MySql bug #66472 and Oracle bug #14652624).
- Fix for bug TIMESTAMP values are mistakenly represented as DateTime with Kind = Local (Mysql bug #66964, Oracle bug #14740705).
- Fix for bug Keyword not supported. Parameter name: AttachDbFilename (Mysql bug #66880, Oracle bug #14733472).
- Added support to MySql script file to retrieve data when using "SHOW" statements.
- Fix for Package Load Failure in Visual Studio 2005 (MySql bug #63073, Oracle bug #13491674).
- Fix for bug "Unable to connect using IPv6 connections" (MySQL bug #67253, Oracle bug #14835718).
- Added auto-generated values for Guid identity columns (MySql bug #67450, Oracle bug #15834176).
- Fix for method FirstOrDefault not supported in some LINQ to Entities queries (MySql bug #67377, Oracle bug #15856964).

The release is available to download at
http://dev.mysql.com/downloads/connector/net/6.5.html

Documentation
-------------------------------------
You can view current Connector/Net documentation
at http://dev.mysql.com/doc/refman/5.5/en/connector-net.html

You can find our team blog at http://blogs.oracle.com/MySQLOnWindows.
You can also post questions on our forums at http://forums.mysql.com/.

Enjoy and thanks for the support!

MySQL Connector/Net 6.4.6 Maintenance Release has been released (no replies)

Fernando Gonzalez Sanchez — Mon, 26 Nov 2012 23:27:23 +0000

MySQL Connector/Net 6.4.6, a new version of the all-managed .NET driver
for MySQL has been released. This is a maintenance release and is recommended for use in production environments.
It is appropriate for use with MySQL server versions 5.0-5.6.
This is intended to be the final release for Connector/NET 6.4.

It is now available in source and binary form from
http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites
(note that not all mirror sites may be up to date at this point-if you
can't find this version on some mirror, please try again later or choose
another download site.)

The 6.4.6 version of MySQL Connector/Net brings the following fixes:
- Fix for List.Contains generates a bunch of ORs instead of more efficient IN clause in
LINQ to Entities (Oracle bug #14016344, MySql bug #64934).
- Fix for error when trying to change the name of an Index on the Indexes/Keys editor; along with this fix now users can change the Index type of a new Index which could not be done
in previous versions, and when changing the Index name the change is reflected on the list view at the left side of the Index/Keys editor (Oracle bug #13613801).
- Fix for stored procedure call using only its name with EF code first (MySql bug #64999, Oracle bug #14008699).
- Fix for performance issue in generated EF query: .NET StartsWith/Contains/EndsWith produces MySql's locate instead of Like (MySql bug #64935, Oracle bug #14009363).
- Fix for script generated for code first contains wrong alter table and wrong declaration for byte[] (MySql bug #64216, Oracle bug #13900091).
- Fix for Exception thrown when using cascade delete in an EDM Model-First in Entity Framework (Oracle bug #14008752, MySql bug #64779).
- Fix for Session locking issue with MySqlSessionStateStore (MySql bug #63997, Oracble bug #13733054).
- Fixed deleting a user profile using Profile provider (MySQL bug #64409, Oracle bug #13790123).
- Fix for bug Cannot Create an Entity with a Key of Type String (MySQL bug #65289, Oracle bug #14540202). This fix checks if the type has a FixedLength facet set in order to create a char otherwise should create varchar, mediumtext or longtext types when using a String CLR type in Code First or Model First also tested in Database First. Unit tests added for Code First and ProviderManifest.
- Fix for bug "CacheServerProperties can cause 'Packet too large' error" (MySQL Bug #66578 Orabug #14593547).
- Fix for handling unnamed parameter in MySQLCommand. This fix allows the mysqlcommand to handle parameters without requiring naming (e.g. INSERT INTO Test (id,name) VALUES (?, ?) ) (MySQL Bug #66060, Oracle bug #14499549).
- Fixed inheritance on Entity Framework Code First scenarios. Discriminator column is created using its correct type as varchar(128) (MySql bug #63920 and Oracle bug #13582335).
- Fixed "Trying to customize column precision in Code First does not work" (MySql bug #65001, Oracle bug #14469048).
- Fixed bug ASP.NET Membership database fails on MySql database UTF32 (MySQL bug #65144, Oracle bug #14495292).
- Fix for MySqlCommand.LastInsertedId holding only 32 bit values (MySql bug #65452, Oracle bug #14171960) by changing
several internal declaration of lastinsertid from int to long.
- Fixed "Decimal type should have digits at right of decimal point", now default is 2, but user's changes in
EDM designer are recognized (MySql bug #65127, Oracle bug #14474342).
- Fix for NullReferenceException when saving an uninitialized row in Entity Framework (MySql bug #66066, Oracle bug #14479715).
- Fix for error when calling RoleProvider.RemoveUserFromRole(): causes an exception due to a wrong table being used (MySql bug #65805, Oracle bug #14405338).
- Fix for "Memory Leak on MySql.Data.MySqlClient.MySqlCommand", too many MemoryStream's instances created (MySql bug #65696, Oracle bug #14468204).
- Small improvement on MySqlPoolManager CleanIdleConnections for better mysqlpoolmanager idlecleanuptimer at startup (MySql bug #66472 and Oracle bug #14652624).
- Fix for bug TIMESTAMP values are mistakenly represented as DateTime with Kind = Local (Mysql bug #66964, Oracle bug #14740705).
- Fix for bug Keyword not supported. Parameter name: AttachDbFilename (Mysql bug #66880, Oracle bug #14733472).
- Added support to MySql script file to retrieve data when using "SHOW" statements.
- Fix for Package Load Failure in Visual Studio 2005 (MySql bug #63073, Oracle bug #13491674).
- Fix for bug "Unable to connect using IPv6 connections" (MySQL bug #67253, Oracle bug #14835718).
- Added auto-generated values for Guid identity columns (MySql bug #67450, Oracle bug #15834176).
- Fix for method FirstOrDefault not supported in some LINQ to Entities queries (MySql bug #67377, Oracle bug #15856964).

The release is available to download at http://dev.mysql.com/downloads/connector/net/6.4.html

Documentation
-------------------------------------
You can view current Connector/Net documentation
at http://dev.mysql.com/doc/refman/5.5/en/connector-net.html

You can find our team blog at http://blogs.oracle.com/MySQLOnWindows.
You can also post questions on our forums at http://forums.mysql.com/.

Enjoy and thanks for the support!

MySQL Connector/Net With SSL (1 reply)

Kristofer Brigelius — Mon, 26 Nov 2012 18:02:48 +0000

Hello

i use the MySQL Connector/Net compact framework
and have for sometime now but today a reconfigured my mysql server
and started using SSL.

On the Pc application everything works fine sens i use the Mysql.Data.dll
But on the phone i use Mysql.Data.CF.dll and that one doesnt have support for SSL.

is there an other way to get an compact solution for the phone and use ssl?

MySQL Connector/Net 6.6 GA has been released (no replies)

Fernando Gonzalez Sanchez — Fri, 09 Nov 2012 22:45:26 +0000

MySQL Connector/Net 6.6, a new version of the all-managed .NET driver
for MySQL has been released. This is the GA intended to introduce users to the new features in the release. This release is feature complete. It is recommended for use in production environments.
It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from
http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites
(note that not all mirror sites may be up to date at this point-if you
can't find this version on some mirror, please try again later or choose
another download site.)

The 6.6 version of MySQL Connector/Net brings the following new features:

* Stored routine debugging
* Entity Framework 4.3 Code First support
* Pluggable authentication (now third parties can plug new
authentications mechanisms into the driver).
* Full Visual Studio 2012 support: everything from Server Explorer to
Intellisense& the Stored Routine debugger.

The release is available to download athttp://dev.mysql.com/downloads/connector/net/6.6.html

Documentation
-------------------------------------
You can view current Connector/Net documentation
at http://dev.mysql.com/doc/refman/5.5/en/connector-net.html
For specific topics:
Stored Routine Debugger:http://dev.mysql.com/doc/refman/5.5/en/connector-net-visual-studio-debugger.html
Authentication plugin:http://dev.mysql.com/doc/refman/5.5/en/connector-net-programming-authentication-user-plugin.html

You can find our team blog at http://blogs.oracle.com/MySQLOnWindows.
You can also post questions on our forums at http://forums.mysql.com/.

Enjoy and thanks for the support!

Creating Functions and Procedures from the program (8 replies)

Hussain AlObaidan — Tue, 27 Nov 2012 12:47:09 +0000

Dear all,

Thank you very much for this useful forum. I have problem in my program.
Actually, I am programming using visual studio with MySQL. I have included the create database and tables in the code of the program. The problem is that I cannot include the code to create the functions and procedures in the program. I have even tried to use the delimiter but unfortunately it does not work too. Can you please help?

Blog entries on how to use Entity Framework 4.3 (no replies)

Fernando Gonzalez Sanchez — Fri, 26 Oct 2012 15:18:46 +0000

Hi,

These couple of blog entries were made by Gaby, the developer in charge of adding EF 4.3 support in Connector/NET:

Posts in our blog:

Entity Framework 4.3.1 Code based Migrations and Connector/Net 6.6
https://blogs.oracle.com/MySqlOnWindows/entry/entity_framework_4_3_1

Upgrading to Code Based Migrations EF 4.3.1 with Connector/Net 6.6
https://blogs.oracle.com/MySqlOnWindows/entry/upgrading_to_code_first_migrations

SQL injection prevention in vb.net (3 replies)

Sean Kelly — Fri, 26 Oct 2012 20:51:03 +0000

I am trying to prevent sql injection in my vb.net application and was wondering what the best approach for this would be. I was looking at making my statement parameterized but could not find a function for it in the MySql.Data.MySqlClient import. Is there a way to do this with the import or should I go about trying a different method?

Thank you!

Sean

trying to use MySql.Data.MySqlClient on aspx page (2 replies)

Gibran Shah — Fri, 26 Oct 2012 04:17:28 +0000

I've got a MySQL database running on my laptop and I want to connect to it via some C# scripting.

I have an aspx page that has this at the top:

<%@ Page Language="C#" %>

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="MySql.Data.MySqlClient" %>

But I get an error when I try to open this page:

Compiler Error Message: CS0246: The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?)

Source Error:

 

Line 2:  
Line 3:  <%@ Import Namespace="System.Data" %>
Line 4:  <%@ Import Namespace="MySql.Data.MySqlClient" %>
Line 5:  
Line 6:

I'm assuming that if I have MySQL running on my machine, I have the MySql.Data.MySqlClient library. If so, I can I get my aspx page to access it. If not, how do I get it (and then use it)?

Convert sql statement to mysql statement (1 reply)

Divan Du Piesanie — Tue, 23 Oct 2012 15:45:00 +0000

select * from dbo.T_Recipients where Company_Name = 'ACSA' and User_Name = 'Arend' and Full_Name like '%A%'

MySQL Connector/Net 6.6.4 RC1 has been released (no replies)

Fernando Gonzalez Sanchez — Fri, 19 Oct 2012 16:33:43 +0000

MySQL Connector/Net 6.6.4, a new version of the all-managed .NET driver
for MySQL has been released. This is the Release Candidate
intended to introduce users to the new features in the release. This
release is feature complete it should be stable enough for users to
understand the new features and how we expect them to work. As is the
case with all non-GA releases, it should not be used in any production
environment. It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from
http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites
(note that not all mirror sites may be up to date at this point-if you
can't find this version on some mirror, please try again later or choose
another download site.)

The 6.6 version of MySQL Connector/Net brings the following new features:

* Stored routine debugging
* Entity Framework 4.3 Code First support
* Pluggable authentication (now third parties can plug new
authentications mechanisms into the driver).
* Full Visual Studio 2012 support: everything from Server Explorer to
Intellisense& the Stored Routine debugger.

The following specific fixes are addressed in this version:
- Fixed Entity Framework + mysql connector/net in partial trust throws exceptions (MySql bug #65036, Oracle bug #14668820).
- Added support in Parser for Datetime and Time types with precision when using Server 5.6 (No bug Number).
- Fix for bug TIMESTAMP values are mistakenly represented as DateTime with Kind = Local (Mysql bug #66964, Oracle bug #14740705).

The release is available to download athttp://dev.mysql.com/downloads/connector/net/6.6.html

Documentation
-------------------------------------
You can view current Connector/Net documentation
at http://dev.mysql.com/doc/refman/5.5/en/connector-net.html
For specific topics:
Stored Routine Debugger:http://dev.mysql.com/doc/refman/5.5/en/connector-net-visual-studio-debugger.html
Authentication plugin:http://dev.mysql.com/doc/refman/5.5/en/connector-net-programming-authentication-user-plugin.html

You can find our team blog at http://blogs.oracle.com/MySQLOnWindows.
You can also post questions on our forums at http://forums.mysql.com/.

Enjoy and thanks for the support!

Create bool/tinyint(1) in Select of Procedure for DataViewCheckboxColumn in C#!? (1 reply)

Christian Leder — Tue, 23 Oct 2012 23:29:59 +0000

Hello

I need to generated a column as bool / tinyint(1) in a select,
so the column will be displayed in my datagrid as checkbox.

I manage not to generate such a data type.
Is there a solution?

As an example:

CREATE PROCEDURE `myTest`()
BEGIN

Select
PK, FK .....
(case when PK_xyz is null then 1 else 0 end) as IsNew, -- Here bool / tinyint(1) needed
from TableXy
left join xyz ....
;
END

I have try different variants with Cast, Convert, bit ... but not brought the desired success.

Is there a solution to the problem?

Thank you an greetings
Christian

MySQL Connector/Net 6.6.3 Beta 2 has been released (1 reply)

Fernando Gonzalez Sanchez — Fri, 28 Sep 2012 16:11:15 +0000

MySQL Connector/Net 6.6.3, a new version of the all-managed .NET driver for MySQL has been released. This is the second of two beta releases intended to introduce users to the new features in the release.

This release is feature complete it should be stable enough for users to understand the new features and how we expect them to work. As is the case with all non-GA releases, it should not be used in any production
environment. It is appropriate for use with MySQL server versions 5.0-5.6.

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you
can't find this version on some mirror, please try again later or choose another download site.)

The 6.6 version of MySQL Connector/Net brings the following new features:

* Stored routine debugging
* Entity Framework 4.3 Code First support
* Pluggable authentication (now third parties can plug new authentications mechanisms into the driver).
* Full Visual Studio 2012 support: everything from Server Explorer to Intellisense& the Stored Routine debugger.

Stored Procedure Debugging
-------------------------------------------
We are very excited to introduce stored procedure debugging into our Visual Studio integration. It works in a very intuitive manner by simply clicking 'Debug Routine' from Server Explorer. You can debug
stored routines, functions& triggers. These release contains fixes specific of the debugger as well as other fixes specific of other areas of Connector/NET:

* Added feature to define initial values for InOut stored procedure arguments.
* Debugger: Fixed Visual Studio locked connection after debugging a routine.
* Fix for bug Cannot Create an Entity with a Key of Type String (MySQL bug #65289, Oracle bug #14540202).
* Fix for bug "CacheServerProperties can cause 'Packet too large' error". MySQL Bug #66578 Orabug #14593547.
* Fix for handling unnamed parameter in MySQLCommand. This fix allows the mysqlcommand to handle parameters without requiring naming (e.g. INSERT INTO Test (id,name) VALUES (?, ?) ) (MySQL Bug #66060, Oracle bug #14499549).
* Fixed end of line issue when debugging a routine.
* Added validation to avoid overwriting a routine backup file when it hasn't changed.
* Fixed inheritance on Entity Framework Code First scenarios. (MySql bug #63920 and Oracle bug #13582335).
* Fixed "Trying to customize column precision in Code First does not work" (MySql bug #65001, Oracle bug #14469048).
* Fixed bug ASP.NET Membership database fails on MySql database UTF32 (MySQL bug #65144, Oracle bug #14495292).
* Fix for MySqlCommand.LastInsertedId holding only 32 bit values (MySql bug #65452, Oracle bug #14171960).
* Fixed "Decimal type should have digits at right of decimal point", now default is 2, and user's changes in
EDM designer are recognized (MySql bug #65127, Oracle bug #14474342).
* Fix for NullReferenceException when saving an uninitialized row in Entity Framework (MySql bug #66066, Oracle bug #14479715).
* Fix for error when calling RoleProvider.RemoveUserFromRole(): causes an exception due to a wrong table being used (MySql bug #65805, Oracle bug #14405338).
* Fix for "Memory Leak on MySql.Data.MySqlClient.MySqlCommand", too many MemoryStream's instances created (MySql bug #65696, Oracle bug #14468204).
* Added ANTLR attribution notice (Oracle bug #14379162).
* Fix for debugger failing when having a routine with an if-elseif-else.
* Also the programming interface for authentication plugins has been redefined.

Some limitations remains, due to the current debugger architecture:

* Some MySQL functions cannot be debugged currently (get_lock, release_lock, begin, commit, rollback, set transaction level)..
* Only one debug session may be active on a given server.

The Debugger is feature complete at this point. We look forward to your
feedback.

Documentation
-------------------------------------
You can view current Connector/Net documentation
at http://dev.mysql.com/doc/refman/5.5/en/connector-net.html

You can find our team blog at http://blogs.oracle.com/MySQLOnWindows.
You can also post questions on our forums at http://forums.mysql.com/.

Enjoy and thanks for the support!

Fatal error encountered attempting to read the resultset. (2 replies)

David Green — Mon, 01 Oct 2012 17:11:01 +0000

I am trying to import a CSV file into a MySQL database. I have C# code written to do the import. Thus far I have tried changing the statement to use either field or column, I have tried using \r, \n and a combination to terminate the line. I also changed the Time column from Date/Time to VARCHAR(45) and I verified that there is a table column for each column I am trying to import, unless I missed one.

This is the SQL Statement:

LOAD DATA LOCAL INFILE 'D:\\SANCentral\\Customer Files\\ibm\\70738\\0918\\Switch
Port.csv' INTO TABLE By_Switch FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\\r\\n' IGNORE 1 LINES

Trying the above from the MySQL workbench doesn't work either but it doesn't say why. I am hoping I don't need to add the columns option to the statemnt, I have a lot of columns.

I am trying to execute it with this code in C# where commandstring is a string set to the above and sqlconnect is the open connection.

MySqlCommand cmd = new MySqlCommand(commandstring,sqlconnect);
cmd.ExecuteNonQuery();

this C# code worked, or at least it didn't throw an exception. The table right now is empty
commandstring = @"SELECT `CRC Error Rate` From `by_switch`";
MySqlCommand cmd = new MySqlCommand(commandstring,sqlconnect);
MySqlDataReader myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

Here is a sample of the input, sorry about the formatting, this is all one line.
BRCOL-CORE-A,0,2000000533586F00,1,0,9/17/12 8:45 PM,304,6527.82,24454.09,30981.9013,11.34,46.27,57.602,10.27,29.19,1.778,1.937,1.904,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.4,5.71,3.55,0.0,0.0,0.0,0.0
B

This is the SQL that created the table:
CREATE TABLE IF NOT EXISTS `PerformanceMonitors`.`By_Switch` (
`Switch` VARCHAR(45) NOT NULL ,
`Port` VARCHAR(45) NULL ,
`WWPN` VARCHAR(45) NULL ,
`Slot` VARCHAR(45) NULL ,
`Index` VARCHAR(45) NULL ,
`Time` VARCHAR(45) NULL ,
`Interval` DOUBLE NULL ,
`Port` DOUBLE NULL ,
`Send Packet Rate` DOUBLE NULL ,
`Port Receive Packet Rate` DOUBLE NULL ,
`Total Port Packet Rate` DOUBLE NULL ,
`Port Send Data Rate` DOUBLE NULL ,
`Port Receive Data Rate` DOUBLE NULL ,
`Total Port Data Rate` DOUBLE NULL ,
`Port Peak Send Data Rate` DOUBLE NULL ,
`Port Peak Receive Data Rate` DOUBLE NULL ,
`Port Send Packet Size` DOUBLE NULL ,
`Port Receive Packet Size` DOUBLE NULL ,
`Overall Port Packet Size` DOUBLE NULL ,
`Error Frame Rate` DOUBLE NULL ,
`Dumped Frame Rate` DOUBLE NULL ,
`Link Failure Rate` DOUBLE NULL ,
`Loss of Sync Rate` DOUBLE NULL ,
`Loss of Signal Rate` DOUBLE NULL ,
`CRC Error Rate` DOUBLE NULL ,
`Short Frame Rate` DOUBLE NULL ,
`Long Frame Rate` DOUBLE NULL,
`Encoding Disparity Error Rate` DOUBLE NULL,
`Discarded Class3 Frame Rate` DOUBLE NULL,
`F-BSY Frame Rate` DOUBLE NULL,
`F-RJT Frame Rate` DOUBLE NULL,
`Port Send Bandwidth Percentage` DOUBLE NULL,
`Port Receive Bandwidth Percentage` DOUBLE NULL,
`Overall Port Bandwidth Percentage` DOUBLE NULL,
`Primitive Sequence Protocol Error Rate` DOUBLE NULL,
`Invalid Transmission Word Rate` DOUBLE NULL,
`Link Reset Transmitted Rate` DOUBLE NULL,
`Link Reset Received Rate` DOUBLE NULL,
PRIMARY KEY (`Switch`, `Time`) )

SQL Server statement to MySQL statement (4 replies)

jed cadle — Thu, 27 Sep 2012 19:14:31 +0000

I am needing to translate a SQL Server statement to MySQL and I was hoping to find an easy opensource translator that I can paste in the SQL Server statement and it translate it to what the MySQL statement should be.

Synchronization (3 replies)

John Paul — Mon, 24 Sep 2012 15:30:54 +0000

I have an application which uses a hosted MySQL DB.
But in case internet is not available the application uses a local DB
but when it connects back it should sync with the hosted DB..How do I do
this??
And my application is C# based