Introduction
Today I was working on Entity Framework and trying to add the connection string to the Web. Config to specify the database. I wrote the connection string like this:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="SQLConnect"
connectionString="Data Source=SAHIL; Initial Catalog=Demo; Integrated Security=SSPI"
providerName="System.Data.SqlClient" />
</connectionStrings>
<configSections>
<sectionnamesectionname="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework,
Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
:
:
:
:
:
:
:
</configuration>
When I ran the application, I experienced a strange error that says: "Only one <configSections> element allowed. It must be the first child element of the root <configuration> element".
It took me some time to determine the cause of the error and how to fix it.
Error
"Only one <configSections> element allowed. It must be the first child element of the root <configuration> element".
If you read the error carefully, it states that only one <configSections> element is allowed inside the Web.config, and it should be the first child element and placed at the top. The reason for the error is that I accidentally placed the <connectionStrings></connectionStrings> at the top over the <configSections></configSections> and by conventions, this is a violation. So, to fix the error, I rearranged the elements and the error was fixed.
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<sectionnamesectionname="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework,
Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<connectionStrings>
<add name="SQLConnect"
connectionString="Data Source=SAHIL; Initial Catalog=Demo; Integrated Security=SSPI"
providerName="System.Data.SqlClient" />
</connectionStrings>
:
:
:
:
:
:
:
</configuration>
Conclusion
Your feedback and constructive criticism is always appreciated, keep it coming. Until then try to put a ding in the Universe.