Notes

Motivation

I was wanting to evaluate Linq to LLBLGen but there was no working example code anywhere including here: LLBLGen Example projects nor was there any example of a enquiry/search screen with conditional filtering with even the normal LLBLGen query API. The only one I could find was in Joseph Chancellor's book. I come across an example of Dynamic Predicate Construction with LINQ to SQL on code project here: LINQ and Dynamic Predicate Construction at Run-time. I decided to combine the two.

AdventureWorks links:

• Adventure Works Cycles Business Scenarios
• Analysis of the AdventureWorks sample database by Wilson Mar
• Microsoft SQL Server Community Projects & Samples
• adventureworks2008r2
• adventureworks2008r2
• adventureworks 2005 Orig
• AdventureWorks Data Dictionary 2008
• AdventureWorks Data Dictionary 2005 Orig

Other AdventureWorks samples:

• AdventureWorks Data Binding sample demonstrates data binding that uses the Entity Framework
• Linq to SQL, WPF and AdventureWorksLT:AdventureWorks.WPF (Part 1)
• ASP.NET MVC3 EF 4

AdventureWorks Inheritance Hierarchies

Target Per Entity (Table Per Type - TPT) Sales and Individual descend from Customer. Target Per Entity Hierarchy (Table Per Hierarchy - TPH) PurchaseOrderHistory, SalesOrderHistory and WorkOrderHistory descend from TransactionHistory with a TransactionType as the discriminator column, TransactionHistory is abstract.

Northwind Samples:

• MVC Techniques with JQuery, JSON, Knockout and C#
• Northwind Starter Kit
• Northwind.NET