Fluent NHibernate to query stored procedure without an hbm.xml mapping

stored-procedures fluent-nhibernate-mapping
rahul picture rahul · May 7, 2013 · Viewed 14.5k times · Source

Is there any way to query stored procedure in Fluent Nhibernate without creating an hbm.xml file mapping?

Answer

icepicker picture icepicker · Jul 15, 2013

I assume you use the standard

Session.GetNamedQuery(....

instead, you can use

var result = Session.CreateSQLQuery("exec MyStoredProc :pUserId, :pIsLocked")
                    .AddEntity(typeof(MyDomainObject))
                    .SetParameter("pUserId", userId)
                    .SetParameter("pIsLocked", isLocked)
                    .List<MyDomainObject>();

This allows you to call the stored proc but still get back a domain object (or list of) without needing a .hbm.xml file.

Actually there's this post

Related questions

Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More
Search text in stored procedure in SQL Server

I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_…

Read More
SQL Server - SELECT FROM stored procedure

I have a stored procedure that returns rows: CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END My actual procedure is a little more complicated, which is why a sproc is necessary. Is it possible to select the output by …

Read More