StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Business Object execute question...

Business Object execute question...

Robin J Giltner — Thu, 29 Mar 2007 16:12:51 GMT

I noticed that the methods on the Businessobjects for executescalar and executenonquery where marked as protected, and thus aren't available to my instantiated business objects in my applicaiton.

So I went in and made a public function to execute a sqlcommand parameter. Im guessing there is a good reason you didn't include these methods as public, but Im wondering what the reprocusions of my adding a method to execute a sqlcommand from the busniness object would be.

And btw, I've been getting a lot of errors when trying to use the forum, mainly when trying to list a forum from the forum main page.

Thanks,

Robin Giltner

RE: Business Object execute question...

Trent L. Taylor — Thu, 29 Mar 2007 16:12:51 GMT

No problem :)

RE: Business Object execute question...

Robin J Giltner — Thu, 29 Mar 2007 15:46:02 GMT

Whew, thats what I was hoping :-)

Thanks Trent.

Robin Giltner

RE: Business Object execute question...

Trent L. Taylor — Thu, 29 Mar 2007 15:29:03 GMT

[quote]Would using that method still work fine if the Middle Tier server were in play ?[/quote]

Yes. If you were using the Enterprise Server then your DAL would be an EnterpriseDataSourceItem instead of an SQLDataSourceItem which would properly interpret and relay all of the logic.

RE: Business Object execute question...

Robin J Giltner — Thu, 29 Mar 2007 15:12:51 GMT

I figured as much, and thats how I had been using the Data layer. Would using that method still work fine if the Middle Tier server were in play ?

Thanks,

Robin

RE: Business Object execute question...

Trent L. Taylor — Thu, 29 Mar 2007 15:08:44 GMT

[quote]And btw, I've been getting a lot of errors when trying to use the forum, mainly when trying to list a forum from the forum main page.[/quote]

:blush: sorry about this....we are talking with InstantASP trying to get this resolved. Apparently there are issues with the indexes be fragmented but not allowing rebuilds to correct the issue. We will add a post once this is corrected letting you know.

[quote]Im guessing there is a good reason you didn't include these methods as public, but Im wondering what the reprocusions of my adding a method to execute a sqlcommand from the busniness object would be.[/quote]

Yes. You are trying to access these methods on a BO outside of the BO itself. In this case just use the data access layer versus creating some method to illogically work around the protected definition.

[codesnippet]MicroFour.StrataFrame.Data.DataBasics.DataSources(0).ExecuteScalar(...)[/codesnippet]