Provider for VistaDB version 2.1

Hi,

I just have some problems with the SchemaProvider.

I wanted to use Peter Walter's Templates for Wilson's ORMapper and get this errors:

 

System.MissingMethodException: Methode nicht gefunden: Int16 VistaDB.VistaDBColumn.get_ColumnDecimals().
   bei SchemaExplorer.VistaDBSchemaProvider.GetTableColumns(String connectionString, TableSchema table)
   bei SchemaExplorer.TableSchema.get_Columns()
   bei _CodeSmith.MappingFile_cst.IsManyToManyTable(TableSchema table)
   bei _CodeSmith.MappingFile_cst.__RenderMethod1(TextWriter writer, Control control)
   bei CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   bei CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   bei CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   bei CodeSmith.Engine.CodeTemplate.RenderToString()
   bei CodeSmith.Gui.CodeTemplateGenerator.f(Object A_0, EventArgs A_1)

 

Is it possible to solve this problem?

 

Thank you very much in advance.

Thank you for the Provider and code.  I've updated the code slightly adding some throw exceptions to help me debug.  I also couldn't figure out why adding the foreign keys kept failing and had to leave that out.  Aside from lacking foreign key relationships it seems to be working in my limited testing which was on the 2 WORM template mapping.config generators.  Note the keytype on those generated mapping.configs needs changed from User to Auto on identity columns.
I've included the updated .net 2.0 code working with codesmith v3.2.  For those uninterested in updating the code grab the dll out of the bin/release folder and throw it in the Codesmith schemaprovider folder.
For the connection details just enter the path and filename, it threw me off (hence the debug code aditions) that it doesn't want the datasource= at the start just the path and filename (even simpler - just unexpected in my case).

Hi,

I've taken the latest source code provided by slowram and updated it with fixes for the foreign key relationships.  Hope this helps someone!

Christian and Slowram,

    Thanks for the additions.  I've been out of the loop for a bit.  I will check out the additions this weekend since I have to work anyway.

 

John