c# - Why does TableAdapter not recognize parameters in OFFSET and FETCH clauses? -
i using vs 2015 tableadapter query configuration wizard, , want run query pagination:
select * dbo_dev.v_details (agent_name = @agentname) order initiated_datetime desc offset (@pagesize * (@pagenumber - 1)) rows fetch next @pagesize rows
it whines "unable parse query text."
i did find a previous posting referencing problem vs 2012. states wizard can't recognize parameters outside of select , clauses. still case, or doing wrong?
as per previous post mentioned, appears broken , not being fixed in vs.
Comments
Post a Comment