March 2008 - Posts
In this video Chris Pels demonstrates how to add, modify, and delete data in a database using LINQ to SQL entity mapping classes. The entity mapping classes are created using the sqlmetal.exe command line utility which is the “engine” behind the Object Relational Designer. These code based principles can be extended to complex data manipulation. This video is Part 3 in a four-part series of walkthroughs on LINQ to SQL.
Author: Chris Pels
In this video Chris Pels demonstrates how to create LINQ to SQL associations to represent foreign key relationships in the database. This video is code oriented rather than using the Object Relational Designer to demonstrate the fundamental principles of LINQ to SQL. This video is Part 2 in a four-part series of walkthroughs on LINQ to SQL.
Author: Chris Pels
In this video Chris Pels demonstrates a beginning-to-end LINQ to SQL scenario by creating a simple object model in LINQ to SQL using the entity mapping classes. Next, a LINQ query is written to list the customers in London for that object model. This video is code oriented rather than using the Object Relational Designer to demonstrate the fundamental principles of LINQ to SQL. This video is Part 1 in a four-part series of walkthroughs on LINQ to SQL.
Author: Chris Pels
In this video Chris Pels will demonstrate how to create entity classes representing SQL Server tables using the new object/relational designer (O/R Designer) in Visual Studio 2008. The entity classes will then be bound to a GridView on a web page using the new LINQ Data Source. In addition, learn how to write LINQ queries for the entity classes and bind the query to a user interface control like the GridView. Finally, learn how to create custom entity methods for control of operations like insert and update between the entity classes and database tables.
Author: Chris Pels
In this video Chris Pels demonstrates a beginning-to-end LINQ to SQL scenario for accessing data using the entity mapping classes and methods that are intermediaries to stored procedures in the database. The entity mapping classes are created using the sqlmetal.exe command line utility which is the “engine” behind the Object Relational Designer. The principles of stored procedure mapping and usage can be extended to other functionality like inserts, updates, and deletes. This video is Part 4 in a four-part series of walkthroughs on LINQ to SQL.
Author: Chris Pels
The video shows how to inherit from existing WinForms Controls to customize a particular behavior. Inheriting from Control is easy and an effective way to standardize your UI for validation and functionality across your organization.
Author: Pat Tormey
In this video Pat Tormey shows how to manage forms both as Multiple Document Interface (MDI) and Single Document Interface (SDI) with notes and tips for handling single and multiple instances, menus, and even a bit on the MDI for Template.
Author: Pat Tormey
The video shows how and why to use Partial Classes. The example uses a Partial Class as code behind a typed dataset to enforce data validation between two date columns.
Author: Pat Tormey www.4square.net