NHibernate sql query without map one column one row

Question

I have a settings table without a primary key that I want to be able to select one column/one row from without any mappings.

How can I do this?

Radim Köhler · Accepted Answer · 2015-08-19 12:12:19Z

1

We can still use raw SQL (underlying DB Engine related):

var session = ... ; // standard session, with access to other mapped stuff
var sql = "SELECT settingCol FROM dbo.myTable WHERE ... ";
var result = session
    .CreateSQLQuery(sql)
    .UniqueResult<string>(); // or <int>

and work with that result without being mapped to any entity. Check the

17.1. Using an ISQLQuery

answered Aug 19, 2015 at 12:12

Radim Köhler

124k48 gold badges243 silver badges343 bronze badges

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

2 Comments

Jakob Over a year ago

Thank you, I had a solution but it was less elegant, thank you :)

Radim Köhler Over a year ago

Great if that helped anyhow ;) Enjoy mighty NHibernate, sir

Collectives™ on Stack Overflow

NHibernate sql query without map one column one row

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related