In this we’ll continue to discuss how to go about the SQL Server Data Access using various technologies. This post will discuss Microsoft Language Integrated Query, otherwise known as LINQ. I will discuss how it can be used to accomplish the same tasks we have discussed in previous posts. But before...

A very elegant way to achieve dynamic where and group clauses in LINQ queries.

NHibernate Query Analyzer is a tool to allow you to pick into the internal of NHibernate guts. The current feature set offers: * The ability to view the results from an HQL query in both tabular and object graph formats. * Support for lazy collections. * On the fly error checking fo...

By now, you have probably heard of LINQ. LINQ, as you probably know, stands for Language Integrated Query. The LINQ queries you build inside of C# or VB are baked into the .NET 3.5 framework. SubSonic takes a more traditional approach (right now) and uses the Query as an object. Instead of doing wei...

"Currently our Query tool is very useful, but it's sort of disconnected from the rest of the SubSonic Data tools. We're going to change all that with this next rev, and our goal is that you can intuitively work with the new Query tool as an extension of your object model if you like, or as a st...

In general, Subsonic is most productive when combining its code generation with its dynamic query engine and Active Record. But sometimes, your stuck with Stored Procedures and want to make the best of it. Subsonic, via the sonic.exe command line tool, can generate strongly typed stored procedure wr...

A 20 minute webcast that talks about the enhancements to the Query Tool.