StrataFrame Forum

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

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

By Edhy Rijo - 5/22/2009

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:





' 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)





Thanks!
By Trent L. Taylor - 5/26/2009

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.





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())







Let me know if this is not what you were getting at.
By Edhy Rijo - 5/26/2009

Trent L. Taylor (05/26/2009)
Let me know if this is not what you were getting at.


Thanks, that is exactly what I was looking for.
By Trent L. Taylor - 5/26/2009

Cool Cool