title: Good sophisticated linq to sql sample?
body: <p>I am looking for a more sophisticated way of using Linq to SQL. I am leaning L2Q but I am only seeing simple examples of business objects and simple CRUD operations in them.</p>
  
  <p>Any sample application that includes these:</p>
  
  <p>1- Business objects which get their data from more than 1 table and from many to many tables.</p>
  
  <p>2- Keeping track of  data changes and automatically be able to  make changes to more than one table in a simple operation. An intelligent SubmitChanges? (don't know if this possible - right now I write my own stored procs to do all the work plus I am desiging my database in a way so my use of Linq to SQL is easier!)</p>
  
  <p>3- Good use of relationships between tables. It should be more than just dragging tables into the designer.</p>
  
  <p>4- Transactions</p>
  
  <p>5- disconnected data. Use in ASP.NET.</p>
  
  <p>6- N-Tier architecture</p>
  
  <p>7- Basically, more sophisticated use of LINQ to SQL and learning good design patterns</p>
  
  <p>8- Skip Linq to SQL and move to Linq to Entities?</p>
  
  <p>I feel I am not taking good advantage of Linq and it's just giving me nice intellisense and easier queries and I feel it has a lot more to offer but not sure what and how.
  I am looking for real life sophisticated samples which can be a good source for learning above from what books and tutorials provide.</p>
  
  <p>Anything on CodePlex? Google code... etc?</p>