Table-value functions and NHibernate

Question

I would like to create some table-value functions in SQL Server and use them from NHibernate 3 (I'm using Fluent NHibernate). What is the best way to do it? In most cases returned data will contain reference to another table and no column which can by used as primary key

Gert Arnold · Accepted Answer · 2011-11-12 19:21:07Z

1

You can give named queries a try (I say try because I must admit I never did this, but I worked with named queries).

In your case it should be a sql-query with the UDF addressed as dbo.[function name] and their must be a class in your mappings to use for the result set.

answered Nov 12, 2011 at 19:21

Gert Arnold

110k36 gold badges218 silver badges319 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Table-value functions and NHibernate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related