StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » How to use BO.FillByPrimaryKey(Int64 (Long) Parameter Array)?

How to use BO.FillByPrimaryKey(Int64 (Long) Parameter Array)?

Edhy Rijo — Tue, 26 May 2009 07:21:07 GMT

I have a BO1 with some records, I need to fill another BO2 with the same records in BO1, I think that using the BO.FillByPrimaryKey(Int64 (Long) Parameter Array) may be a quick solution. Now I don't know how to code to create the Long parameter array needed for BO2.FillByPrimaryPK(), can somebody post some quick code on how to do this?

So far, I can enumerate the BO2 like this:

[codesnippet]
' Here I need to code to create the Parameter Array
For Each ItemsBO As bizTransactionItems In Me.BizTransactionItems1.GetEnumerable
' Here I need the code to increment the Parameter Array

Next

' BO.FillByPrimaryKey(Int64 (Long) Parameter Array)
[/codesnippet]

Thanks!

RE: How to use BO.FillByPrimaryKey(Int64 (Long) Parameter Array)?

Trent L. Taylor — Tue, 26 May 2009 07:21:07 GMT

Cool :cool:

RE: How to use BO.FillByPrimaryKey(Int64 (Long) Parameter Array)?

Edhy Rijo — Tue, 26 May 2009 07:13:18 GMT

[quote][b]Trent L. Taylor (05/26/2009)[/b][hr]Let me know if this is not what you were getting at.[/quote]
Thanks, that is exactly what I was looking for.

RE: How to use BO.FillByPrimaryKey(Int64 (Long) Parameter Array)?

Trent L. Taylor — Tue, 26 May 2009 07:10:56 GMT

You will just need to create a collection of PKs. The easiest way is to create a generic List(Of Long) and then ToArray it. I would look something like this.

[codesnippet]
Dim pks As New System.Collections.Generic.List(Of Long)

For Each bo As BO1 in BO1.GetEnumerable()
pks.Add(bo.MyPk)
Next

BO2.FillByPrimaryKey(pks.ToArray())

[/codesnippet]

Let me know if this is not what you were getting at.