Please provide samples of command line tool dbmetal to generate code file from a sqlite database.
+2
A:
Surfing the internet I found the following command:
DBMetal.exe /namespace:Namespace /provider:SQLite "/conn:Data Source=database.db" /code:CodeFile.cs
Only, the DBMetal version that I downloaded gave an error (Unable to resolve databaseConnectionType: System.Data.SQLite.SQLiteConnection)
I fixed it by downloading the code from the trunk (http://dblinq2007.googlecode.com/svn/trunk), compiling it, and using the generated DBMetal.exe with the above command.
Lukasvan3L
2010-01-21 14:36:22
also had to pull down the trunk to get it run
levi rosol
2010-02-05 16:46:41
Same here - once I built from trunk, that command ran great.
James Manning
2010-03-17 19:30:57
Looking at http://code.google.com/p/dblinq2007/issues/detail?id=212 it appears to be By Design - it works when built from svn because the ado.net provider (System.Data.SQLite.DLL) is in the build output dir - the ado.net providers aren't in the binaries zip, though - it's up to the user to get it into the same dir as dbmetal (or edit the dbmetal.exe.config, as mentioned in the bug).Certainly would be nicer/easier if they could ship some (if not all) of the ado.net providers "in the box" (in the zip), but between licensing and not wanting to track patches/versions for the providers, it's fine
James Manning
2010-03-17 19:38:19