Skip to main content
82 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
2 answers
266 views

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-...
Corey's user avatar
  • 508
0 votes
2 answers
320 views

I'm created a migration to add a few tables and update one table (add one column). The database is MySQL 8.0.31 and the EF provider is Oracle's MySql.EntityFrameworkCore The migration was completed ...
Think_Twice's user avatar
  • 343
1 vote
0 answers
751 views

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 (...
kosnkov's user avatar
  • 5,987
1 vote
1 answer
745 views

I am using the MySql.Data package in a .NET Framework 4.7.2 application. When updating MySql.Data to a version newer than 8.0.27, the database connection fails in a previously working project with no ...
Alfie's user avatar
  • 2,360
1 vote
0 answers
413 views

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....
monolith_code's user avatar
  • 11
0 votes
1 answer
743 views

Please I was busy for the past 4 days trying to fix the issues resulting from the below error. Please how do I go about fixing this error below? *Severity Code Description Project File Line ...
HUMBLE HERO's user avatar
  • 1
3 votes
1 answer
2k views

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 ...
Lukman Hakim Imran's user avatar
  • 51
0 votes
0 answers
112 views

I'm trying to retrieve accounting periods from a MySql database using entity framework but keep running into an InvalidCastException exception. This is the linq statement below: var periodList = (from ...
Tim's user avatar
  • 47
0 votes
1 answer
122 views

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 ...
Christian Cascone's user avatar
  • 503
0 votes
2 answers
320 views

I am attempting to index my movie collection and in doing so have run across an issue where at least one title is skipped in the import phase due to special characters. The code skips over "Æon ...
graih's user avatar
  • 30
1 vote
1 answer
92 views

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 ...
AnKing's user avatar
  • 2,224
0 votes
0 answers
1k views

I am getting the error(Error CS0246:The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?). So I tried installing MySql.Data NuGet Package ...
Karmugil's user avatar
  • 31
1 vote
1 answer
4k views

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 ...
Dutts's user avatar
  • 6,261
0 votes
0 answers
1k views

So I've been using the MySql.Data from NuGet for a long time for connecting with my MariaDB databases in a lot of different .NET projects. It happens that now I'm starting a new .NET5 project and to ...
RojoBarclay's user avatar
  • 1
0 votes
2 answers
234 views

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 ...
Harry's user avatar
  • 1
1 vote
1 answer
2k views

Searched SO but can't find a solution that works. In Visual I've got a main project. It uses another project (ProjectA) that compiles to a DLL. That project uses Servicestack ORMLite 4.5.14. I've also ...
Postie's user avatar
  • 534
0 votes
2 answers
1k views

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 ...
David Turley's user avatar
  • 96
4 votes
1 answer
4k views

I have a column session_expires_at in my person database table. This column is of type DATETIME and is nullable. In my code my User object represents this column with public DateTime? SessionExpiresAt ...
Question3r's user avatar
  • 4,082
1 vote
1 answer
688 views

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 ...
ezio's user avatar
  • 569
0 votes
2 answers
481 views

So I'm using the MySql.Data package for my .NET Core project and store password hashes and salts (of type byte[]) as varbinary() to the database. When selecting the password hash and salt from a user ...
Question3r's user avatar
  • 4,082
-1 votes
1 answer
306 views

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 &...
Question3r's user avatar
  • 4,082
0 votes
0 answers
234 views

Here is the code that connects to MySql and attemps to query data, and these are the errors i'm getting: An unhandled exception occurred while processing the request. MySqlException: Timeout ...
Youssef's user avatar
  • 33
0 votes
0 answers
117 views

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 ...
Venzonite's user avatar
  • 1
0 votes
1 answer
124 views

This the code i have written, at one point it displayed System.Data.Dataset return in Access level but it wasn't what i was looking for. Username is a string, Password is also a string and Access ...
Arc_G's user avatar
  • 5
1 vote
0 answers
360 views

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 `...
Adam Kamor's user avatar
  • 133
-1 votes
1 answer
254 views

The reccomended way to use MySql.Data is to NOT use a MySqlConnection object; as explained in the documentation. This allows for the MySQl.Data API code to handle connection pooling correctly. See: ...
Richard210363's user avatar
  • 8,426
1 vote
1 answer
726 views

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 ...
John Rousseau's user avatar
  • 101
5 votes
6 answers
8k views

I have just installed the latest version of MySQL.Data.EntityFramework Version 8.0.19. The first time I run the code I got the following error: The latest nuget package (MySql.Data 8.0.19) ...
Hooman Bahreini's user avatar
  • 15.7k
0 votes
1 answer
155 views

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 ...
Kino Filme's user avatar
  • 5
0 votes
3 answers
120 views

I'm trying to parse data from MariaDB MySQL database, but I have a problem when I try to return CODE. The public static string given below works perfectly, I just want to use parsed data in another ...
Shako's user avatar
  • 31
0 votes
1 answer
48 views

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 ...
unicursal7's user avatar
  • 19
0 votes
1 answer
120 views

I constructed a MySqlParameter with MySqlParameter tmp1 = new MySqlParameter("?tmp1", 0.0); and when executing the corresponding insert query received the error message that the respective column ...
Bernhard Hiller's user avatar
  • 2,467
1 vote
2 answers
856 views

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) ...
stigzler's user avatar
  • 1,035
0 votes
1 answer
354 views

I'm trying to check if the user's HWID already exists in my 'users' table in mysql database when trying to login. And if it does exist, make another check. However I'm getting error called "You have ...
Motify's user avatar
  • 51
1 vote
1 answer
4k views

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 ...
vishgarg's user avatar
  • 463
1 vote
1 answer
18k views

I'm creating MySql database table from C# desktop application on remote server. I would like to make long records for columns content. I guess TEXT type must be suitable for this, but I'm not sure, ...
lf80's user avatar
  • 493
2 votes
0 answers
126 views

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%) ...
Sébastien Ollivier's user avatar
  • 578
3 votes
2 answers
3k views

I'm trying to use mysql with Microsoft.EntityFrameworkCore 2.1-rc-final and MySql.Data.EntityFrameworkCore 8.0.11 as provider. But when I'm trying to execute the mugrations command i get this ...
Yosel's user avatar
  • 41
0 votes
0 answers
60 views

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 ...
Music Addicted's user avatar
  • 1
0 votes
0 answers
1k views

I have created a WEB-API. It was working well on my local and on my server. But now when I try to send the request it is giving me below error. { "Message": "An error has occurred.", "...
Moeez's user avatar
  • 486
-1 votes
1 answer
726 views

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: ...
Alif Noushad's user avatar
  • 365
0 votes
0 answers
115 views

While running through 3rd party NuGet Package called DbUp INSERT INTO `portalquery` VALUES (31,'update portal.Config_PropertyValues set value = \''<?xml version=\"1.0\" encoding=\"utf-8\" ?>\...
Adeel's user avatar
  • 43
-1 votes
1 answer
49 views

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) ...
Roy's user avatar
  • 33
102 votes
2 answers
90k views

I use MySql.Data 8.08 and .NET Core to connect to MySql 5.7.18 but following exception is being thrown: MySql.Data.MySqlClient.MySqlException:“The host localhost does not support SSL connections.” ...
Sea's user avatar
  • 1,033
0 votes
0 answers
296 views

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, ...
Parth Savadiya's user avatar
  • 1,211
0 votes
2 answers
3k views

So I have previously developed a payroll system using c# way back 2010, and I decided to use it again as a reference, I had its ClickOne Application Deployment Manifest, but when I tried to run it an ...
user7254740's user avatar
  • 111
0 votes
1 answer
886 views

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 ...
wishfulcoder's user avatar
  • 11
0 votes
2 answers
3k views

I've installed the MySQL for Visual Studio and the .NET Connector (6.8.3.0). I previous had the 6.7.4.0 installed. Why is it still looking for this DLL? I get the error message form event viewer: ...
Hao Zheng's user avatar
  • 3
1 vote
1 answer
3k views

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 ...
Yousif Touma's user avatar
  • 90
2 votes
1 answer
499 views

I am trying to connect to a MariaDB server using the MySql.Data.dll. I think it should work since MariaDB is a drop-in replacement for MySQL. Found a helpful answer here on StackOverflow, however ...
Mihai Constantin's user avatar
  • 3,007

1
2