Saturday, February 18, 2006
« Microsoft Abandons PowerPoint | Main | DataManager Class with IsolatedContext f... »
MySQL Schema Provider 0.9.2 Released
Version 0.9.2 of MySQLSchemaProvider for CodeSmith and MySQL 5.0 is now available for download.  Changes include:
  • Updated GetTableKeys() to provide not only the foreign keys for the table but also the foreign keys of other tables that point to the given table. Code update graciously provided by Dug Steen.  Thanks!
  • Added .NET 2.0 version for CodeSmith 3.2.5 or higher
  • .NET 1.1 version requires CodeSmith 3.1.6
Keep in mind that the version requirements are for the assemblies that ship with the current download.  If you are using a previous 3.xx version of CodeSmith, you can simply recompile from the source code and it should work.

MySQL | Components
Saturday, February 18, 2006 12:38:57 AM (Central Standard Time, UTC-06:00)  #    Disclaimer  |  Comments [3]  |  Related posts:
Excentrics World Server Controls v2.0, RC1
Free E-mail Validation Web Service
DataManager Class with IsolatedContext for WilsonORMapper
Free AJAX UI Library From Yahoo!
Excentrics World Back in Business!
New WebChart Lite and Splitter Control
Saturday, May 27, 2006 6:58:47 AM (Central Standard Time, UTC-06:00)
David,
My friend refered me with CodeSmith and I really got interested in the product as looks like it can increase the productivity sharply for me or I would say anyone who is using it.

Though I am using MySQL v.5.0, CodeSmith Standard v3.2 and .NET v2.0 and your MySQLSchemaProvider(ChristianASPNet.MySQLSchemaProvider.dll).
I am not able to make it work successfully :( When I go to add new schema, I don't see mySqlSchemaProvider in the list. There is only ADOX and SqlServer. As your readme suggestion, I have copied the dll to SchemaProviders folder also. I am not able to figure out whats wrong as there is no message also... Any suggestion or any of your help, greatly appreciate it.

Thanks,
Ashesh.



ashesh | ashesh_shethAT NOSPAMyahoo dot com
Saturday, May 27, 2006 7:38:07 AM (Central Standard Time, UTC-06:00)
Hi Ashesh,

You will probably need to recompile the assembly from the included source code. Most problems with custom schema providers seem to be solved by this. Also, be sure that CodeSmith is not running when you copy the assembly to the SchemaProviders folder.

Hope this helps!
David
David | davidAT NOSPAMchristianasp dot net
Monday, September 04, 2006 12:18:11 PM (Central Standard Time, UTC-06:00)
David,
I was very excited when I found your provider for MySQL. I have installed it and am able to successfully test a connection to my Database. When I try to run your SchemaTest.cst template, I get this error:

There is already an open DataReader associated with this connection which must be closed first.

I have already tried recompiling the code and get the same error with that dll also.

Here is my info:

MySQLSchemaProvider: 0.92
MySQL: MySQL 5.0.24a-community-nt via TCP/IP
CodeSmith Professional: 3.2.7
Visual Studio 2005
Windows XP Pro SP2

Any help you can give me would be greatly appreciated.

Paul
Paul Fullerton | paulfAT NOSPAMpkfullerton dot com
Comments are closed.