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 > > > > > >
