LINQ to SQL on Windows Phone 7.5: Listing 2.

The Review table.

public class Review : INotifyPropertyChanging {
  private string comment;
  private int movieId;
  private EntityRef<Movie> movie;

  [Column(IsPrimaryKey = true,
    IsDbGenerated = true,
    DbType = "INT NOT NULL Identity",
    CanBeNull = false,
    AutoSync = AutoSync.OnInsert)]
  public int ReviewId { get; set; }

  public string Comment {
    get { return comment; }
    set {
      if (comment == value) return;
      comment = value;

  public int MovieId {
    get { return movieId; }
    set {
      if (movieId == value) return;
      movieId = value;

  [Association(Storage = "movie", ThisKey = "MovieId", OtherKey = 
    "MovieId", IsForeignKey = true)]
  public Movie Movie {
    get { return movie.Entity; }
    set {
      Movie previousValue =;
      if (((previousValue != value)
          || (movie.HasLoadedOrAssignedValue == false))) {
          if ((previousValue != null)) {
            movie.Entity = null;
          movie.Entity = value;
          if ((value != null)) {
            movieId = value.MovieId;
          else {
            movieId = default(int);

  public event PropertyChangingEventHandler PropertyChanging;
  private void NotifyPropertyChanging(string propertyName) {
    if (PropertyChanging != null) {
      PropertyChanging(this, new PropertyChangingEventArgs(propertyName));

About the Author

Nick Randolph runs Built to Roam, a consulting company that specializes in training, mentoring and assisting other companies build mobile applications. With a heritage in rich client applications for both the desktop and a variety of mobile platforms, Nick currently presents, writes and educates on the Windows Phone platform.

comments powered by Disqus


  • VS Code Now Has Apple Silicon Builds for Native Mac Development

    Goodbye Rosetta, hello M1. Visual Studio Code has been updated with new builds that let it run natively on machines with Apple Silicon (M1), the company's own ARM64 chips.

  • Visual Studio 2019 for Mac v8.9 Ships with .NET 6 Preview 1 Support

    During its Ignite 2021 online event for IT pros and developers this week, Microsoft shipped Visual Studio 2019 for Mac v8.9, arriving with out-of-the-box support for .NET 6 Preview 1, which the company also released recently.

  • Analyst: TypeScript Now Firmly in Top 10 Echelon (Ruby, Not So Much)

    RedMonk analyst Stephen O'Grady believes TypeScript has achieved the rare feat of firmly ensconcing itself into the top 10 echelon of his ranking, now questioning how high it might go.

  • Black White Wave IMage

    Neural Regression Using PyTorch: Training

    The goal of a regression problem is to predict a single numeric value, for example, predicting the annual revenue of a new restaurant based on variables such as menu prices, number of tables, location and so on.

Upcoming Events