Stack Overflow
Stack Overflow

Questions tagged [connector-net]

MySql Connector/NET is the open source ADO.NET provider supported by Oracle for MySql databases.

37 questions
2
votes
2 answers

MySql 5 & LINQ to Entities EF 4 causing "Object must implement IConvertible" when querying across network

When using the same MVC 3 & C# code along with copies of the same MySql 5.5 database on 2 different MySql installations. One works perfectly while the other one fails with an "Object must implement IConvertible" error. When I run the query against…
Atlas361
  • 21
  • 3
2
votes
2 answers

Incorrect Guid order

Ok I have a GUID f5cc4100-f1b4-4af6-9e9e-224b0eb74166 and I am inserting it to MySQL database using the ADO .NET Connector. I can do it in two ways: 1) Feed byte array to .NET Connector string query = "insert into test (pk_id) values…
nawfal
  • 62,042
  • 48
  • 302
  • 339
1
vote
2 answers

connecting to mysql in vb.net

Im trying to connect MySql from VB.NET in visual basic 2010. I wanted to query the db just to get one return is response to my proID once I click the button. it successfully show connection has been establish but I can't seems to run any sql query…
Imperial Realcs
  • 37
  • 6
1
vote
1 answer

Executing MySqlCommand (StoredProcedure) with output parameter

I can't figure out how to use MySQLCommand provided by Connector/NET 3.6.5. Basically here is the code I'm using and exception I get when I run ExecuteNonQuery. What am I doing wrong here? I have no ideas left :( var connection =…
Sergej Andrejev
  • 8,543
  • 11
  • 65
  • 107
1
vote
1 answer

Why does DELETE statement fail silently with MySQL Connector/net when it works in MySql Workbench and PHP/PDO?

I have a MariaDB database containing a table with information about mobile devices (both android and ios) running on a CentOS 7 server with Mono JIT compiler version 5.4.0.201 and MySql Connector/NET (latest version 8.0.13). All is working great,…
Anders Emil
  • 365
  • 1
  • 11
1
vote
1 answer

Get output parameter for ID (primary key)

I have a simple database which has an ID column as primary key, INT, AUTO_INCREMENT and a name column. I'm trying to insert values into the database and get the ID back. This is part of my code: using (var connection = new MySqlConnection(...)) { …
Thomas Weller
  • 43,638
  • 16
  • 101
  • 185
1
vote
1 answer

Parameter '?' must be defined

I've made a simple ASP.NET app for managing a MySQL database. I've been using Visual Studio 2013 and their auto-generated elements such as DetailsView, GridView etc. The app works fine locally (including queries to the MySQL server where my site's…
jhm
  • 3,699
  • 3
  • 29
  • 44
1
vote
2 answers

referencing MySQL with Connector/NET and Visual Studio 2013 Express

I am rebuilding a Visual Studio 2008 project in Visual Studio 2013 Express. I installed the latest community version of MySQL for Windows (5.6.14) and even after adding the reference to the newest MySql.Data assembly (6.7.4 version 4.0) the…
H2ONaCl
  • 8,715
  • 11
  • 56
  • 100
0
votes
1 answer

Problems using MySQL with Entity Framework

I have a problem inserting a row using Entity Framework with the MySQL Connector/NET 6.4.4. When I try to save the changes after adding 1 row I get a System.NullReferenceException with the following stack-trace: at…
Yrlec
  • 3,223
  • 6
  • 35
  • 72
0
votes
1 answer

MySQL 8: Create Collections via DDL

I’d like to be able to create MySQL Document Store Collections via simple SQL DDL statements rather than using the X-Protocol clients. Is there any way to do so? Edit: I’ll try and clarify the question. Collections are tables using JSON datatypes…
Raine
  • 809
  • 1
  • 14
  • 25
0
votes
1 answer

Exception when trying to use Mysql.Data.Entity

I'm trying to get a test project running using MySQL and EF6 using Visual Studio 2019 Community Preview for Mac. I am using the Web Application (Model-View-Controller) / .NET Core -> App template as a starting point as well as the MyWind database.…
Don 01001100
  • 1,450
  • 18
  • 42
0
votes
0 answers

Is a sequence necessary in MySQL connection-string?

I am using connector/net but sometimes a connection error is generated on the server due to connection-string. Is there any sequence to follow? connection_string conn = new connection-string("User…
user9460880
0
votes
0 answers

MySQLConnection has no implementation

I'm new to C# and connecting to databases. The problem is: whenever I try to connect to DB by running this code: string connparams = "server=127.0.0.1;uid=root;pwd=12345;database=test;"; try { MySqlConnection…
Tim Tim
  • 13
  • 3
0
votes
1 answer

Set PAD_CHAR_TO_FULL_LENGTH on MySql Connector/Net

As MySQL Reference Manual states, The length of a CHAR column is fixed to the length that you declare when you create the table. The length can be any value from 0 to 255. When CHAR values are stored, they are right-padded with spaces to the …
Varan Sinayee
  • 955
  • 2
  • 11
  • 25
0
votes
1 answer

MySQL Connector/Net EF Database First Spatial Datatypes

Using: Entity Framework 5 MySQL Connector Net 6.8.4 MySQL 5.6.21 Visual Studio 2013 MySQL Workbench 6.2 Created the following table in MySQL using the workbench Opened my application in Visual Studio 2013, navigated to my data access layer…
chriszumberge
  • 794
  • 1
  • 16
  • 33
1
2
3