2.4. Other LINQ to SQL Features

In this section we'll cover the following:

  • Using SQLMetal to produce entity classes and associations automatically

  • Using the INotifyPropertyChanging interface to communicate with LINQ about changes

  • Using the optimistic concurrency and database transactions

  • Using stored procedures

  • Creating a database from a program

2.4.1. SQLMetal

LINQ to SQL has a command-line tool called SQLMetal that generates entity classes, properties, and associations automatically. Table 2-3 lists the SQLMetal options.

Table 2-3. SQLMetal Generation Tool Options
OptionDescription
/server:<name>Represents the Microsoft SQL Server server name to which it connects.
/database:<name>Represents the Microsoft SQL Server database name to use to produce ...

Get LINQ for Visual C# 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial