LINQ to SQL Samples

ADO.NET Interop

• Connection Interop
  
• Transaction Interop
  

Advanced

• Dynamic query - Select
  
• Dynamic query - Where
  
• Dynamic query - OrderBy
  
• Dynamic query - Union
  
• Identity
  
• Nested in FROM
  

Conversion Operators

• AsEnumerable
  
• ToArray
  
• ToList
  
• ToDictionary
  

COUNT/SUM/MIN/MAX/AVG

• Count - Simple
  
• Count - Conditional
  
• Sum - Simple
  
• Sum - Mapped
  
• Min - Simple
  
• Min - Mapped
  
• Min - Elements
  
• Max - Simple
  
• Max - Mapped
  
• Max - Elements
  
• Average - Simple
  
• Average - Mapped
  
• Average - Elements
  

DataContext Functions

• CreateDatabase() and DeleteDatabase()
  
• DatabaseExists()
  
• SubmitChanges()
  
• CreateQuery()
  
• Log
  

Direct SQL

• SQL Query
  
• SQL Command
  

EXISTS/IN/ANY/ALL

• Any - Simple
  
• Any - Conditional
  
• All - Conditional
  

GROUP BY/HAVING

• GroupBy - Simple
  
• GroupBy - Max
  
• GroupBy - Min
  
• GroupBy - Average
  
• GroupBy - Sum
  
• GroupBy - Count
  
• GroupBy - Count - Conditional
  
• GroupBy - followed by Where
  
• GroupBy - Multiple Columns
  
• GroupBy - Expression
  

Inheritance

• Simple
  
• OfType
  
• IS
  
• CType
  
• Cast
  
• UseAsDefault
  
• Insert New Record