Search code examples
connection-string

Password containing left angle bracket causing issues in web.config file asp.net

Hi I am trying to build a connectionstring in web.config file in MVC. Everything is fine except that I have to use autogenerated password and latest password has left angle bracket. When I am using this password containing left angle bracket, the connectionstring does not build correctly and I face failed connection. "Data Source=JungJu.database.windows.net;Initial Catalog=MainDb;User ID=FuntoGo;Password=OV_Xu2v8j2K$@~/<bI,A]d;Authentication=Active Directory Password

Solution

  • Replace it with

    &lt;

    is is the XML safe replacement for < (less than)