Can we see how to proceed when we have a change in our database? I mean if a new field is added what's the correct process to apply the change to LINQ?

Regards

My comment is more releated to the

.NET Framework 3.5 Enhancements Training Kit update for SP1

The first DD lab contains this line:

7. Apply the DisplayName attribute to the ProductNumber property. To do this, add the following code above the property definition.

[DisplayName(”Code”)]

private object ProductNumber { get; set; }

Unfortunately, DisplayName is not a viable attribute. It seems as this didn’t make it into the official sp1 release. It is sorely needed however, as everyone often has to give a column a “friendly name” instead of the straight-up database column name.

Can a future video show what can be used instead?

Thanks!

In any case, great videos! I have learned a lot.

Thanks

KevinK

For example, I have a Customers table that has separate columns for first and last names. It has a 1:M relationship with both Orders and Phones. In the default Dynamic Data website, the display field for the foreign key will be the first name column. That's obviously problematic, so what I would like is for the full name to be displayed instead.

At first, I thought I would need to play with the auto-generated templates or create a slew of custom pages. But it it's far easier than that...

In this use-case, all one needs to do is create a partial class for the table in question, add a public property to the class that exposes the desired information, and then use the DisplayColumn annotation (msdn.microsoft.com/ to the user-defined property.

Perhaps a series of mini-videos for data annotations are in order, or a reference to other tutorials where one finds more information about them (I imagine in ADO.NET Entity Services they appear a lot, though I haven't seen those yet) would be a good thing to include in subsequent videos!

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.DynamicData;

using System.ComponentModel.DataAnnotations;

/// <summary>

/// Summary description for Address

/// </summary>

///

[MetadataType(typeof(AddressMetadata))]

public partial class Address

{

}

public class AddressMetadata

{

[DisplayFormat(DataFormatString = "{0:MM-dd-yyyy}")]

public object DOB;

}

Keep do it!

Kinds Regards

Nikolay Panchev

Thank you for your assistance.