LINQ-SQL Nuggeting
- Posted in:
- Solution
On my recent project, I had to help my co-developer get an understanding of LINQ-SQL (Yes, I am aware that LINQ-SQL has been shelved by M$).
I remembered the brilliant MSDN Nuggets that were produced by the evangelist teams here in Microsoft UK. These were helpful short videos organised by tags based on technology/interests. They are even now hosted in MSDN UK web site. But, they have a search facility instead of the earlier tags/categories. I generally don't lend myself to searching on MSDN despite it insisting "live search" with green coloured attractions. So, felt a bit disappointed at the difficulty in locating nuggets for a specific technology/interest.
I just opted to view all the nuggets by Mike Taulty. Eventually picked up the list of nuggets for LINQ-SQL that might be of immediate help to my co-developer.
- Introduction to LINQ-SQL
- Understanding Data Context
- Mapping Schemas to Classes
- Inserting data
- Deleting
- Updating
- Joins with LINQ-SQL
- Working with NULLs
- Understanding When queries execute
- Deferred loading of related entities
- Querying wth Stored procs
- Updating with Stored Procs
- Transactions
Hope that helps my friend to get up to speed with this project.