tags:

views:

643

answers:

2

Hi All,

I tried to create linq-to-sqlite dbml using DbLinq but in vain. Each time I get different type of errors. May be I'm somewhere wrong.

Can anyone tell me the step by step procedure to create the dbml file from the Dblinq source code.

+1  A: 

You need to provide a /provider:PROVIDER option to DbMetal.exe so that it knows what kind of database you're using, otherwise it assumes you want Microsoft SQL Server.

Furthermore, you can only use the /dbml or /code options, not both at the same time.

Try this command instead:

DbMetal /provider:Sqlite /conn "Data Source=myDb.db3" /code:mycode.cs /namespace:myNS

If that doesn't work, please file a bug at: http://code.google.com/p/dblinq2007/issues/list

jonp
I get this in the command prompt.......................DbLinq Database mapping generator 2008 version 0.17.0.0for Microsoft (R) .NET Framework version 3.5Distributed under the MIT licence (http://linq.to/db/license)>>> Reading schema from DBML file 'Data Source=nwind2009.db3'Press any key to continue . . .my command in run_sqliteMetal is:@echo offbin\DbMetal /provider:Sqlite /conn "Data Source=nwind2009.db3" /dbml:mycode.dbml /namespace:myNSpause
Veer
but i get no dbml file... Any help?...
Veer
Please try using either 0.19 or trunk. Alternatively, it's a bug while processing your .db3 file; please file a bug.
jonp
Still i got no help. Recently i tried 0.20. I get this error now: DbMetal: Access to the path 'G:\' is denied.
Veer
What's the full command you're using? It seems rather odd that it would be trying to access G:\. See also: http://code.google.com/p/dblinq2007/wiki/Installation
jonp
@jonp: Thanks for the help. I cleared the old copy and installed a fresh copy of dblinq and it works fine now.
Veer
A: 
Veer