El
This may help, here is Linq to SQLite.
https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx<https://www.odesk.com/leaving-odesk?ref=https%253A%252F%252Fwww.kellermansoftware.com%252Fp-47-net-data-access-layer.aspx>
On Monday, 20 September 2010 14:09:39 UTC-4, El wrote:
>
> I'm trying to get linq to work with sqlite on mono, in fact using
> monodevelop 2.4 and mono 2.6, and Ubuntu 10.04.1 Linux. I've tried
> all the suggestions in various blogs, forum, and discussions. But
> nothing works. Maybe this post will get me some relief with someone
> pointing out the obvious or coming about what I need to do to get it
> to work. Here's what I have done so far and just can't figure what
> I'm doing wrong.
>
> In MonoDevelop, create a solution/project call sqlinqtest. I
> reference most of the assemblies suggested in various sites as follows
> (although I think now it is overkill):
>
> Mono.Data
> Mono.Data.Sqlite
> Mono.Data.SqliteClient
> System
> System.Core
> System.Data
> System.Data.Linq
>
> I have a sqlite 3 database call MySampleDB.sq3. I put this in my Bin/
> Debug directory. I use sqlmetal to generate the MySampleDB.cs file as
> follows:
>
> $ sqlmetal /provider:Sqlite /conn "Data Source=./MySampleDB.sq3" /
> code:MySampleDB.cs
>
> Then I moved the generated cs code to the project directory and added
> this file to my project in MonoDevelop.
>
> I edited the file to rename all "Main" in the MySampleDB.cs to be
> MySampleDB is avert confusion with my Main() class.
>
> In my Main.cs on the project, which is a console type project, I
> created the following code:
>
> using System;
> using System.Data;
> using Mono.Data.SqliteClient;
> using System.Linq;
> using DBLinq;
>
> namespace sqlinqtest
> {
> class MainCLass
> {
> public static void Main(string[] args)
> {
> linqtestcode();
> }
>
> private static void linqstylecode()
> {
> IDbConnection dbcon;
> dbcon = (IDbConnection) new SqliteConnection(
> "DBLinqProvider=Sqlite; DataSource=./
> MySampleDB.sq3" // per other blog, does not require
>
> //
> DbLinqDataTypeProvider if pass
>
> //
> as IDbConnection.
> var db = new MySampleDB(dbcon);
> var users = from u in db.User select u;
>
> foreach( var user in users )
> { Console.WriteLine(user.uid + " " + user.name); }
> }
> }
> }
>
> Note, I want to use the DataContext style that I am familiar with on
> Linq in MS, and I want to use Linq on Mono in Linux.
>
> So the problem I'm having is that the table column definitions in the
> query is not visible and obviously I get an error at compile saying
> that "Type 'User' does not contain the definition for 'uid' and no
> extension method 'uid' of type 'User' could be found", suggesting that
> I may have a missing "using" directive or a missing assembly
> reference.
>
> Is this a bug? If not, how do I get this to work? Thanks.
>
> -El
--
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/dblinq?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
