[Mono-dev] [Mono-list] Assembly / Namespace mapping (ASP.NET / SQLite)

Joe Audette joe.audette at gmail.com
Fri Feb 8 17:03:47 EST 2008


Hi Timothy,

I'm not sure, I know that Mono.Data.SQLite had a lot of work put into
it, it may have evolved from System.Data.SQLite, I'm not really sure.
But it works pretty well in my experience  and is cross platform where
System.Data.SQLite.dll is not.
I'm attaching a zip. I think I was wrong about it needing
Mono.Data.Security, that is needed for Npgsql which is for postgres.

Hope it helps,

Joe


On Feb 8, 2008 4:57 PM, Timothy Parez <timothyparez at gmail.com> wrote:
> That would be great.
> But is Mono.Data.SQLite based on System.Data.SQLite, if so on what
> version,
> because there have been quite a few problems with older versions (and
> one of the recent versions).
>
> Please do send :)
>
> Timothy.
>
>
> On 08 Feb 2008, at 22:50, Joe Audette wrote:
>
> > Hi Timothy,
> >
> > Why not just use Mono.Data.SQLite on both platforms, thats what I do
> > in mojoPortal.
> > If you'd like I can send you Mono.Data.SQLite.dll which I compiled on
> > windows using VS.
> > It works fine on both windows and on linux. It also requires
> > Mono.Security.dll but I can send you that too.
> >
> > Hope it helps,
> >
> > Joe
> >
> > On Feb 8, 2008 4:38 PM, Timothy Parez <timothyparez at gmail.com> wrote:
> >> Hi,
> >>
> >> I have a         website which I develop on Windows and deploy on
> >> Linux.
> >> I'm using SQLite which works on both platforms.
> >>
> >> The only differences are
> >>
> >> using System.Data.SQLite
> >> vs
> >> using Mono.Data.Sqlite
> >>
> >> And for the classes:
> >>
> >> SQLiteConnection
> >> vs
> >> SqliteConnection
> >>
> >> Aside from these differences, the code to use these libraries is the
> >> same.
> >>
> >> This means I have to use a series of sed commands to replace pieces
> >> of
> >> text.
> >> This isn't a real problem for final deployment, but can be a real
> >> PITA
> >> when testing online.
> >>
> >> Is there anyway to map these so I can keep System.Data.SQlite and
> >> SQLiteConnection, SQLiteCommand, etc... in my code
> >> and still force mono to use System.Data.Sqlite instead?
> >>
> >> (Guess changing the source code for Mono.Data.Sqlite would also be an
> >> option... but I'm hoping for something less drastic).
> >>
> >> Thank you.
> >>
> >> Timothy.
> >> _______________________________________________
> >> Mono-list maillist  -  Mono-list at lists.ximian.com
> >> http://lists.ximian.com/mailman/listinfo/mono-list
> >>
> >
> >
> >
> > --
> > Joe Audette
> > Software Solutions Architect
> > Source Tree Solutions, LLC
> > PO Box 621861
> > Charlotte, NC 28262
> > 704.323.8225
> > joe.audette at gmail.com
> > http://www.sourcetreesolutions.com
> > http://www.mojoportal.com
>
>



-- 
Joe Audette
Software Solutions Architect
Source Tree Solutions, LLC
PO Box 621861
Charlotte, NC 28262
704.323.8225
joe.audette at gmail.com
http://www.sourcetreesolutions.com
http://www.mojoportal.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Mono.Data.SQLite.zip
Type: application/zip
Size: 94945 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080208/3cf36070/attachment-0001.zip 


More information about the Mono-devel-list mailing list