StrataFrame Forum

SQL View performance question with BO

http://forum.strataframe.net/Topic21774.aspx

By Ross L. Rooker, Sr. - 2/2/2009

I have a SQL VIEW which joins multiple tables. Created a SF BO based on the view. Then a Custom BBS. Then a user control to fire off a Sharpshooter report. There are parameters on the user control and a button the user clicks to then run the report. The click event of the button does a SELECT with a WHERE clause to narrow down the data. My question is to confirm whether the SF Framework is waiting until I issue the SELECT to fill the BO, or does it fill it automatically initially with all the data and then refill it when I issue the SELECT.?

Like in FoxPro you could use a view with NODATA returned until you actual fill the view.

By Greg McGuffey - 2/2/2009

BO have no automatic mechanism to fill them (though there are some standard fill methods like FillByPrimaryKey, FillByParent, etc). This is because the BO is disconnected from the table(s)/view(s)/sproc(s) that actually get the data. There is no way for it to know how you might like to fill it. So, the only way it would ever get filled is if some code of yours actually fills it.



Hope that makes sense.
By Ross L. Rooker, Sr. - 2/2/2009

Thanks for your quick response.