creating Linq to sqlite dbml from DbLinq source code

Question

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.

It will probably help if you let us know what errors you are getting. — Foole
– Foole, Commented Mar 7, 2010 at 12:19
Windows Error Message: "DbMetal has stopped working". This is what i get. Check my edit also — Amsakanna
– Amsakanna, Commented Mar 8, 2010 at 16:42

jonp · Accepted Answer · 2010-03-22 19:24:18Z

2

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

answered Mar 22, 2010 at 19:24

jonp

13.6k5 gold badges47 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Amsakanna Over a year ago

I get this in the command prompt....................... DbLinq Database mapping generator 2008 version 0.17.0.0 for Microsoft (R) .NET Framework version 3.5 Distributed under the MIT licence (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 off bin\DbMetal /provider:Sqlite /conn "Data Source=nwind2009.db3" /dbml:mycode.dbml /namespace:myNS pause

jonp Over a year ago

Please try using either 0.19 or trunk. Alternatively, it's a bug while processing your .db3 file; please file a bug.

Amsakanna Over a year ago

Still i got no help. Recently i tried 0.20. I get this error now: DbMetal: Access to the path 'G:\' is denied.

jonp Over a year ago

What's the full command you're using? It seems rather odd that it would be trying to access G:\. See also: code.google.com/p/dblinq2007/wiki/Installation

Amsakanna Over a year ago

@jonp: Thanks for the help. I cleared the old copy and installed a fresh copy of dblinq and it works fine now.

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

Solution:

Steps I followed:

Downloaded the DBLinq 0.20 source code from this Link
Built it.
copied my database and System.Data.SQLite.dll file to src\DbMetal\obj\Debug folder
Used the following codes to create dbml file from db and cs file from dbml file respectively

DbMetal /provider:Sqlite /conn "Data Source=File.db3" /dbml:File.dbml

DbMetal /code:File.cs File.dbml

The procedure is well illustrated in this link -> http://code.google.com/p/dblinq2007/wiki/Installation

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jul 9, 2010 at 22:40

Amsakanna

13k8 gold badges49 silver badges59 bronze badges

Collectives™ on Stack Overflow

creating Linq to sqlite dbml from DbLinq source code

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related