I need to frequently extract data from a Dataset and would like it to be cashed.
But in Forum.vb - Dataset is intentionally by design, can not be declared.
So where and how please can I declare it while using the Cashing option?

Thanks
ADH

ADH

forgive me, but you want to cache a dataset from UI?

If you use TBH, you should implement your own code, but you should too follow theBeerHouse logic (3 layers:DAL->BLL->UI)

So, if you have a dataset on UI, this dataset was sent by BLL, and if you want to cache it you should do it before UI)

If you are talking about forums, you can do:

I hope it helped

I don't want to breach the 3 layer logic,
but TBH is conducting the cash from the Forums (or the Store class), so if I want to cash my Dataset there, I have to import System.data and breach the main logic.
I prefer to that by the DLL so the provider returns the BLL (the class) a list extracted from the dataset, but then I have no access to the cash.
Thanks


ADH

ADH - i don't know about vb. but in c# from the UI, you can call the BLL as follows:

string subTitle = BLL.Articles.Category.GetCategoryByID(Int32.Parse( catID)).Title;

or to get a collection of things:

BLL.Forums.Forum forum = BLL.Forums.Forum.GetForumByID(int.Parse(forumID));

not sure if this is what you need or not, but this 100% the way that i access cached data in the UI layer (excepting the aspx markup that references the objectdatasource of course).

jimi

http://www.originaltalent.com

jimi, you can call bll from UI.
But you can't run bll.baseforum.cachedata(....) form UI.

Unless you change COM

So what about a solution???
How to cash a dataset without breaking the BLL/DAL Syndrom??
ADH

You need to be more explicit!

From where you want to cache your dataset? From UI or from BLL ?

If it is from BLL the code for that is in my last post to this topic!

on a somewhat related idea (in my head anyway!), take a little look at this article which looks at offline merging of persisted data with your database. i've been looking for a good way to do this for quite some time and may look to create a couple of classes that generically handle this. anyway, here's the basic primer:

http://www.madprops.org/cs/blogs/mab...g-Changes.aspx

jimi

http://www.originaltalent.com

All the Cache is done in the BLL\...Base Classes (BaseForm.vb etc.) on purpose. So If I want to cache a Dataset I've to declare it in a BLL class But this a Data Set and it should be done only in the DAL -where I don't see a caching possibility (I can not "Inherits BizObject"). So no access to the cahe feature from the DAL.
How do I fix it?
(Sorry, but I was sure this was clear from the first place in my previous messages).
Thanks

ADH, in version 1, we had:

DAL : Fill the dataset
BLL : Retrieve Dataset from DAL
UI : Retrieve dataset from BLL

I think that you have something wrong on your code.
I'll try to explain you:
All the request are made from UI!
Without UI theres no need for BLL and DAL
So try to following this:
If you want to databind some gridview for example you'll make the call to BLL to retrieve some dataset/datatable/List!
ONLY if BLL don't find something cached, BBL will make the CALL to DAL retrieve this from DataBase.
If the dataset that UI want is in cache then BLL don't need to call DAL!
Understand?

So, when you call this Dataset firstTime from DAL to BLL cache it at this time in BLL!

In theBeerHouse you can see this! All the lists are called from Dal to BLL.
You should call your dataset from DAL to BLL to and cache it!

Maybe i don't understand what you really want!
If you want wright here your code... I really think that you are missing some steps!

Good luck!