Skip to content

Commit ee61ed6

Browse files
author
Erik L
committed
Replacing the provided web.config file with the required one for SQL Server integration
1 parent dc0447e commit ee61ed6

2 files changed

Lines changed: 22 additions & 292 deletions

File tree

‎BlogEngine/BlogEngine.NET/Web.Config‎

Lines changed: 22 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<?xml version="1.0" encoding="utf-8"?>
1+
<?xml version="1.0" encoding="utf-8"?>
22
<configuration>
33
<configSections>
44
<sectionGroup name="BlogEngine">
@@ -7,9 +7,10 @@
77
</sectionGroup>
88
</configSections>
99
<BlogEngine>
10-
<blogProvider defaultProvider="XmlBlogProvider" fileStoreProvider="XmlBlogProvider">
10+
<blogProvider defaultProvider="DbBlogProvider" fileStoreProvider="XmlBlogProvider">
1111
<providers>
1212
<add description="Xml Blog Provider" name="XmlBlogProvider" type="BlogEngine.Core.Providers.XmlBlogProvider, BlogEngine.Core" />
13+
<add connectionStringName="BlogEngine" description="Sql Database Provider" name="DbBlogProvider" type="BlogEngine.Core.Providers.DbBlogProvider, BlogEngine.Core" />
1314
</providers>
1415
</blogProvider>
1516
<blogFileSystemProvider defaultProvider="XmlBlogProvider">
@@ -18,6 +19,10 @@
1819
</providers>
1920
</blogFileSystemProvider>
2021
</BlogEngine>
22+
<connectionStrings>
23+
<clear />
24+
<add name="BlogEngine" connectionString="Server=.\SQLEXPRESS;Database=BlogEngine;Trusted_Connection=True;" providerName="System.Data.SqlClient" />
25+
</connectionStrings>
2126
<appSettings>
2227
<!-- Override default application settings here -->
2328
<!-- blog usage scenario: singleblog, multiusers or multiblogs -->
@@ -104,16 +109,18 @@
104109
<error statusCode="404" redirect="~/error404.aspx" />
105110
</customErrors>
106111
<!--<trust level="Medium"/>-->
107-
<membership defaultProvider="XmlMembershipProvider">
112+
<membership defaultProvider="DbMembershipProvider">
108113
<providers>
109114
<clear />
110115
<add name="XmlMembershipProvider" type="BlogEngine.Core.Providers.XmlMembershipProvider, BlogEngine.Core" description="XML membership provider" passwordFormat="Hashed" />
116+
<add name="DbMembershipProvider" type="BlogEngine.Core.Providers.DbMembershipProvider, BlogEngine.Core" passwordFormat="Hashed" connectionStringName="BlogEngine" />
111117
</providers>
112118
</membership>
113-
<roleManager defaultProvider="XmlRoleProvider" enabled="true" cacheRolesInCookie="false">
119+
<roleManager defaultProvider="DbRoleProvider" enabled="true" cacheRolesInCookie="false">
114120
<providers>
115121
<clear />
116122
<add name="XmlRoleProvider" type="BlogEngine.Core.Providers.XmlRoleProvider, BlogEngine.Core" description="XML role provider" />
123+
<add name="DbRoleProvider" type="BlogEngine.Core.Providers.DbRoleProvider, BlogEngine.Core" connectionStringName="BlogEngine" />
117124
</providers>
118125
</roleManager>
119126
<siteMap defaultProvider="PageSiteMap" enabled="true">
@@ -150,22 +157,13 @@
150157
<add verb="*" path="opml.axd" type="BlogEngine.Core.Web.HttpHandlers.OpmlHandler, BlogEngine.Core" validate="false" />
151158
<add verb="*" path="apml.axd" type="BlogEngine.Core.Web.HttpHandlers.Apml, BlogEngine.Core" validate="false" />
152159
<add verb="*" path="rsd.axd" type="BlogEngine.Core.Web.HttpHandlers.RsdHandler, BlogEngine.Core" validate="false" />
153-
<add verb="*" path="sioc.axd" type="BlogEngine.Core.Web.HttpHandlers.Sioc, BlogEngine.Core" validate="false" />
160+
<add verb="*" path="sioc.axd" type="BlogEngine.Core.Web.HttpHandlers.Sioc, BlogEngine.Core" validate="false" />
154161
<add verb="*" path="foaf*.axd" type="BlogEngine.Core.Web.HttpHandlers.Foaf, BlogEngine.Core" validate="false" />
155162
<add verb="*" path="*.htm" type="System.Web.StaticFileHandler" />
156163
</httpHandlers>
157164
</system.web>
158165
<system.webServer>
159-
<validation validateIntegratedModeConfiguration="false" />
160-
<!--
161-
Uncomment below to configure custom 404 error; if blog in subfolder,
162-
like "/blog", make sure path includes subfolder
163-
-->
164-
<!--<httpErrors existingResponse="Replace" errorMode="Custom">
165-
<remove statusCode="404" subStatusCode="-1" />
166-
<error statusCode="404" prefixLanguageFilePath="" path="/error404.aspx" responseMode="ExecuteURL" />
167-
</httpErrors>-->
168-
166+
<validation validateIntegratedModeConfiguration="false" />
169167
<!-- Enable the staticContent section below to add Expires headers to images for better performance.
170168
Some hosting providers does not allow the staticContent section to be set. -->
171169
<!--
@@ -205,11 +203,15 @@
205203
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
206204
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
207205

208-
209-
210-
211-
212-
<remove name="ExtensionlessUrlHandler-Integrated-4.0" /><remove name="OPTIONSVerbHandler" /><remove name="TRACEVerbHandler" /><add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="*" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" /></handlers>
206+
207+
208+
209+
210+
<remove name="ExtensionlessUrlHandler-Integrated-4.0" />
211+
<remove name="OPTIONSVerbHandler" />
212+
<remove name="TRACEVerbHandler" />
213+
<add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="*" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />
214+
</handlers>
213215
<!-- Enable the httpProtocol section below to manipulate some HTTP headers.
214216
Some hosting providers does not allow the httpProtocol section to be set. -->
215217
<!--

0 commit comments

Comments
 (0)