Hey all, Ive been tasked to upgrade our existing extranet from .net 2.0 to 3.5.
One of the main issues i had during the build phase for the 2.0v was the data was coming from SQL server 2005 and a legacy db in Sybase 9. To achieve this i basically made to Dataset's accordingly based on SPROCS and a third DS to merge. This then would be the overall DS to use in the asp.net data binding sources. Phew ! Got there. This proved also to be eventually slow and cumbersome. This may have been to do with my SPROC design or even my DS design however it was not good.
I guess im looking for a good data cache model to follow to allow my existing asp.net grid views to look at this data. This cache model also has to be accessed not only from the asp.net extranet but from a windows application with alternative usage on the data cache. ie build crystal reports from the data.
Can anyone point me in the general idea? and or supply any links/ideas on how this can be accomplished.
kind regards