StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Using a BusinessLayer to fill a specific BO

Using a BusinessLayer to fill a specific BO

Greg McGuffey — Tue, 30 Oct 2007 10:29:51 GMT

Can I use a generic BusinessLayer to fill a specific BO if the datatable in the BusinessLayer is filled in a way that the BO can handle?

I.e. I have a CustomersBO with these fields:

CustID
CustName

Then I instantiate a BusinessLayer and use FillDataTable with SQL like this:

[codesnippet]Dim bo As New BusinessLayer()
bo.FillDataTable("Select CustID, CustName From Customers")[/codesnippet]

Can I then do:

[codesnippet]CustomersBO.CopyDataFrom(bo,ClearAndFillFromCompleteTable)[/codesnippet]

RE: Using a BusinessLayer to fill a specific BO

Greg McGuffey — Tue, 30 Oct 2007 10:29:51 GMT

Thanks for the reply Ben. It is all making sense now. I haven't done much at the data layer directly, so I appreciate Paul's comments a lot!

RE: Using a BusinessLayer to fill a specific BO

StrataFrame Team — Tue, 30 Oct 2007 09:25:27 GMT

Paul's option is a good one and it does save the overhead of instantiating another business object.

But, a business object can store data that does not match it's strong-typed properties, so you could really use any business object and fill it. Just don't go trying to access those strong-typed properties that don't have a backing field, or you'll get a nice exception ;)

Using Paul's option is cleaner.

Oh, and there's also the CopyDataFrom() and MergeDataFrom() overloads that accept DataTable parameters if you won't want to use the Load method directly on the CurrentDataTable.

RE: Using a BusinessLayer to fill a specific BO

Greg McGuffey — Mon, 29 Oct 2007 23:09:59 GMT

That could work...and it saves the extra overhead of the BO. I'll try that. Thanks Paul!

RE: Using a BusinessLayer to fill a specific BO

Paul Chase — Mon, 29 Oct 2007 15:41:50 GMT

Greg,

I'm not sure what you a trying to do but why not something like this

Dim loTable As Data.DataTable

Fill the Data Table

loTable = MicroFour.StrataFrame.Data.DataBasics.DataSources("").GetDataTable("Select CustID, CustName From Customers", Nothing)

'Not sure if you need to clear it

CustomerBo.CurrentDataTable.Clear()

'Load the data from the Table

CustomerBo.CurrentDataTable.Load(loTable.CreateDataReader, Data.LoadOption.OverwriteChanges)

RE: Using a BusinessLayer to fill a specific BO

Greg McGuffey — Mon, 29 Oct 2007 11:10:50 GMT

bump...