Skip to content

Instantly share code, notes, and snippets.

@steefjan
Created August 3, 2009 12:43
Show Gist options
  • Save steefjan/160528 to your computer and use it in GitHub Desktop.
Save steefjan/160528 to your computer and use it in GitHub Desktop.
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<system.serviceModel>
<bindings>
<sqlBinding>
<binding name="SqlAdapterBinding" closeTimeout="00:01:00" openTimeout="00:01:00"
receiveTimeout="00:10:00" sendTimeout="00:01:00" maxConnectionPoolSize="100"
encrypt="false" workstationId="" useAmbientTransaction="true"
batchSize="20" polledDataAvailableStatement="" pollingStatement=""
pollingIntervalInSeconds="30" pollWhileDataFound="false" notificationStatement=""
notifyOnListenerStart="true" enableBizTalkCompatibilityMode="true"
chunkSize="4194304" inboundOperationType="Polling" useDatabaseNameInXsdNamespace="false"
allowIdentityInsert="false" enablePerformanceCounters="false"
xmlStoredProcedureRootNodeName="" xmlStoredProcedureRootNodeNamespace="" />
</sqlBinding>
<oracleDBBinding>
<binding name="OracleDBBinding" closeTimeout="00:01:00" openTimeout="00:01:00"
receiveTimeout="00:10:00" sendTimeout="00:01:00" metadataPooling="true"
statementCachePurge="false" statementCacheSize="10" pollingInterval="500"
useOracleConnectionPool="true" minPoolSize="1" maxPoolSize="100"
incrPoolSize="5" decrPoolSize="1" connectionLifetime="0" acceptCredentialsInUri="false"
useAmbientTransaction="true" polledDataAvailableStatement="SELECT 1 FROM DUAL"
pollWhileDataFound="false" notifyOnListenerStart="true" notificationPort="-1"
inboundOperationType="Polling" dataFetchSize="65536" longDatatypeColumnSize="0"
skipNilNodes="true" maxOutputAssociativeArrayElements="32"
enableSafeTyping="false" insertBatchSize="1" useSchemaInNameSpace="true"
enableBizTalkCompatibilityMode="false" enablePerformanceCounters="false" />
</oracleDBBinding>
</bindings>
<client>
<endpoint address="mssql://win-v45bo6230qk//AdventureWorks2008?"
binding="sqlBinding" bindingConfiguration="SqlAdapterBinding"
contract="Procedures_dbo" name="SqlAdapterBinding_Procedures_dbo" />
<endpoint address="oracledb://win-v45bo6230qk:1521/XE/Dedicated"
binding="oracleDBBinding" bindingConfiguration="OracleDBBinding"
contract="HR_Table_EMPLOYEES" name="OracleDBBinding_HR_Table_EMPLOYEES" />
</client>
</system.serviceModel>
</configuration>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment