Lookup Tables in Webservice

I have 4 - 5 lookup tables in a SQL Server database. What's the best (or
recommended) way to read all these values into memory for my Web Service one
time, so I don't have to keep opening connections to the server and pulling
the same records across the network?

Advertisements

> I have 4 - 5 lookup tables in a SQL Server database. What's the best
> (or recommended) way to read all these values into memory for my Web
> Service one time, so I don't have to keep opening connections to the
> server and pulling the same records across the network?
>
> Thanks
>

Advertisements

"Brock Allen" <> wrote in message
news:...
> You can utilize the HttpContext.Current.Cache in your webservice.
>
> -Brock
> DevelopMentor
> http://staff.develop.com/ballen
>
>
>
>> I have 4 - 5 lookup tables in a SQL Server database. What's the best
>> (or recommended) way to read all these values into memory for my Web
>> Service one time, so I don't have to keep opening connections to the
>> server and pulling the same records across the network?
>>
>> Thanks
>>
>
>
>

Share This Page

Welcome to The Coding Forums!

Welcome to the Coding Forums, the place to chat about anything related to programming and coding languages.

Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. You'll be able to ask questions about coding or chat with the community and help others.
Sign up now!