score:2
Accepted answer
Solution:
Steps I followed:
- Downloaded the DBLinq 0.20 source code from this Link
- Built it.
- copied my database and
System.Data.SQLite.dllfile tosrc\DbMetal\obj\Debugfolder - 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
score: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
Source: stackoverflow.com
Related Query
- creating Linq to sqlite dbml from DbLinq source code
- c# Linq or code to extract groups from a single list of source data
- Creating a LINQ select from multiple tables
- Creating a dictionary from another dictionary using LINQ
- Enumerable.Empty<T>().AsQueryable(); This method supports the LINQ to Entities infrastructure and is not intended to be used directly from your code
- How to understand the following C# linq code of implementing the algorithm to return all combinations of k elements from n
- How to pass LinQ Expressions from F# to C# code
- Using LINQ to delete an element from a ObservableCollection Source
- How does linq actually execute the code to retrieve data from the data source?
- LINQ Source Code Available
- Creating a LINQ Select expression dynamically from string column names
- Linq - Creating Expression<T1> from Expression<T2>
- Creating a dynamic Linq select clause from Expressions
- Creating multiple results from Linq query
- Is there a bug in this code from 101 LINQ Samples on MSDN? (Update: Fixed)
- C# Linq query help removing foreach loops creating cleaner code
- Creating an anonymous object via LINQ from IObservable?
- Creating JProperty from Dictionary with LINQ in JSON.NET
- C# LINQ How to get a data source from a db?
- Attempting to obtain properties / fields from an (anonymous class) object linq is creating
- Creating a LINQ query that will include all entries from the current week excluding today and yestreday
- Create Records with Linq to SQLite via DbLinq
- Can't add a new record with an integer value into database by using linq from code C#
- Create and insert from Temporary table using Linq to SQL in DBML
- Linq error while dragging and dropping my table from server explorer to dbml file
- Creating lists from another list's item in Linq
- Creating an Object List from another List Object LINQ Lambda
- source code for LINQ 101 samples
- Problem creating an Entity object/queryable from the result of a LINQ join in MVC
- Linq code to get the index of an object in an array from an object within a list
More Query from same tag
- Can we use Generic Repository without using EF? Is it a good practise?
- Bind multiple dropdowns from a single list
- How can I subtract two dates and get a new date converted in minutes?
- How to Set Custom DataGridView Headers (with spaces) using LINQ?
- how to use .Contains LINQ in decimal fields
- How to catch an exception only if another exception as not occured in C#
- difference between select and where in LINQ
- How to display the sum of the rest of the Transaction types
- How to use linq to exclude Specific HtmlAgility ChildNodes
- Entity Framework and Related Table Data
- how to read nested elements using Linq to xml
- Linq distinct operation
- Convert SQL to LINQ equivalent
- Getting Max Value Generic List For Each Item
- Grouping and remove from list
- How do I combine these similar linq queries into one?
- How to sort a list of string?
- varchar vs nvarchar orderby linq to entities
- Observable<string> updated events?
- dilemma on the use of inheritance in EF code-first
- Separating concerns with Linq To SQL and DTO's
- Linq query NullReferenceException on multiple (cascade) left joins
- .NET .ToList function is WAY WAY too slow
- Linq query error
- ForEach loop with Lambda expression in Razor code MVC 5 For List<T>
- How to execute query to select multiple attributes subject to several where clauses across two tables
- Invalid cast is possible in Linq2SQL query
- Grouping data with sum
- Converting a SQL Query to a Predicate Expression using Fluent Synatx
- double order by in Dynamics CRM 2011 Linq query
