Select top using NHibernate custom dialect to OpenEdge database does not work -


In order to be able to use NHibernate with the progress / openage database on ODBC, I have created a custom bid

  SELECT TOP? SomeColumn to SomeTable where SomeColumn =?; P0 = 100, p1 = 'test'   

The progress / open database does not support it, so I would like to make some changes to the bid for which the statement does not use the parameter Forcing the amount of columns in SELECT TOP -

  SELECT TOP 100 SomeColumn table where someColumn = ?; P0 = 'test'   

Is this possible?

By the way, I am using NHibernate v. Looking at 3.3.1 I

I would say that you have a false You must override the supportVariableLimit property to return.

  /// & lt; Summary & gt; /// What parameters can be used for a statement for a limit? /// & lt; / Summary & gt; Public override supports Bull VarianableLimit {get {return false; Unfortunately, NHibernate Linq does not use the  SupportsVariableLimit  property. It always tries to use the parameters.  

With a source code fix here

Comments

Popular posts from this blog

java - NullPointerException for a 2d Array -

python - Assemble mpeg file unable to play in mediaplayer -

c# - NameSpace Manager or XsltContent to parse aspx page -