<Entity Name="LineItem">
<Properties>
<Property Name="Title" Type="System.String">Name</Property>
</Properties>
<Identifiers>
<Identifier Name="LineItemID" TypeName="System.Int32"/>
</Identifiers>
<Methods>
<Method Name="GetLineItemsForSalesOrder">
<Properties>
<Property Name="RdbCommandText" Type="System.String">
SELECT
sod.SalesOrderDetailID,
p.Name,
p.ProductNumber,
sod.CarrierTrackingNumber,
sod.OrderQty,
sod.UnitPrice,
sod.LineTotal
FROM
Sales.SalesOrderDetail sod
INNER JOIN Production.Product p
on sod.ProductID = p.ProductID
WHERE
sod.SalesOrderID = @salesorderID
</Property>
<Property Name="RdbCommandType" Type="System.String">Text</Property>
</Properties>
<Parameters>
<Parameter Direction="In" Name="@salesorderID">
<TypeDescriptor TypeName="System.Int32" Name="salesorderID"
IdentifierEntityName="SalesOrder"
IdentifierName="SalesOrderID">
<!-- Note that we don't have any default values for this. -->
</TypeDescriptor>
</Parameter>
<Parameter Direction="Return" Name="LineItems">
<TypeDescriptor TypeName="System.Data.IDataReader, System.Data,
Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
IsCollection="true" Name="LineItemDataReader">
<TypeDescriptors>
<TypeDescriptor TypeName="System.Data.IDataRecord, System.Data,
Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
Name="LineItemDataRecord">
<TypeDescriptors>
<TypeDescriptor TypeName="System.Int32"
IdentifierName="LineItemID"
Name="SalesOrderDetailID" />
<TypeDescriptor TypeName="System.String"
Name="Name" />
<TypeDescriptor TypeName="System.Int32"
Name="CarrierTrackingNumber" />
<TypeDescriptor TypeName="System.Int16"
Name="OrderQty" />
<TypeDescriptor TypeName="System.String"
Name="UnitPrice" />
<TypeDescriptor TypeName="System.String"
Name="LineTotal" />
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
<!-- Note that we have no finder or specific finder.
This is because we don't need the line item to show up
in anything other than a Related List Web Part. -->
</Method>
</Methods>
</Entity>
京公网安备 11010802021500号