tailieunhanh - Professional ASP.NET 3.5 in C# and Visual Basic Part 66

Professional in C# and Visual Basic Part 66. Building on the revolutionary release, adds several key new developer features including AJAX, LINQ, and a new CSS designer in Visual Web Developer 2008. The dramatic reduction in code that developers realized from the more than 50 new server controls in now allows developers the time to make their applications more interactive with AJAX, to work with data in their preferred language with LINQ, and to build visually attractive and consistent standards-based sites with CSS. . | Chapter 12 Introduction to the Provider Model This single class for the personalization system inherits from the Profileprovider base class. This is illustrated in Figure 12-11. ProfiteProvider SqlProfileProvider Abstract Class 1 Class -i 5 ettinas Provider -J -r ProfileProvider Methods V DeietelnactivePropies V DeieteProfiies 1 overload A .no i ts uL tivizPrc f I -. sn- 4 FindPropiesByUserName V GetAfflnactiveProfiles V GetAiiProfites GeWamberOfinaetivePrsfiles ProfileProvider Figure 12-11 As with the other providers covered so far SqlProfileProvider connects to a Microsoft SQL Server Express Edition file by default. Although this is the default you can change the connection to work with either SQL Server 2000 2005 or 2008. For instance if you are connecting to a SQL Server 2005 database you define your connection in the and then associate your SqlProfileProvider declaration to this connection string. This scenario is presented in Listing 12-12. Listing 12-12 Connecting the SqlProfileProvider to SQL Server 2005 configuration connectionStrings add name LocalSql2005Server connectionString Data Source -Integrated Security SSPI connectionStrings profile providers clear add name AspNetSql2005ProfileProvider connectionStringName LocalSql2005Server applicationName type Version Culture neutral PublicKeyToken b03f5f7f11d50a3a providers Continued 607 Chapter 12 Introduction to the Provider Model properties add name add name add name add name add name properties profile FirstName LastName LastVisited Age Member configuration Remember that to store profile information in your SQL Server database you have to configure this database so the proper tables stored procedures and other items are created. This task was discussed earlier in the chapter. The SiteMap Provider Similar to the personalization provider just discussed provides a single provider to