Thanks, Joe, for that response.   Is it possible for you, or anyone else, to
send an e-mail to me, attaching a sample SQLite database and some examples
of simple uses of C# for searching, relations, adds, changes. etc.   Nothing
fancy, please.   Just minimal so it's easy to follow.  Or maybe, there is a
link to material like this.

I think I want to download and get started.   

My direct e-mail is [email protected]

Thanks.




-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Joe Mistachkin
Sent: Tuesday, December 13, 2011 10:28 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] FW: SQLite with Vis. Studio C# Entity Framework 4.1


Jeff Matthews wrote:
>
> Does SQLite integrate with Vis. Studio with these same features available?
>

Currently, the CLR/VS integration for SQLite is primarily accomplished via
System.Data.SQLite, please see:

http://system.data.sqlite.org/

The Visual Studio design-time components are there as well; however, the
installer for them is being re-written to support Visual Studio 2010 and to
be
more robust.  The plan is for it to be included in the next release, due out
sometime in January.  Meanwhile, if you can [temporarily] live without the
design-time support, the SQLite to CLR integration works fine now.

>
> If so, instructions on how to install it and test it (or references to
> tutorials) would be great.
>

For all the components *except* the Visual Studio design-time support
components,
"installing" is merely the process of copying the necessary assemblies to
your
application binary directory (or putting them in the GAC, which is not
actually
recommended).

The official source code and binary packages may be downloaded from:

https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

Alternatively, there are several official NuGet packages available:

https://nuget.org/packages/System.Data.SQLite
https://nuget.org/packages/System.Data.SQLite.x86

The first two (above) contain the same files and contain the SQLite core
native
code compiled for x86.

https://nuget.org/packages/System.Data.SQLite.x64

The next one (above) contains the same managed code; however, the contained
SQLite
core native code has been compiled for x64.

https://nuget.org/packages/System.Data.SQLite.MSIL

Finally, the last one (above) contains ONLY the managed code and must be
used in
conjunction with a "SQLite.Interop.dll" for the appropriate platform.

--
Joe Mistachkin

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to