There are ADO.NET providers available for SQLite. That would be the way to go 
if you want to use SQLite in .NET (any language). Check out these links:

http://sqlite.phxsoftware.com/
http://adodotnetsqlite.sourceforge.net/
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers - Scroll down to .NET 
section

Disclaimer: I haven't used any of these providers so I cannot comment on it.

HTH,

Jalil Vaidya
 
01001010
01100001
01101100
01101001
01101100

----- Original Message ----
From: Brad House <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Sunday, March 2, 2008 9:29:33 AM
Subject: Re: [sqlite] [newbie] SQLite and VB.Net?

>     I don't know anything about .Net, and I'd like to build a quick app
> with Visual Studio 2005 or 2008 to check how well it performs with
> SQLite. If performance and deployment prove to be good enough, we'll
> use VB.Net for new projects and finally dump VB6.

I have almost no experience with .Net (or any other microsoft-specific
technologies), but we've had to advise some clients on how to use
a library we provide from within Vb.Net and the InteropServices worked
for them.  Not sure if they'd meet your needs or not, but you might
give them a shot, it's as close to native as you'll get.

Basic structure I think goes like this (though it should be easy
to google):

Imports System.Runtime.InteropServices

Declare Ansi Function sqlite3_open Lib "sqlite3.dll" _
    (ByVal filename As String, ByRef db As IntPtr) _
    As Integer
Public SQLITE3_OK = 0


Dim db As IntPtr
If sqlite3_open("my_sqlite3.db", db) != SQLITE3_O
K
    Console.WriteLine("Failed to open")
End If

-Brad
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users





      
____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to