82 questions
2
votes
2
answers
234
views
Using MySQL.Data with C# while not making a MySql Connection for transactions
This question is similar to this one: Using MySql.Data with C# while not making a MySqlConnection
Basically, I can see in the documentation: https://dev.mysql.com/doc/connector-net/en/connector-net-...
- 508
1
vote
0
answers
743
views
Dapper async hangs
I updated Mysql.Data to use new mysql 8.* and since this update queryAsync hangs forever.
Here is my method:
public async Task<bool> IsLiveResultsEnabled(Guid clientId)
{
using (...
- 5,987
1
vote
0
answers
412
views
C# Error while trying to connect to MySql using MySql.Data
ISSUE
While trying to connect to maria db using mysql.data i get this error:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at System.Diagnostics.TraceInternal....
3
votes
1
answer
2k
views
MySql.Data.MySqlClient.MySqlProviderServices.GetDbProviderManifestToken to access method MySql.Data.MySqlClient.MySqlConnection.get_Settings() failed
To Upgrade
Database: MySql Version 5.5.62 to 8.0.28
.NET Framework: Version 4.5 to 4.8
Entity Framework: Version 5.0.0 to 6.4.4
I followed the steps:
Uninstall and remove all existing mySQL dll ...
0
votes
1
answer
119
views
How to identify transient errors in NET Standard 2.1 with MySql.Data.MySqlClient.MySqlException?
I'm writing my app with NET Standard 2.1 and MySql (NuGet pack MySql.Data).
The MySqlException doesn't have the property IsTransient so I can't recognize if the exception is temporary. How can I ...
1
vote
1
answer
92
views
Convert MySQL non-unicode characters in C#
I have a PHP application that currently stores data in MySQL tables in non-conventional format(I assume this is because it is using a non-unicode mysql connection).
Example, this is one of the ...
- 2,224
1
vote
1
answer
4k
views
The handshake failed due to an unexpected packet format when updating MySql.Data 8.0.26 [duplicate]
I have a dependency on MySql.Data in my C# netcoreapp2.1 test project which I use to query for test data from a database, this works fine with v8.0.25, but if I upgrade to v.8.0.26 I get the following ...
- 6,261
0
votes
2
answers
227
views
Installing MySQL.Data on Azure App Service deployment slot
What's the best way to install MySql.Data on azure app service?
We have a PHP application that requires some powershell scripts to be run in the background, these scripts must connect to the MySQL ...
- 1
0
votes
2
answers
1k
views
MySQL Parameters.AddWithValue not working C#
I have been trying my hand at writing the connecting code to connect with the database. It's been going pretty well, but I ran into a strange problem that I cant seem to fix.
When I try to add a ...
- 96
1
vote
1
answer
681
views
EF core can't create Table, error in sql syntax
im new to Entity framework and i dont understand why it is giving me an error in sql syntax , i thought the whole purpose of using EFCore is to handle the sql syntax and abstract all the sql queries ...
- 569
-1
votes
1
answer
304
views
Database reader closes before reading the data
I want to query my MySQL database by using the MySQL.Data connector. I know that I could use the Entity Framework or other handy tools similiar to ORMs e.g. Dapper. But I would like to try out the &...
- 4,082
0
votes
0
answers
117
views
C# WPF App - Exception on closing application
I have a problem with exception appearing while closing my WPF application.
HResult=0x80131515
Message=The Read method cannot be called when another read operation is pending.
Source=System
...
1
vote
0
answers
354
views
MySQL (ADO.NET) Giving 'No Database Selected' Error when database is indeed selected
Using ADO.NET with the MySql Connector (MySql.Data) driver, I open a new, non-pooled query (no initial catalog/database is specified in connection string) and issue the following query:
ALTER TABLE `...
- 133
1
vote
1
answer
726
views
MySql.Data can't connect to AWS Aurora
I have a really weird connection problem between C# .net core and AWS Aurora Serverless (MySql). I have a really simple web API that I'm using for testing. One of my endpoints is really simple to ...
- 101
0
votes
1
answer
155
views
MySql.Data.MySqlClient shows confusing error
I'm using VS2019 and today I opened my project to continue working but a strange error occured that I really don't understand. The MySql.Data.MySqlClient namespace shows this:
and every mysql commands ...
0
votes
1
answer
48
views
How do i get all columns / rows from my Database [VB.Net/MariaDB]
I am trying to get all results with the MySQL.Data Nuget because I am using MariaDB. But my Method just provides the first entry in my DB and does nothing more.
Public Function getAllFields(ByVal sql ...
- 19
1
vote
2
answers
845
views
VS 2017 MySql.Data manifest does not match the assembly reference
I've had some problems following migration of a software project to a new machine. I'm trying to get VS2017, MySql.data and my MySQL database working together. I get a long error message (below) ...
- 1,035
1
vote
1
answer
4k
views
How to use Hangfire.MysqlStorage with .net core with MySql.Data?
I'm trying to use Hangfire with MysqlStorage in Asp.Net core project. With Hangfire.MysqlStorage 2.0 package, MysqlConnector is installed. I'm facing lot of problems with MysqlConnector and it is not ...
- 463
2
votes
0
answers
126
views
High CPU Usage for MySql.Data.MySqlClient.CharSetMap GetEncoding
I have an API (ASPNET Core) which calls a Database (MySQL). I use NHibernate and the MySqlData connector.
When a lot of requests are sent to my API, I come accross some CPU problem (near to 100%) ...
0
votes
0
answers
60
views
MySQL.data login error
Ok, so i want to make a loader, that injects a dll into a process based on hwid checked from a MySQL database, by modifing a sourcecode on the internet, however even though i type correct login ...
-1
votes
1
answer
722
views
Unable to connect to any of the specified MySQL hosts in WPF
I can't figure out what's wrong with the connection string. I tried all possible variations of the string. It's done in a WPF framework in vs 2015. I just installed SQL server 2016 newly.
The code is:
...
- 365
-1
votes
1
answer
43
views
SQL C#: Nothing gets returned from Result.Read()
When I use this code, I get null returned. But when I am trying to use the query by sql I get normal result.
Here is my code:
public byte[] GetInfo(UnturnedPlayer player , string vehiclename)
...
- 33
0
votes
0
answers
296
views
Source: MySql.Data.Entity.EF6 Index was outside the bounds of the array
Source: MySql.Data.Entity.EF6 stored procedure generate error Index was outside the bounds of the array.
List<PayRollAllocationList> payroll = db.SP_EmployeePayRoll(orgCode, Medicalallowcode, ...
- 1,211
0
votes
1
answer
878
views
Visual Studio 2015 not installing Mysql.data in NuGet
UWP App not being able to work with MySql
I have made an app in UWP and instead of using SQLLite which seems to be the norm for Visual Studio 2015 I want to use MySql. I have already connected my ...
- 11
1
vote
1
answer
3k
views
Ignore assembly .dll in same folder as executable
I have a .NET application that crashes if I have the MySql.Data.dll assembly in the same folder as the executable but works fine if I move it. A different executable in the same folder is dependent on ...
- 90