This print for content only-size & color not accurate 7" X 9-1/4" / casebound / malloy

Option

Meaning in Life

/code

Informs sqlmetal.exe to output results as C# code (or as VB, if you

set the /language flag)

/language

Specifies the language used to defined the generated types

/namespace

Specifies the namespace to define the generated types

By way of an example, the following command set will generate entity classes for each table

within the AutoLot database, expose the GetPetName stored procedure, and wrap all generated C#

code within a namespace named AutoLotDatabase (of course, this would be entered on a single line

within a Visual Studio 2008 command prompt):

sqlmetal /server:(local)\SQLEXPRESS /database:AutoLot /namespace:AutoLotDatabase

/code:autoLotDB.cs /sprocs

Once you have executed the command, create a new Console Application named

LinqWithSqlMetalGenedCode, reference the System.Data.Linq.dll assembly, and include the

autoLotDB.cs file into your project using the Project ➤ Add Existing Item menu option. As well,

insert a new class diagram into your project (via Project ➤ Add New Item) and expand each of the

generated classes (see Figure 24-4).