The Agile School

We can convert the relational data stored in the table into XML by using the FOR XML syntax, I am not going to the explain all the features of FOR XML. Physical table SELECT * FROM ASPNET_Roles FOR XML AUTO , ROOT ( 'A' ), ELEMENTS this select statement will give the following output < A > < URR_ASPNET_Roles > < ApplicationId > AFFE3DDD-ABAD-49DF-A144-DA87BE69B90E </ ApplicationId > < RoleId > 89C306A6-2D21-42AB-A42F-5029091CB4E8 </ RoleId > < RoleName > SBU User </ RoleName > < LoweredRoleName > sbu user </ LoweredRoleName > < USER_TYPE > 2 </ USER_TYPE > </ URR_ASPNET_Roles > < URR_ASPNET_Roles > < ApplicationId > AFFE3DDD-ABAD-49DF-A144-DA87BE69B90E </ ApplicationId > < RoleId > 180BA05D-D2A5-49CA-BED3-3C6F080F6543 </ RoleId > < RoleName > Super User </ RoleName > < LoweredRoleName > super user </ LoweredRoleName > < USER_TYPE

Why applicationName ? applicationName is provided so as to enable us to map different applications to same database this is a sample configuration for the ASP.net 2.0 Roles <roleManager> <providers> <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version= 2.0.0.0 , Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version= 2.0.0.0 , Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> </providers> you develop the site using all the advanced features its works perfectly but when the site is exported / published on another server, these features wont work !!!! The problem when we are using the 2.0 features asp.net automatically uses the virtual root folder name

Use vb & C# classes in same application (web app) In our application we mainly use only one type of class files say Vb or C#. what if we want to use two or more different language files in one web app ? in app_code create two folders , let say vb & cs, and place the corresponding class files into it add this piece of code to your web.config < compilation debug = " true " strict = " false " explicit = " true " > < codeSubDirectories > < add directoryName = " vb " /> < add directoryName = " cs " /> </ codeSubDirectories > </ compilation > you can use any folder name instead of VB or CS, the .Net compiler will look into each folder and try to compile all the class files found. But if it finds more than one different language files it throws an exception. the above piece of code will direct the compiler to check additional folders in App_code for class files for compilation.