code snippets for "Populating entities from Stored Procedures with NHibernate"

s1.sql

ALTER PROCEDURE [dbo].[GetProductsByCategoryId]
    @CategoryId int
AS
BEGIN
    SET NOCOUNT ON;
  
    SELECT [ProductID]
          ,[ProductName]
          ,[SupplierID]
          ,[CategoryID]
          ,[QuantityPerUnit]
          ,[UnitPrice]
          ,[UnitsInStock]
          ,[UnitsOnOrder]
          ,[ReorderLevel]
          ,[Discontinued]
      FROM [Northwind].[dbo].[Products]
     WHERE [CategoryId] = @CategoryId
END

s2.xml

<sql-query name="GetProductsByCategoryId">
  <return class="Product" />
  exec dbo.GetProductsByCategoryId :CategoryId
</sql-query>

s3.cs

IQuery query = Session.GetNamedQuery("GetProductsByCategoryId");
query.SetInt32("CategoryId", 1);
IList<Product> products = query.List<Product>();

s4.xml

<sql-query name="GetProductsByCategoryId">
  <return class="Product">
    <return-property column="ProductID" name="Id" />
    <return-property column="ProductName" name="Name" />
    <return-property column="SupplierID" name="Supplier" />
    <return-property column="CategoryID" name="Category" />
    <return-property column="QuantityPerUnit" name="QuantityPerUnit" />
    <return-property column="UnitPrice" name="UnitPrice" />
    <return-property column="UnitsInStock" name="UnitsInStock" />
    <return-property column="UnitsOnOrder" name="UnitsOnOrder" />
    <return-property column="ReorderLevel" name="ReorderLevel" />
    <return-property column="Discontinued" name="Discontinued" />
  </return>
  exec dbo.GetProductsByCategoryId :CategoryId
</sql-query>