Re: Mysql Connector LEFT JOIN Bug
Posted by: René Kühne
Date: May 30, 2020 01:13PM

I double checked: The Nuget Package is Tagged as

"MySql, .NET, Connector, Connector/Net, netcore, .Net, Core, Connector/Net, coreclr, C/NET, C/Net"

Here are some code fragments:

Private Function execute(ByVal pStatement As String, Optional ByVal pValues As DBParameter = Nothing) As MySqlCommand
    Dim myCommand As New MySqlCommand(pStatement, Open().MYSQL_CONNECTION) With {.CommandTimeout = COMMANDTIMEOUT}
    If Not pValues Is Nothing Then
        For Each myObject As KeyValuePair(Of String, Object) In pValues
            myCommand.Parameters.Add(New MySqlParameter(myObject.Key, myObject.Value))
    End If
    Return myCommand
End Function

Public Overrides Function executeReader(ByVal pStatement As String, ByVal pTable As DataTable, Optional ByVal pValues As DBParameter = Nothing, Optional ByVal pExpected As Integer = -1) As DataTable

    Dim myCMD = execute(pStatement, pValues)
        mReader = myCMD.ExecuteReader(CommandBehavior.Default)
        If pTable.DataSet Is Nothing Then
            Dim mySet As New DataSet
            mySet.EnforceConstraints = False
        End If

        pTable.Load(mReader, LoadOption.PreserveChanges)

    Catch myEx As Exception
        If Not mReader Is Nothing Then
            mReader = Nothing
        End If
    End Try
    If pExpected > -1 AndAlso pExpected <> pTable.Rows.Count Then
        Throw New InvalidCountException("Unexpcted Count ", pTable.Rows.Count, New Exception(pStatement))
    End If
    Return pTable
End Function

Connection string:
mConnectionString =
"Server=" & pServer & ";" &
"Uid=" & pUser & ";" &
"Password=" & pPass & ";" &
"Pooling=true;allowzerodatetime=true;CharacterSet=utf8;" &
"UseCompression=true;ConnectionTimeout=60;" &

Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.