LINQ to SQL Samples (.NET Framework 3.5)
Retrieving Data
Learn how to perform basic select queries, filtering, and sorting using LINQ to SQL.
Features: Select, Where, OrderBy, Anonymous Types
Insert, Update, Delete
Explore how to insert new records, update existing ones, and delete data from your database.
Features: InsertOnSubmit, DeleteOnSubmit, SubmitChanges
Relational Data Access
Understand how to query across related tables using associations and join operations.
Features: Foreign Keys, Left Join, Inner Join
Executing Stored Procedures
Learn to call and execute stored procedures directly from your LINQ to SQL code.
Features: DataContext.ExecuteMethod, Mapped Stored Procedures
Advanced Techniques
Discover advanced patterns like subqueries, aggregate functions, and custom query logic.
Features: Group By, Count, Sum, Custom Methods
Efficient Data Handling
Understand best practices for managing the DataContext for optimal performance and resource usage.
Features: Object Tracking, Deferred Loading, Eager Loading