Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There's several things you need to do in your code. First, to be able to see the list of product inventory records, you need to select them as part of your GetProducts domain operation:</p> <pre><code>Public Function GetProducts() As IQueryable(Of ProductPM) Return From p As Product In Me.ObjectContext.Products.Include("ProductInventories") Select New ProductPM With {.ListPrice = p.ListPrice, .ModifiedDate = p.ModifiedDate, .Name = p.Name, .ProductID = p.ProductID, .ProductNumber = p.ProductNumber, .ProductInventory = From i In p.ProductInventories Select New ProductInventoryPM With { .Quantity = i.Quantity, .ProductID = p.ProductID } } End Function </code></pre> <p>That will get them showing in the second data grid.</p> <p>You'll also need to add a constructor to your ProductPM class that initialises the ProductInventory class:</p> <pre><code>Public Sub New() ProductInventory = New List(Of ProductInventoryPM) End Sub </code></pre> <p>The final issue is that the insert domain operations are being called in the wrong order. As far as I can tell, the best way to handle this is as follows:</p> <ol> <li><p>Create an empty Insert domain operation for the ProductInventoryPM object. No logic is required in it, but the method is required in order for the ProductInventoryPM object to be able to be added to the ProductPM's inventory collection.</p> <pre><code>Public Sub InsertProductInventory(ByVal ProductInventoryPM As ProductInventoryPM) End Sub </code></pre> <p>NOTE: If you want to be able to add new inventory records after you've created the product + initial inventory record, then you will need to add logic to this domain operation after all.</p></li> <li><p>Insert the inventory objects in the ProductPM's Insert domain operation. An advantage of this is that there's no need to call SaveChanges.</p> <pre><code>Public Sub InsertProduct(ByVal ProductPM As ProductPM) Dim Product As New Product Product.Name = ProductPM.Name Product.ProductNumber = ProductPM.ProductNumber Product.ListPrice = ProductPM.ListPrice Product.SellStartDate = DateTime.Now Product.ModifiedDate = DateTime.Now Product.SafetyStockLevel = 1000 Product.ReorderPoint = 700 Product.StandardCost = 0 Product.DaysToManufacture = 3 Product.rowguid = Guid.NewGuid() Me.ObjectContext.Products.AddObject(Product) Me.ChangeSet.Associate(ProductPM, Product, AddressOf UpdateProductPMKey) For Each ProductInventoryPM As ProductInventoryPM In ProductPM.ProductInventory Dim productInventory As New ProductInventory With productInventory .Bin = 1 .LocationID = 1 .ModifiedDate = DateTime.Now .ProductID = ProductInventoryPM.ProductID .Quantity = ProductInventoryPM.Quantity .Shelf = "A" End With Product.ProductInventories.Add(productInventory) Me.ChangeSet.Associate(ProductInventoryPM, productInventory, AddressOf UpdateProductInventoryKey) Next End Sub </code></pre></li> </ol> <p>Now if you run it, everything should work OK. Let me know how it goes.</p> <p>Chris</p>
    singulars
    1. This table or related slice is empty.
    1. POSilverlight PresentationModel contains a collection of another presentationModel
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChris Anderson
    1. USChris Anderson
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSilverlight PresentationModel contains a collection of another presentationModel
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COHi Chris, thank you so much. Actually what I have did is same as you, just having the issue with the insert statement. The ProductID is not updated before the InsertProductInventory statement.
      singulars
      1. PO
      1. USuser1262406
    2. COI've updated the answer with the rest of the solution. Hope this helps.
      singulars
      1. PO
      1. USChris Anderson
    3. COI'm now wondering whether the Product/Inventory relationship would be better marked as a composition, using the Composition attribute. This forces the insert domain operation calls to be in the right order, and probably makes more sense for this particular scenario. See this MSDN article for more info: http://msdn.microsoft.com/en-us/library/ee707346(VS.91).aspx
      singulars
      1. PO
      1. USChris Anderson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload