Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>Most of my production web.config. I've taken out all the company specific stuff... Also this config was setup for MVC4/EF5/OData 5.2 with IIS compression. Pretty complicated stuff...most of it won't be required. But I figured you wanted my raw config for reference.</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;configuration&gt; &lt;configSections&gt; &lt;!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --&gt; &lt;section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.4.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /&gt; &lt;section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" /&gt; &lt;sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" &gt; &lt;section name="EdgeService.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /&gt; &lt;/sectionGroup&gt; &lt;/configSections&gt; &lt;appSettings&gt; &lt;add key="log4net.Config.Watch" value="True" /&gt; &lt;add key="log4net.Config" value="EdgeService.log4net.config" /&gt; &lt;add key="PullVersionPeriod" value="30000" /&gt; &lt;add key="webpages:Version" value="2.0.0.0" /&gt; &lt;add key="webpages:Enabled" value="false" /&gt; &lt;add key="PreserveLoginUrl" value="true" /&gt; &lt;add key="ClientValidationEnabled" value="true" /&gt; &lt;add key="UnobtrusiveJavaScriptEnabled" value="true" /&gt; &lt;/appSettings&gt; &lt;system.web&gt; &lt;httpRuntime maxRequestLength="12288" maxUrlLength="10999" maxQueryStringLength="2097151"/&gt; &lt;compilation debug="true" targetFramework="4.5"&gt; &lt;assemblies&gt; &lt;add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt; &lt;add assembly="System.Web.Abstractions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/&gt; &lt;add assembly="System.Web.Routing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/&gt; &lt;add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/&gt; &lt;add assembly="System.Web.Mvc, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /&gt; &lt;add assembly="System.Web.Helpers" /&gt; &lt;/assemblies&gt; &lt;/compilation&gt; &lt;authentication mode="Windows" /&gt; &lt;pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID" /&gt; &lt;/system.web&gt; &lt;system.data&gt; &lt;DbProviderFactories&gt; &lt;clear /&gt; &lt;add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description="ADO.Net driver for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.5.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /&gt; &lt;/DbProviderFactories&gt; &lt;/system.data&gt; &lt;system.serviceModel&gt; &lt;serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="false" /&gt; &lt;/system.serviceModel&gt; &lt;system.webServer&gt; &lt;handlers&gt; &lt;remove name="svc-Integrated-4.0" /&gt; &lt;remove name="WebDAV" /&gt; &lt;remove name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" /&gt; &lt;remove name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" /&gt; &lt;remove name="ExtensionlessUrlHandler-Integrated-4.0" /&gt; &lt;add name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /&gt; &lt;add name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /&gt; &lt;add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" /&gt; &lt;/handlers&gt; &lt;modules runAllManagedModulesForAllRequests="true"&gt; &lt;remove name="WebDAVModule" /&gt; &lt;add name="PerRequestLifestyle" type="Castle.MicroKernel.Lifestyle.PerWebRequestLifestyleModule, Castle.Windsor" /&gt; &lt;/modules&gt; &lt;security&gt; &lt;requestFiltering&gt; &lt;requestLimits maxQueryString="100000" /&gt; &lt;/requestFiltering&gt; &lt;authentication&gt; &lt;!--C:\Windows\System32\inetsrv\config\applicationHost.config--&gt; &lt;anonymousAuthentication enabled="false" /&gt; &lt;windowsAuthentication enabled="true"&gt; &lt;providers&gt; &lt;clear /&gt; &lt;add value="Negotiate" /&gt; &lt;/providers&gt; &lt;/windowsAuthentication&gt; &lt;/authentication&gt; &lt;/security&gt; &lt;httpCompression&gt; &lt;scheme name="gzip" dll="%Windir%\system32\inetsrv\gzip.dll" staticCompressionLevel="9" dynamicCompressionLevel="4" /&gt; &lt;dynamicTypes&gt; &lt;add enabled="true" mimeType="Application/*" /&gt; &lt;add enabled="true" mimeType="application/atom+xml;type=feed;charset=utf-8" /&gt; &lt;/dynamicTypes&gt; &lt;/httpCompression&gt; &lt;/system.webServer&gt; &lt;runtime&gt; &lt;assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"&gt; &lt;dependentAssembly&gt; &lt;assemblyIdentity name="MySql.Data" publicKeyToken="C5687FC88969C44D" culture="neutral" /&gt; &lt;bindingRedirect oldVersion="0.0.0.0-6.6.4.0" newVersion="6.6.4.0" /&gt; &lt;/dependentAssembly&gt; &lt;dependentAssembly&gt; &lt;assemblyIdentity name="MySql.Data.Entity" publicKeyToken="c5687fc88969c44d" culture="neutral" /&gt; &lt;bindingRedirect oldVersion="0.0.0.0-6.6.4.0" newVersion="6.6.4.0" /&gt; &lt;/dependentAssembly&gt; &lt;dependentAssembly&gt; &lt;assemblyIdentity name="MySql.Web" publicKeyToken="c5687fc88969c44d" culture="neutral" /&gt; &lt;bindingRedirect oldVersion="0.0.0.0-6.6.4.0" newVersion="6.6.4.0" /&gt; &lt;/dependentAssembly&gt; &lt;dependentAssembly&gt; &lt;assemblyIdentity name="EntityFramework" publicKeyToken="b77a5c561934e089" culture="neutral" /&gt; &lt;bindingRedirect oldVersion="0.0.0.0-4.4.0.0" newVersion="5.0.0.0" /&gt; &lt;/dependentAssembly&gt; &lt;dependentAssembly&gt; &lt;assemblyIdentity name="Microsoft.Data.Edm" publicKeyToken="31bf3856ad364e35" culture="neutral" /&gt; &lt;bindingRedirect oldVersion="0.0.0.0-5.2.0.0" newVersion="5.2.0.0" /&gt; &lt;/dependentAssembly&gt; &lt;dependentAssembly&gt; &lt;assemblyIdentity name="Microsoft.Data.OData" publicKeyToken="31bf3856ad364e35" culture="neutral" /&gt; &lt;bindingRedirect oldVersion="0.0.0.0-5.2.0.0" newVersion="5.2.0.0" /&gt; &lt;/dependentAssembly&gt; &lt;dependentAssembly&gt; &lt;assemblyIdentity name="System.Spatial" publicKeyToken="31bf3856ad364e35" culture="neutral" /&gt; &lt;bindingRedirect oldVersion="0.0.0.0-5.2.0.0" newVersion="5.2.0.0" /&gt; &lt;/dependentAssembly&gt; &lt;/assemblyBinding&gt; &lt;/runtime&gt; &lt;/configuration&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload