>From looking at this comment: http://tinyurl.com/93tfg http://cvs.sourceforge.net/viewcvs.py/adodotnetsqlite/SQLite.NET/SQLite3/SQLite3.vcproj?rev=1.3&view=log
it looks like they use the already ported source from another project called sqlite-ce: http://sqlite-wince.sourceforge.net/ which is up to v3.1.5 (March 11 2005). --- Nicko Cadell <[EMAIL PROTECTED]> wrote: > Ok so it embedded in the provider. I guess that makes things simple. > > Cheers. > > > -----Original Message----- > > From: Ron Grabowski [mailto:[EMAIL PROTECTED] > > Sent: 11 May 2005 15:16 > > To: Log4NET User > > Subject: RE: Example using log4net.Appender.ADONetAppender > > for 1.2.0 beta 8 and SQLite > > > > According to their CVS repository: > > > > http://tinyurl.com/9ctk2 > > http://cvs.sourceforge.net/viewcvs.py/adodotnetsqlite/SQLite.N > > ET/SQLite3/ > > > > It looks like the library was built against v3.0.7 of SQLite. > > > > --- Nicko Cadell <[EMAIL PROTECTED]> wrote: > > > Ron, > > > > > > This looks great, I will add it to the config examples page. > > > Do you know which version of SQLite this was tested against? > > > > > > Cheers, > > > Nicko > > > > > > > -----Original Message----- > > > > From: Ron Grabowski [mailto:[EMAIL PROTECTED] > > > > Sent: 05 May 2005 17:05 > > > > To: [email protected] > > > > Subject: Example using log4net.Appender.ADONetAppender for > 1.2.0 > > > > beta 8 and SQLite > > > > > > > > Other people might find this useful... > > > > > > > > This was tested against v0.21 of the SQLite .NET provider: > > > > > > > > http://sourceforge.net/projects/adodotnetsqlite > > > > > > > > SQLite doesn't have strongly-typed columns or field > > lengths but its > > > > recommended you still include this information for > > > > readability: > > > > > > > > CREATE TABLE Log ( > > > > LogId INTEGER PRIMARY KEY, > > > > Date DATETIME NOT NULL, > > > > Level VARCHAR(50) NOT NULL, > > > > Logger VARCHAR(255) NOT NULL, > > > > Message TEXT DEFAULT NULL > > > > ); > > > > > > > > <appender name="ADONetAppender_SQLite" > > > > type="log4net.Appender.ADONetAppender"> > > > > <connectionType value="Finisar.SQLite.SQLiteConnection, > > > > SQLite.NET, Version=0.21.1869.3794, Culture=neutral, > > > > PublicKeyToken=c273bd375e695f9c" /> <connectionString > > value="Data > > > > Source=c:\\\\inetpub\\\\wwwroot\\\\logs\\\\log4net.db;Version= > > > > 3;" /> <commandText value="INSERT INTO Log (Date, Level, > Logger, > > > > Message) VALUES (@Date, @Level, @Logger, @Message)" > > > > /> <bufferSize value="1" /> <parameter> > > > > <parameterName value="@Date" /> > > > > <dbType value="DateTime" /> > > > > <layout type="log4net.Layout.RawTimeStampLayout" /> > > </parameter> > > > > <parameter> > > > > <parameterName value="@Level" /> > > > > <dbType value="String" /> > > > > <layout type="log4net.Layout.PatternLayout"> > > > > <conversionPattern value="%p" /> > > > > </layout> > > > > </parameter> > > > > <parameter> > > > > <parameterName value="@Logger" /> > > > > <dbType value="String" /> > > > > <layout type="log4net.Layout.PatternLayout"> > > > > <conversionPattern value="%c" /> > > > > </layout> > > > > </parameter> > > > > <parameter> > > > > <parameterName value="@Message" /> > > > > <dbType value="String" /> > > > > <layout type="log4net.Layout.PatternLayout"> > > > > <conversionPattern value="%m" /> > > > > </layout> > > > > </parameter> > > > > </appender> > > > > > > > > Make sure you use four slashes in the connection string. > > > > log4net translates those into two slashes which SQLite > > requires for > > > > its connection string. > > > > > > > > - Ron > > > > > > > > > >
