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

GetDataTable question

Andria Jensen — Fri, 21 Jul 2006 09:21:16 GMT

I want to do something like DataLayer.DataSources("").GetDataTable("SELECT * FROM Table") instead of going through a BO. I just want a direct query on the database instead. When I try to do this, the GetDataTable requires another parameter...a callback to be passed to it. What is this parameter and what do I need to use here?

RE: GetDataTable question

StrataFrame Team — Fri, 21 Jul 2006 09:21:16 GMT

The callback that is passed is the callback that should be executed for Query Notification Services if the data changes on the server... when the business object is using the SqlDataSourceItem class, you can register query notifications with the server, and the callback is the method that should be called when a notification is received back from the server.

It's only valid for SQL Server 2005 when Query Notification Services is turned on.

RE: GetDataTable question

Trent L. Taylor — Fri, 21 Jul 2006 09:18:47 GMT

The callback method is for asynchronous access and is required based on the design of the data access layer. You really do not need to go to the DAL to get a random query from a database. In fact, this is not recommended since the DAL should never be touched by anything other than the business layer. If you place code in the UI that goes directly to the DAL, you have broken encapsulation and if you attempt to create any other type of front end this will cause issues for you.

All business objects have a GetDataTable method that does what you are trying to do. You do not have to pull data from the table that the BO represents. Also, an ADO.NET data table is returned from the query and you can do whatever you need with that table.