Showing entries 31 to 40 of 106
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: .NET (reset)
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=;",

KeyRestrictionBehavior.AllowOnly);

permission.PermitOnly();

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]
Intellisense Support

 Intellisense Support in Visual Studio

One of the cool features coming in Connector/NET 6.5 is the support in Visual Studio 2010 of Intellisense for MySql files.

As you probably know, the capability of editing mysql files (in the way of both .mysql raw files included in the solution and stored procedures/functions from Server Explorer) has been around for a while, yet a missing piece of the puzzle was to have advanced completion of sql statements in those files… until now.

Let’s explore the set of features currently implemented as part of Intellisense support.

Note: For completion intellisense features to work a database connection must be properly configured, see images below


For Server Explorer items, the connection is the root …
[Read more]
Intellisense Support

One of the cool features coming in Connector/NET 6.5 is the support in Visual Studio 2010 of Intellisense for MySql files.

As you probably know, the capability of editing mysql files (in the way of both .mysql raw files included in the solution and stored procedures/functions from Server Explorer) has been around for a while, yet a missing piece of the puzzle was to have advanced completion of sql statements in those files… until now.

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 (http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html).  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]
Introducing the team!

When Oracle acquired MySQL there was some concern about what would happen with the world's most popular open-source database.  It's clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it's related technologies.  I know because I run one of those teams!

I've been working on MySQL and .NET technologies for the past 8 years and I'm very proud to introduce a couple of people who have been and will continue be working on my team.  

Fernando Gonzalez currently serves as leader of our Connector/Net team and has just completed some early work on major intellisense improvements on Connector/Net 6.5.  He's done work on developing a new parser for our product.  We look forward to Fernando being a team leader and productive member of our team!


[Read more]
Introducing the team!

When Oracle acquired MySQL there was some concern about what would happen with the world's most popular open-source database.  It's clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it's related technologies.  I know because I run one of those teams!

I've been working on MySQL and .NET technologies for the past 8 years and I'm very proud to introduce a couple of people who have been and will continue be working on my team.  

Fernando Gonzalez currently serves as leader of our Connector/Net team and has just completed some early work on major intellisense improvements on Connector/Net 6.5.  He's done work on developing a new parser for our product.  We look forward to Fernando being a team leader and productive member of our team!


[Read more]
MySQL Connector/Net 6.3.8 has been released

MySQL Connector/Net 6.3.8, a new version of the all-managed .NET driver for MySQL has been released.  This is a maintenance release to our 6.3 release chain and includes 40 changes and fixes.

Version 6.3.8 is appropriate for use with versions of MySQL 5.0-5.5.

It is now available in source and binary form from here 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.)

The release is also available for download on My Oracle Support (MOS).

Enjoy and thanks for the support!

Showing entries 31 to 40 of 106
« 10 Newer Entries | 10 Older Entries »