c# - NHibernate unmapped table - object is a multicolumn type - ToListResultTransformer -

-

i have nhibernate executing raw sql query built database. in software use able choose table , couple of columns defined order. in software use information build sql query selects defined columns table , concatenates columns 1 column. here quick example.

the user defines wants select columns firstname und surname table user. build select statement:

select (firstname || surname) resultdata user

and try use select statement:

var list = session.createsqlquery(sqlquery)             .setresulttransformer(new nhibernate.transform.tolistresulttransformer())             .list();

but problem genericadoexception message

object multicolumn type

i didn't found on internet problem. thread accomplishs same task without error: nhibernate sql query mapping on single column result

yeah, found problem. no problem code rather database.

there columns have null values, , nhibernate didn't liked that.

firstname | surname ------------------- sam       | smith           | archer michael   | brown

i solved problem adjustment of sql satement. i'm using coalesce function.

the new sql statement:

select (coalesce(firstname, '') || coalesce(surname, '')) resultdata user

Comments

Post a Comment

Popular posts from this blog

javascript - How to diff two immutable objects -

-
is there way diff objects in immutable ? example: let = immutable.fromjs({ a: 10 }); let b = immutable.fromjs({ b: 10 }); let d = immutable.diff(a, b); // { a: 10 } console.log(d.tojs()); this useful when testing see how objects differ. it doesn't have show what's added/removed explicitly. want see properties a differs b can make them equal again. for example this: console.log(a.tojs()); console.log(b.tojs()); and check logs see differs b. in other thought might show both added , removed properties in same output. main point see not equal. so be: // { a: 10, b: 10 } console.log(d.tojs()); or maybe: // { added: { a: 10 }, removed: { b: 10 } } // console.log(d.tojs());
Read more

javascript - React.js: onClick function from child to parent -

-
i used this article example (react way), not working me. please point me mistake, can't understand what's wrong. this error see: uncaught typeerror: this.props.onclick not function here code: // parent var senddocmodal = react.createclass({ getinitialstate: function() { return {taglist: []}; }, render: function() { return ( <div> { this.state.taglist.map(function(item) { return ( <tagitem nameprop={item.name} idprop={item.id} onclick={this.handleremove}/> ) }) } </div> ) }, handleremove: function(c) { console.log('on remove = ', c); } }); // child var tagitem = react.createclass({ render: function() { return ( <span classname="react-tagsinput-tag"> <span>{this.props.nameprop}</span> <a classname='react-tagsinput-remove' onclick={this.handleremove}></a...
Read more

c# - How can I have the VS Debugger break in the correct location for exceptions thrown in Async methods in a Console App? -

-
i'm writing console app uses lots of async methods; i've made async main method can await in: static void main(string[] args) { mainasync(args).wait(); } static async task mainasync(string[] args) { // can use await here } however, when exception occurs; debugger break me on .wait() call. not experience. is there can debugger breaks exception occurs rather here? i'm using vs2015 , targeting .net 4.6 if influences answer.
Read more