Category Archives: mysql

.NET mySql PerformanceMonitor Class

The 6.x mySql Connector for .NET comes with two performance counters that seem to be working rather well. If I call the same stored procedure 1,000 times… the metadata is only retrieved from the server the first time. All subsequent … Continue reading

Posted in .net, mysql | Leave a comment

Example mySql IsDate Function

Here is an example mySql IsDate function using a regular expression: CREATE DEFINER=`root`@`localhost` FUNCTION `IsDate`(var varchar(25)) RETURNS tinyint(4)DETERMINISTICBEGIN/* 05/17/2009, 5/01/2009, 5/1/2009 */declare result tinyint;select trim(var)REGEXP ‘^([1-9]|0[1-9]|1[012])/([1-9]|0[1-9]|[12][0-9]|3[01])/(19|20)[0-9][0-9]’into @result;return @result;END

Posted in mysql | Leave a comment

MySql Connector .NET MySqlBulkLoader Example

Here is a MySqlBulkLoader example I quickly wrote to import 65,000 records into a mySql 5.1 database using the mySql Connector 5.2.5. And yes, its fast as snot (the lead programmer at my first programming job out of college invented … Continue reading

Posted in .net, mysql | 8 Comments

Using Microsoft ADO.NET Entity Framework with MySQL

Unfortunately, this week’s Using Microsoft ADO.NET Entity Framework with MySQL Webinar is being postponed to Tuesday November 4, 2008. Myself and many others are looking forward to some (if not all) entity framework support. It seems that I check the … Continue reading

Posted in .net, mysql | 2 Comments

mySql ASP.NET Membership and Role Provider

The mySql.Web.dll is a great addition to the mySql Connector for .NET. In order to utilize one must create (and use) a mySql user (localhost) with select, insert, update, delete, create, drop, and alter privileges. Quickly running ASP.NET Configuration Web … Continue reading

Posted in .net, mysql | 2 Comments