parsing t-sql parameterize query


the concentration i am now operative generates lot sql inline queries. generated sql following handed off database execution class. i wish parsing use information execution category take query this:



select field1, field2, field3 tablename where foo=1 bar="baz"


and spin something this:



select field1, field2, field3 tablename where foo=@p1 bar=@p2 blah blah blah


any thing already combined accomplish me c# vb.net? commanded stop opening before refactoring dal project.



update: guys i have vast concentration ported model asp asp.net literally thousands lines inline sql. wholly saving beauty generated sql handed off information execution class. i wish constraint sql before execution parameterize fly stop opening rewriting whole app.



Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members