Showing entries 1 to 10 of 22
10 Older Entries »
Displaying posts with tag: connector/net (reset)
Getting started with ASP.NET Core and MySQL Connector/NET

This tutorial shows how to read information from MySQL Sakila database in an ASP.NET Core application using Connector/NET Core to explore the possibility to run this application on any .NET Core supported environment as Windows, Linux, and Mac.


Windows and Visual Studio 2015

The first step is to create an ASP.NET Core Web Application (.NET Core) type project and name it MvcSakilaCore

Note: the …

[Read more]
Connector/NET 6.8.3 is available as official MySQL Nuget packages

Dear MySQL users,

We are proud to announce that we have made the open source version of our Connector/NET 6.8.3 is available as official MySQL Nuget packages.

Currently we have 3 nuget packages which contain:

  • MySQL Connector/NET Core
  • MySQL Connector/NET for Entity Framework 6
  • MySQL Connector/NET Web providers
MySQL Connector/Net 6.6.6 has been released

Dear MySQL users,

MySQL Connector/Net 6.6.6, 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 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.)

How to: Using MySQL Connector/NET with Windows Store Apps

This post will show how to use Connector/NET and Windows Store Apps in Windows 8 to connect and retrieve data from a MySql Server database.

How To: Using spatial data with Entity Framework and Connector/Net

This post is an introduction on how to use the new support  for spatial data types with Entity Framework 5.0 on applications with MySQL and Connector/Net.

Running Connector/Net 6.5 inside Medium-Trust Level

As you probably know, there were some problems using our connector in medium-trust level scenarios. Most hosting services provide MySQL access.  Most of these hosting providers run their .NET web apps using medium trust.  Prior to 6.5, our connector required the hosting provider to either run the application in full trust or to enable broad privileges like SocketPermission globally.  Many hosting providers are unwilling to do that.  So fully enabling our provider to run in a partial trust scenario was a strongly requested feature. The request was a very simple task: enable Connector/Net to work correctly in a medium-trust level environment when the library is installed in the GAC.

The implementation consisted of including the necessary security imperative asserts so the CLR allows our code to perform the operations where it needs permission to perform.

The permissions that we needed were: …

[Read more]
Running Connector/Net 6.5 inside Medium-Trust Level

Connector/Net is now enabled to work inside a Medium/Partial Trust security level. Just download the new 6.5 version to use with your .Net application and you should be able to see it working just fine.

Using MySqlClientPermission Class on Connector/Net 6.5 to restrict data access

The release of the new 6.5 Connector/Net version includes a MySqlClientPermission class to help all the users define the security polices to use in the database connections within any application using a MySQL database.

Using MySqlClientPermission Class on Connector/Net 6.5 to restrict data access

We have a new feature as part of the 6.5 release. There is a new class that you can use to restrict access to specific connection strings that you want to use in all the connections in applications that use MySQL databases.

The following example shows how you can use the MySQLClientPermission class to restrict access to a specific server name and a database, while allowing any value for the User Id and Password within the connection string:

MySqlClientPermission permission = new MySqlClientPermission(PermissionState.None);

permission.Add("server=localhost;database=test;", " user id=; password=;",



MySqlConnection myconn = new MySqlConnection();

myconn.ConnectionString = "server=localhost; user id=QueryUser; database=test;";

myconn.Open();  // Attempt to use the connection string

The first line of …

[Read more]
Milliseconds value support on DateTime Columns

Since the release of the 5.6 Community MySQL Server there is support for the milliseconds value in Time, TimeStamp and DateTime types.  You can find more information on this new feature at (  Starting with version 6.5, Connector/Net fully supports milliseconds. This support does not affect compatibility with older versions of MySQL and it gives you the ability to use fractional seconds when combining Connector/Net 6.5 with MySQL Server 5.6 or later.  Let's see how we should use it.

Creating a DateTime column that include Milliseconds value.

You can do this either using Connector/Net or using any MySQL client with a valid connection to your database.

For this case we're going to use MySqlCommand class within a console application in VS 2010.

[Read more]
Showing entries 1 to 10 of 22
10 Older Entries »