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

// Identify the primary key.

[Column(IsPrimaryKey = true)]

public int CarID;

public override string ToString()

{

return string.Format("ID = {0}; Make = {1}; Color = {2}; PetName = {3}",

CarID, Make.Trim(), Color.Trim(), PetName.Trim());

}

}

First of all notice that our entity class has been adorned with the [Table] attribute, while each

public field has been marked with [Column]. In both cases, the names are a direct mapping to the

physical database table. However, this is not a strict requirement, as the TableAttribute and

ColumnAttribute types both support a Name property that allows you to decouple your program-

matic representation of the data table from the physical table itself. Also notice that the CarID field

has been further qualified by setting the IsPrimaryKey property of the ColumnAttribute type using

named property syntax.

Here, for simplicity, each field has been declared publicly. If you require stronger encapsula-

tion, you could most certainly define private fields wrapped by public properties (or automatic

properties if you so choose). If you do so, it will be the 

property, not the fields, that will be marked

with the [Column] attribute.

It is also worth pointing out that an entity class can contain any number of members that do

not map to the data table it represents. As far as the LINQ runtime is concerned, only items marked

with LINQ to SQL attributes will be used during the data exchange. For example, this Inventory

class definition provides a custom implementation of ToString() to allow the application to quickly

display its state.

Now that we have an entity class, we can make use of the DataContext type to submit (and

translate) our LINQ query expressions to the specified database. Ponder the following Main()

method, which will display the result of all items in the Inventory table maintained by the AutoLot

database:

class Program

{

const string cnStr =

@"Data Source=(local)\SQLEXPRESS;Initial Catalog=AutoLot;" +

"Integrated Security=True";

static void Main(string[] args)

{

Console.WriteLine("***** LINQ to SQL Sample App *****\n");