A much smarter way to work with SQL.
Query-first is a visual studio extension for working intelligently with SQL in C# projects. Use the provided .sql template to develop your queries. When you save the file, Query-first runs your query, retrieves the schema and generates two classes and an interface: a wrapper class with methods Execute(), ExecuteScalar(), ExecuteNonQuery() etc, its corresponding interface, and a POCO encapsulating a line of results.
As such, your query stays intact in its own .sql file. It can be edited, validated and test-run "in-situ" with design-time mock inputs and intellisense for your tables and columns. For performance, it is compiled into your binary as a ManifestResourceStream. In your application code, running your query takes one line of code, and returns a POCO (or an IEnumerable of POCOs) with meaningful parameter and property names, so enabling intellisense for your input parameters and results. The interface and POCO are directly usable for unit testing.
The generated code stands alone. There is no runtime dll and no reflection. The only dependencies are System libraries. You can quietly forget about ADO : Command, Connection, Reader and parameter creation are all handled for you, with all the best practices baked in. At no point do you have to remember the name of a column, or its type, or its index in the reader. And you've absolutely nothing new to learn, provided you still remember how to write SQL :-)
The extension puts a command in your Tools menu that will run all queries in your application and regenerate all wrapper classes. As such, you can test all your queries without further effort, and changes in your database schema will directly produce compilation errors in your application. If the query is broken, the wrapper classes will not compile. If the query runs but your application code tries to access columns that are no longer present in the result, the error will point at the line in your code that tries to access the missing property.
Who would have thought that in 2016 you could do something original with ADO and a few hundred lines of code. Nonetheless, this seems to be a not-yet-explored approach to the database problem. This is an alpha version, and your comments would be very welcome. To use this tool, install the VSIX. Then use the provided QueryFirst template each time you want to create a query. Each time you save your .sql file, the wrapper and results classes will be regenerated.
QueryFirst needs a "design time connection string". This connection will be used to test-run your .sql and generate the wrapper. Create a "qfconfig.json" somewhere in your project or solution, file beside or above your .sql. The minimum qfconfig has one property: "defaultConnection":
Loading More data ...