DotNet Architecture Question???

[Ryan Fiorini]

1. Every page of my site is going to have a menu at the top.
2. The menu is driven by XML stored in SQL.
3. Many of the pages in the body (in addition to the menu) will also need
this XML
4. I don't want to have to hit SQL twice to retrieve the XML (Once for the
Menu and twice for the rest of the page).
5. I am using Code Behind.

What is the best way to develop this?

Thanks,
Ryan

[Kevin Spencer]

Re: DotNet Architecture Question???

Assuming that your menu XML is globally the same in all pages, and that you
don't need to modify it on the fly, just store the data in your Application
Cache. That makes it globally available to all pages in the application.

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer

http://www.takempis.com

Big things are made up of
lots of Little things.

"Ryan Fiorini" <ryan.fiorini@m utualofamerica. com> wrote in message
news:%23A2%23Ou yODHA.2256@TK2M SFTNGP11.phx.gb l...[color=blue]
> 1. Every page of my site is going to have a menu at the top.
> 2. The menu is driven by XML stored in SQL.
> 3. Many of the pages in the body (in addition to the menu) will also need
> this XML
> 4. I don't want to have to hit SQL twice to retrieve the XML (Once for[/color]
the[color=blue]
> Menu and twice for the rest of the page).
> 5. I am using Code Behind.
>
> What is the best way to develop this?
>
> Thanks,
> Ryan
>
>[/color]

[alien2_51]

Re: DotNet Architecture Question???

Look into XML Transformations , this is a way you can filter your XML this
way you get the whole menu from the SQL server and filter it based on your
menuing needs..
"Ryan Fiorini" <ryan.fiorini@m utualofamerica. com> wrote in message
news:#A2#OuyODH A.2256@TK2MSFTN GP11.phx.gbl...[color=blue]
> 1. Every page of my site is going to have a menu at the top.
> 2. The menu is driven by XML stored in SQL.
> 3. Many of the pages in the body (in addition to the menu) will also need
> this XML
> 4. I don't want to have to hit SQL twice to retrieve the XML (Once for[/color]
the[color=blue]
> Menu and twice for the rest of the page).
> 5. I am using Code Behind.
>
> What is the best way to develop this?
>
> Thanks,
> Ryan
>
>[/color]