| <html xmlns:MSHelp="http://msdn.microsoft.com/mshelp" xmlns:mshelp="http://msdn.microsoft.com/mshelp"><head><link rel="SHORTCUT ICON" href="./../icons/favicon.ico" /><style type="text/css">.OH_CodeSnippetContainerTabLeftActive, .OH_CodeSnippetContainerTabLeft,.OH_CodeSnippetContainerTabLeftDisabled { backgroundImageName: tabLeftBG.gif; }.OH_CodeSnippetContainerTabRightActive, .OH_CodeSnippetContainerTabRight,.OH_CodeSnippetContainerTabRightDisabled { backgroundImageName: tabRightBG.gif; }.OH_footer { backgroundImageName: footer_slice.gif; background-position: top; background-repeat: repeat-x; }</style><link rel="stylesheet" type="text/css" href="./../styles/branding.css" /><link rel="stylesheet" type="text/css" href="./../styles/branding-en-US.css" /><style type="text/css"> | |
| body | |
| { | |
| border-left:5px solid #e6e6e6; | |
| overflow-x:scroll; | |
| overflow-y:scroll; | |
| } | |
| </style><script src="./../scripts/branding.js" type="text/javascript"><!----></script><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>AdoNetAppender Class</title><meta name="Language" content="en-us" /><meta name="System.Keywords" content="AdoNetAppender class" /><meta name="System.Keywords" content="log4net.Appender.AdoNetAppender class" /><meta name="System.Keywords" content="AdoNetAppender class, about AdoNetAppender class" /><meta name="Microsoft.Help.F1" content="log4net.Appender.AdoNetAppender" /><meta name="Microsoft.Help.Id" content="T:log4net.Appender.AdoNetAppender" /><meta name="Description" content="Appender that logs to a database." /><meta name="Microsoft.Help.ContentType" content="Reference" /><meta name="BrandingAware" content="'true'" /><meta name="container" content="log4net.Appender" /><meta name="file" content="T_log4net_Appender_AdoNetAppender" /><meta name="guid" content="T_log4net_Appender_AdoNetAppender" /><link type="text/css" rel="stylesheet" href="ms-help://Hx/HxRuntime/HxLink.css" /><link type="text/css" rel="stylesheet" href="./../styles/highlight.css" /><script type="text/javascript" src="../scripts/highlight.js"><!----></script><meta name="SelfBranded" content="true" /></head><body onload="onLoad()" class="primary-mtps-offline-document"><div class="OH_outerDiv"><div class="OH_outerContent"><table class="TitleTable"><tr><td class="OH_tdTitleColumn">AdoNetAppender Class</td><td class="OH_tdRunningTitleColumn">Apache log4net™ SDK Documentation</td></tr></table><div id="mainSection"><div id="mainBody"><span class="introStyle"></span><div class="summary"> | |
| Appender that logs to a database. | |
| </div><div class="OH_CollapsibleAreaRegion"><div class="OH_regiontitle">Inheritance Hierarchy</div><div class="OH_CollapsibleArea_HrDiv"><hr class="OH_CollapsibleArea_Hr" /></div></div><div class="OH_clear"></div><img src="./../icons/online_icon.gif" class="OH_offlineIcon" alt="Online" title="Online" /><a href="http://msdn2.microsoft.com/en-us/library/e5kfa45b" target="_blank">System<span id="ID0EBKPAAAAA"> </span><script type="text/javascript"> | |
| addToLanSpecTextIdSet("ID0EBKPAAAAA?vb=.|cpp=::|cs=.|fs=.|nu=."); | |
| </script>Object</a><br /> <a href="T_log4net_Appender_AppenderSkeleton.htm" target="">log4net.Appender<span id="ID0EBHPAAAAA"> </span><script type="text/javascript"> | |
| addToLanSpecTextIdSet("ID0EBHPAAAAA?vb=.|cpp=::|cs=.|fs=.|nu=."); | |
| </script>AppenderSkeleton</a><br /> <a href="T_log4net_Appender_BufferingAppenderSkeleton.htm" target="">log4net.Appender<span id="ID0EBEPAAAAA"> </span><script type="text/javascript"> | |
| addToLanSpecTextIdSet("ID0EBEPAAAAA?vb=.|cpp=::|cs=.|fs=.|nu=."); | |
| </script>BufferingAppenderSkeleton</a><br /> <span class="selflink">log4net.Appender<span id="ID0EBBPAAAAA"> </span><script type="text/javascript"> | |
| addToLanSpecTextIdSet("ID0EBBPAAAAA?vb=.|cpp=::|cs=.|fs=.|nu=."); | |
| </script>AdoNetAppender</span><br /><p></p><b>Namespace:</b> <a href="N_log4net_Appender.htm" target="">log4net.Appender</a><br /><b>Assembly:</b> <span sdata="assembly">log4net</span> (in log4net.dll) Version: 1.2.14.0 (1.2.14.0)<div class="OH_CollapsibleAreaRegion"><div class="OH_regiontitle">Syntax</div><div class="OH_CollapsibleArea_HrDiv"><hr class="OH_CollapsibleArea_Hr" /></div></div><div class="OH_clear"></div><div id="snippetGroup_Syntax" class="code"><div id="ID0ECAFAAAAA" class="OH_CodeSnippetContainer"><div class="OH_CodeSnippetContainerTabs" id="ID0ECAFAAAAA_tabs"><div class="OH_CodeSnippetContainerTabLeftActive" id="ID0ECAFAAAAA_tabimgleft"></div><div id="ID0ECAFAAAAA_tab1" class="OH_CodeSnippetContainerTabActive" EnableCopyCode="true"><a href="#" onclick="javascript:ChangeTab('ID0ECAFAAAAA','C#','1','4');return false;">C#</a></div><div id="ID0ECAFAAAAA_tab2" class="OH_CodeSnippetContainerTab" EnableCopyCode="true"><a href="#" onclick="javascript:ChangeTab('ID0ECAFAAAAA','Visual Basic','2','4');return false;">VB</a></div><div id="ID0ECAFAAAAA_tab3" class="OH_CodeSnippetContainerTab" EnableCopyCode="true"><a href="#" onclick="javascript:ChangeTab('ID0ECAFAAAAA','Visual C++','3','4');return false;">C++</a></div><div id="ID0ECAFAAAAA_tab4" class="OH_CodeSnippetContainerTabDisabledNotFirst" EnableCopyCode="true" disabled="true"><a>F#</a></div><div class="OH_CodeSnippetContainerTabRight" id="ID0ECAFAAAAA_tabimgright"></div></div><div id="ID0ECAFAAAAA_codecollection" class="OH_CodeSnippetContainerCodeCollection"><div class="OH_CodeSnippetToolBar"><div class="OH_CodeSnippetToolBarText"><a id="ID0ECAFAAAAA_ViewColorized" href="#" onclick="javascript:ExchangeTitleContent('ID0ECAFAAAAA','4')" title="View Colorized" style="display: none">View Colorized</a><a id="ID0ECAFAAAAA_copycode" href="#" onclick="javascript:CopyToClipboard('ID0ECAFAAAAA','4')" title="Copy to Clipboard">Copy to Clipboard</a><a id="ID0ECAFAAAAA_PrintText" class="OH_PrintText" href="#" onclick="javascript:Print('ID0ECAFAAAAA','4')" title="Print">Print</a></div></div><div id="ID0ECAFAAAAA_code_Div1" class="OH_CodeSnippetContainerCode" style="display: block"><pre><span class="keyword">public</span> <span class="keyword">class</span> <span class="identifier">AdoNetAppender</span> : <span class="identifier">BufferingAppenderSkeleton</span></pre></div><div id="ID0ECAFAAAAA_code_Plain_Div1" class="OH_CodeSnippetContainerCode" style="display: none"><pre>public class AdoNetAppender : BufferingAppenderSkeleton</pre></div><div id="ID0ECAFAAAAA_code_Div2" class="OH_CodeSnippetContainerCode" style="display: none"><pre><span class="keyword">Public</span> <span class="keyword">Class</span> <span class="identifier">AdoNetAppender</span> | |
| <span class="keyword">Inherits</span> <span class="identifier">BufferingAppenderSkeleton</span></pre></div><div id="ID0ECAFAAAAA_code_Plain_Div2" class="OH_CodeSnippetContainerCode" style="display: none"><pre>Public Class AdoNetAppender | |
| Inherits BufferingAppenderSkeleton</pre></div><div id="ID0ECAFAAAAA_code_Div3" class="OH_CodeSnippetContainerCode" style="display: none"><pre><span class="keyword">public</span> <span class="keyword">ref class</span> <span class="identifier">AdoNetAppender</span> : <span class="keyword">public</span> <span class="identifier">BufferingAppenderSkeleton</span></pre></div><div id="ID0ECAFAAAAA_code_Plain_Div3" class="OH_CodeSnippetContainerCode" style="display: none"><pre>public ref class AdoNetAppender : public BufferingAppenderSkeleton</pre></div><div id="ID0ECAFAAAAA_code_Div4" class="OH_CodeSnippetContainerCode" style="display: none"><pre /></div><div id="ID0ECAFAAAAA_code_Plain_Div4" class="OH_CodeSnippetContainerCode" style="display: none"><pre /></div></div></div><script>addSpecificTextLanguageTagSet('ID0ECAFAAAAA');</script></div><div class="OH_CollapsibleAreaRegion"><div class="OH_regiontitle">Remarks</div><div class="OH_CollapsibleArea_HrDiv"><hr class="OH_CollapsibleArea_Hr" /></div></div><div class="OH_clear"></div><p><span class="selflink">AdoNetAppender</span> appends logging events to a table within a | |
| database. The appender can be configured to specify the connection | |
| string by setting the <a href="P_log4net_Appender_AdoNetAppender_ConnectionString.htm" target="">ConnectionString</a> property. | |
| The connection type (provider) can be specified by setting the <a href="P_log4net_Appender_AdoNetAppender_ConnectionType.htm" target="">ConnectionType</a> | |
| property. For more information on database connection strings for | |
| your specific database see <img src="./../icons/online_icon.gif" class="OH_offlineIcon" alt="Online" title="Online" /><a href="http://www.connectionstrings.com/" target="_blank">http://www.connectionstrings.com/</a>. | |
| </p><p> | |
| Records are written into the database either using a prepared | |
| statement or a stored procedure. The <a href="P_log4net_Appender_AdoNetAppender_CommandType.htm" target="">CommandType</a> property | |
| is set to <img src="./../icons/online_icon.gif" class="OH_offlineIcon" alt="Online" title="Online" /><a href="http://msdn2.microsoft.com/en-us/library/3wsb5y07" target="_blank">Text</a> (<span class="code">System.Data.CommandType.Text</span>) to specify a prepared statement | |
| or to <img src="./../icons/online_icon.gif" class="OH_offlineIcon" alt="Online" title="Online" /><a href="http://msdn2.microsoft.com/en-us/library/3wsb5y07" target="_blank">StoredProcedure</a> (<span class="code">System.Data.CommandType.StoredProcedure</span>) to specify a stored | |
| procedure. | |
| </p><p> | |
| The prepared statement text or the name of the stored procedure | |
| must be set in the <a href="P_log4net_Appender_AdoNetAppender_CommandText.htm" target="">CommandText</a> property. | |
| </p><p> | |
| The prepared statement or stored procedure can take a number | |
| of parameters. Parameters are added using the <a href="M_log4net_Appender_AdoNetAppender_AddParameter.htm" target="">AddParameter(AdoNetAppenderParameter)</a> | |
| method. This adds a single <a href="T_log4net_Appender_AdoNetAppenderParameter.htm" target="">AdoNetAppenderParameter</a> to the | |
| ordered list of parameters. The <a href="T_log4net_Appender_AdoNetAppenderParameter.htm" target="">AdoNetAppenderParameter</a> | |
| type may be subclassed if required to provide database specific | |
| functionality. The <a href="T_log4net_Appender_AdoNetAppenderParameter.htm" target="">AdoNetAppenderParameter</a> specifies | |
| the parameter name, database type, size, and how the value should | |
| be generated using a <a href="T_log4net_Layout_ILayout.htm" target="">ILayout</a>. | |
| </p><div class="OH_CollapsibleAreaRegion"><div class="OH_regiontitle">Examples</div><div class="OH_CollapsibleArea_HrDiv"><hr class="OH_CollapsibleArea_Hr" /></div></div><div class="OH_clear"></div> | |
| An example of a SQL Server table that could be logged to: | |
| <div id="ID0EADAAAAA" class="OH_CodeSnippetContainer"><div class="OH_CodeSnippetContainerTabs" id="ID0EADAAAAA_tabs"><div class="OH_CodeSnippetContainerTabLeft" id="ID0EADAAAAA_tabimgleft"></div><div id="ID0EADAAAAA_tab1" class="OH_CodeSnippetContainerTabSolo" EnableCopyCode="true"><a xmlns="">SQL</a></div><div class="OH_CodeSnippetContainerTabRight" id="ID0EADAAAAA_tabimgright"></div></div><div id="ID0EADAAAAA_codecollection" class="OH_CodeSnippetContainerCodeCollection"><div class="OH_CodeSnippetToolBar"><div class="OH_CodeSnippetToolBarText"><a id="ID0EADAAAAA_ViewColorized" href="#" onclick="javascript:ExchangeTitleContent('ID0EADAAAAA','4')" title="View Colorized" style="display: none">View Colorized</a><a id="ID0EADAAAAA_copycode" href="#" onclick="javascript:CopyToClipboard('ID0EADAAAAA','4')" title="Copy to Clipboard">Copy to Clipboard</a><a id="ID0EADAAAAA_PrintText" class="OH_PrintText" href="#" onclick="javascript:Print('ID0EADAAAAA','4')" title="Print">Print</a></div></div><div id="ID0EADAAAAA_code_Div1" class="OH_CodeSnippetContainerCode" style="display: block"><pre><span class="highlight-keyword">CREATE</span> <span class="highlight-keyword">TABLE</span> [dbo].[Log] ( | |
| [ID] [int] <span class="highlight-keyword">IDENTITY</span> (<span class="highlight-number">1</span>, <span class="highlight-number">1</span>) <span class="highlight-keyword">NOT</span> <span class="highlight-keyword">NULL</span> , | |
| [Date] [datetime] <span class="highlight-keyword">NOT</span> <span class="highlight-keyword">NULL</span> , | |
| [Thread] [varchar] (<span class="highlight-number">255</span>) <span class="highlight-keyword">NOT</span> <span class="highlight-keyword">NULL</span> , | |
| [Level] [varchar] (<span class="highlight-number">20</span>) <span class="highlight-keyword">NOT</span> <span class="highlight-keyword">NULL</span> , | |
| [Logger] [varchar] (<span class="highlight-number">255</span>) <span class="highlight-keyword">NOT</span> <span class="highlight-keyword">NULL</span> , | |
| [Message] [varchar] (<span class="highlight-number">4000</span>) <span class="highlight-keyword">NOT</span> <span class="highlight-keyword">NULL</span> | |
| ) <span class="highlight-keyword">ON</span> [<span class="highlight-keyword">PRIMARY</span>]</pre></div><div id="ID0EADAAAAA_code_Plain_Div1" class="OH_CodeSnippetContainerCode" style="display: none"><pre>CREATE TABLE [dbo].[Log] ( | |
| [ID] [int] IDENTITY (1, 1) NOT NULL , | |
| [Date] [datetime] NOT NULL , | |
| [Thread] [varchar] (255) NOT NULL , | |
| [Level] [varchar] (20) NOT NULL , | |
| [Logger] [varchar] (255) NOT NULL , | |
| [Message] [varchar] (4000) NOT NULL | |
| ) ON [PRIMARY]</pre></div></div></div><script>addSpecificTextLanguageTagSet('ID0EADAAAAA');</script><div class="OH_CollapsibleAreaRegion"><div class="OH_regiontitle">Examples</div><div class="OH_CollapsibleArea_HrDiv"><hr class="OH_CollapsibleArea_Hr" /></div></div><div class="OH_clear"></div> | |
| An example configuration to log to the above table: | |
| <div id="ID0EACAAAAA" class="OH_CodeSnippetContainer"><div class="OH_CodeSnippetContainerTabs" id="ID0EACAAAAA_tabs"><div class="OH_CodeSnippetContainerTabLeft" id="ID0EACAAAAA_tabimgleft"></div><div id="ID0EACAAAAA_tab1" class="OH_CodeSnippetContainerTabSolo" EnableCopyCode="true"><a xmlns="">XML</a></div><div class="OH_CodeSnippetContainerTabRight" id="ID0EACAAAAA_tabimgright"></div></div><div id="ID0EACAAAAA_codecollection" class="OH_CodeSnippetContainerCodeCollection"><div class="OH_CodeSnippetToolBar"><div class="OH_CodeSnippetToolBarText"><a id="ID0EACAAAAA_ViewColorized" href="#" onclick="javascript:ExchangeTitleContent('ID0EACAAAAA','4')" title="View Colorized" style="display: none">View Colorized</a><a id="ID0EACAAAAA_copycode" href="#" onclick="javascript:CopyToClipboard('ID0EACAAAAA','4')" title="Copy to Clipboard">Copy to Clipboard</a><a id="ID0EACAAAAA_PrintText" class="OH_PrintText" href="#" onclick="javascript:Print('ID0EACAAAAA','4')" title="Print">Print</a></div></div><div id="ID0EACAAAAA_code_Div1" class="OH_CodeSnippetContainerCode" style="display: block"><pre><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">appender</span> <span class="highlight-xml-attribute-name">name</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"AdoNetAppender_SqlServer"</span> <span class="highlight-xml-attribute-name">type</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"log4net.Appender.AdoNetAppender"</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">connectionType</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">connectionString</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"data source=SQLSVR;initial catalog=test_log4net;integrated security=false;persist security info=True;User ID=sa;Password=sa"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">commandText</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message]) VALUES (@log_date, @thread, @log_level, @logger, @message)"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameterName</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"@log_date"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">dbType</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"DateTime"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">layout</span> <span class="highlight-xml-attribute-name">type</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"log4net.Layout.PatternLayout"</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"></</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameterName</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"@thread"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">dbType</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"String"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">size</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"255"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">layout</span> <span class="highlight-xml-attribute-name">type</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"log4net.Layout.PatternLayout"</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"%thread"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"></</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameterName</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"@log_level"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">dbType</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"String"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">size</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"50"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">layout</span> <span class="highlight-xml-attribute-name">type</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"log4net.Layout.PatternLayout"</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"%level"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"></</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameterName</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"@logger"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">dbType</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"String"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">size</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"255"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">layout</span> <span class="highlight-xml-attribute-name">type</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"log4net.Layout.PatternLayout"</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"%logger"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"></</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">parameterName</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"@message"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">dbType</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"String"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">size</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"4000"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"><</span><span class="highlight-xml-tag">layout</span> <span class="highlight-xml-attribute-name">type</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"log4net.Layout.PatternLayout"</span> <span class="highlight-xml-attribute-name">value</span><span class="highlight-xml-attribute-equal">=</span><span class="highlight-xml-attribute-value">"%message"</span> <span class="highlight-xml-bracket">/></span><span class="highlight-xml-bracket"></</span><span class="highlight-xml-tag">parameter</span><span class="highlight-xml-bracket">></span><span class="highlight-xml-bracket"></</span><span class="highlight-xml-tag">appender</span><span class="highlight-xml-bracket">></span></pre></div><div id="ID0EACAAAAA_code_Plain_Div1" class="OH_CodeSnippetContainerCode" style="display: none"><pre><appender name="AdoNetAppender_SqlServer" type="log4net.Appender.AdoNetAppender"><connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /><connectionString value="data source=SQLSVR;initial catalog=test_log4net;integrated security=false;persist security info=True;User ID=sa;Password=sa" /><commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message]) VALUES (@log_date, @thread, @log_level, @logger, @message)" /><parameter><parameterName value="@log_date" /><dbType value="DateTime" /><layout type="log4net.Layout.PatternLayout" value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" /></parameter><parameter><parameterName value="@thread" /><dbType value="String" /><size value="255" /><layout type="log4net.Layout.PatternLayout" value="%thread" /></parameter><parameter><parameterName value="@log_level" /><dbType value="String" /><size value="50" /><layout type="log4net.Layout.PatternLayout" value="%level" /></parameter><parameter><parameterName value="@logger" /><dbType value="String" /><size value="255" /><layout type="log4net.Layout.PatternLayout" value="%logger" /></parameter><parameter><parameterName value="@message" /><dbType value="String" /><size value="4000" /><layout type="log4net.Layout.PatternLayout" value="%message" /></parameter></appender></pre></div></div></div><script>addSpecificTextLanguageTagSet('ID0EACAAAAA');</script><a name="seeAlsoSection"><!----></a><div class="OH_CollapsibleAreaRegion"><div class="OH_regiontitle">See Also</div><div class="OH_CollapsibleArea_HrDiv"><hr class="OH_CollapsibleArea_Hr" /></div></div><div class="OH_clear"></div><div class="seeAlsoStyle"><a href="AllMembers_T_log4net_Appender_AdoNetAppender.htm" target="">AdoNetAppender Members</a></div><div class="seeAlsoStyle"><a href="N_log4net_Appender.htm" target="">log4net.Appender Namespace</a></div></div></div></div></div><div id="OH_footer" class="OH_footer"><p>Apache log4net, Apache and log4net are trademarks of The Apache Software Foundation.</p><p><a href="http://logging.apache.org/log4net/" target="_blank"><img src="./../icons/online_icon.gif" class="OH_offlineIcon" alt="Online" title="Online" /> | |
| Copyright 2004-2015 The Apache Software Foundation (http://logging.apache.org/log4net/)</a></p><div class="OH_feedbacklink"><a href="mailto:http://logging.apache.org/log4net/mail-lists.html?subject=Apache+log4net%e2%84%a2+SDK+Documentation+AdoNetAppender+Class+100+EN-US&body=Your%20feedback%20is%20used%20to%20improve%20the%20documentation%20and%20the%20product.%20Your%20e-mail%20address%20will%20not%20be%20used%20for%20any%20other%20purpose%20and%20is%20disposed%20of%20after%20the%20issue%20you%20report%20is%20resolved.%20While%20working%20to%20resolve%20the%20issue%20that%20you%20report%2c%20you%20may%20be%20contacted%20via%20e-mail%20to%20get%20further%20details%20or%20clarification%20on%20the%20feedback%20you%20sent.%20After%20the%20issue%20you%20report%20has%20been%20addressed%2c%20you%20may%20receive%20an%20e-mail%20to%20let%20you%20know%20that%20your%20feedback%20has%20been%20addressed.">Send Feedback</a> on this topic to http://logging.apache.org/log4net/mail-lists.html.</div></div></body></html> |