<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="data_layer" namespace="data_layer"> <sql-query name="sp_retrieveAllProductList"> <return-scalar column="Produkt" type="string" /> <return-scalar column="Produkt_kategori" type="string" /> <return-scalar column="btn_namn" type="string" /> exec sp_retrieveAllProductList :Produkt_kategori </sql-query> </hibernate-mapping>
public IList<Product4> RetrieveAllProductWithPriceNameAndBtn() { return _session.GetNamedQuery("sp_retrieveAllProductList2") .SetResultTransformer(Transformers.AliasToBean(typeof(Product4))) .List<Product4>(); }
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace data_layer { public class Product4 { public virtual string PK_produkt { get; set; } public virtual string Produkt { get; set; } public virtual string Produkt_kostnad { get; set; } public virtual string btn_namn { get; set; } } }
IList<string> names = Session.CreateSQLQuery("EXEC sp_retrieveAllProductList2") .List<string>();
Session .CreateSQLQuery(sql) .UniqueResult<string>();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)