CodeSmith Community

thanks for you share

when running the schema test from Codesmith 3.2.7 and i am getting the following error: I have .net v2.0 System.InvalidCastException: Specified cast is not valid. at ChristianASPNet.MySQLSchemaProvider.MySQLSchemaProvider.GetTableIndexes(String connectionString, TableSchema table) at _CodeSmith.SchemaTest_cst.WriteTableIndexes(String table, String cnnString) at _CodeSmith.SchemaTest_cst.WriteTableNames() at _CodeSmith.SchemaTest_cst.__RenderMethod1(TextWriter writer, Control control) at CodeSmith.Engine.DelegateControl.Render(TextWriter writer) at CodeSmith.Engine.Control.RenderChildren(TextWriter writer) at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer) at CodeSmith.Engine.CodeTemplate.RenderToString() at ej.s() any tips pls

We had the same problem as adrianhedley above. If you take a look at the source code for the GetTableIndexes. the two lines below (found near the top of the foreach loop) bool isPrimaryKey = ((long)ndxRow["IS_PRIMARY"] == 1); bool isUnique = !((long)ndxRow["NON_UNIQUE"] == 1); Had to be changed to: bool isPrimaryKey = ((int)ndxRow["IS_PRIMARY"] == 1); bool isUnique = !((long)ndxRow["NON_UNIQUE"] == 1); To get this working on our system, I guess it might be to do with the MySQL driver or something that returns a int when a long was expected....or something. Anyways this fixed it for us.

Hi I was ownderinf if anyone else had this problem, and if so how they solved it. I started work on writing some SP generation templates for MySQL, and the provider was working, but not it isn't. Now I get the invalid cast operation. I could use some advice on a) Building a schema provider b)debugging a schema provider