Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

absolutely brilliant #10

Open
WinInsider opened this issue Oct 8, 2017 · 2 comments
Open

absolutely brilliant #10

WinInsider opened this issue Oct 8, 2017 · 2 comments

Comments

@WinInsider
Copy link

This is absolutely brilliant... ability to execute SQL outside DB engine is just what is needed to migrate monolithic/legacy SQL/Store Procs based system bit-by-bit into more modern era, running on CLR...

One question... is the query expression tree build from SQL able to run against IQueryable "data source" ("SQL Table" being IQueryable object)?

@terrajobst
Copy link
Owner

terrajobst commented Oct 11, 2017

That's a great suggestion, actually. When I wrote NQuery originally, VS 2005 was the new hotness, so IQueryable<T> wasn't a thing yet :-)

What are you hoping to get out of it? NQuery will be able to read anything that is based around IEnumerable<T>; I assume you'd like the ability to generate actual SQL to query a real DB?

@WinInsider
Copy link
Author

Would like to break large monolithic SQL code base into smaller pieces... and migrated into C# solution (bit-by-bit); however, can't rewrite all at once... hence... some parts of queries would remain in SQL (language), those queries would return IQueryable (say via NQuery); then C# could take over; add migrated/additional query logic (via LINQ)... and then, at the end, evaluate final IQueryable (via Entity Framework)...

Production of Expression Tree nodes that work with IQueryable (EF) is ideal outcome (and one that would require significant effort, come to think of it); however, may get mileage of IEnumerable too, in my scenario.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants