SQLGeneration

SQLGeneration copied to clipboard

for T-SQL, Offset and Fetch are often used for paging. ``` Select blah from blah order by blah OFFSET((@pageNumber - 1) * @pageSize) ROWS FETCH NEXT @pageSize ROWS ONLY; ```...

dazinator

Tried to use CommandBuilder.GetCommand to load an initial SQL string containing WITH clauses. Fails with InvalidOperationException in method buildStart.

kwaclaw

numericLiteral is always integer

1

when using: builder.AddProjection(new Function("AVG", new Multiplication(new NumericLiteral(1.0), new Column("col1"))), metric); i'm getting : SELECT AVG((1 \* col1)) instead of : SELECT AVG((1.0 \* col1))

marnun

The parser is not able to handle CAST

2

Hello again, Another simple query is not being properly handled by the parser. | Original Query | Output query | | --- | --- | | SELECT CAST('1' AS FLOAT)...

victorsantoss

kobynet

I am thinking that this project may be able to be changed to be a Portable Class Library but I haven;t investigated it a great deal. If it could then...

dazinator

Parsing multiple statements

4

Hey - long time no speak :) I was wondering if you have any thoughts around how to parse a SQL string that has multiple inidividual statements? For example -...

dazinator