LINQ to SQL on Windows Phone 7.5: Listing 1.

Creating the Movie Class.

using System.ComponentModel;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Linq;
using Microsoft.Phone.Data.Linq;

public class Movie:INotifyPropertyChanging {
  private string name;
  private int year;
  private string synopsis;

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

  public string Name {
    get { return name; }
    set {
      if (name == value) return;
      name = value;

  public int Year {
    get { return year; }
    set {
      if (Year == value) return;
      year = value;

  public string Synopsis {
    get { return synopsis; }
    set {
      if (Synopsis == value) return;
      synopsis = value;
  public event PropertyChangingEventHandler PropertyChanging;
  private void NotifyPropertyChanging(string propertyName) {
    if (PropertyChanging != null) {
      PropertyChanging(this, new PropertyChangingEventArgs(propertyName));

public class MoviesDataContext : DataContext {
  private const string DBConnectionString = "Data Source=isostore:/Movies.sdf";

  public MoviesDataContext() : base(DBConnectionString) { }

  public Table<Movie> Movies;

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


  • Customize Your Own Audio Test Cues in Visual Studio 2019 v16.9 Preview 3

    Yes, developers can be alerted to a failed test with a fart sound.

  • Progress Touts New Third-Party Blazor UI Components

    Third-party dev tool specialist Progress announced an update to its .NET-centric offerings, touting new controls for Blazor, Microsoft's red-hot project for creating web apps with C#.

  • Entity Framework Core 6: What Developers Want

    Microsoft outlined its plan for Entity Framework Core 6, which in November will take its place as the data access component of the landmark .NET 6, a long-term support (LTS) release that will mark Microsoft's transition from the Windows-only .NET Framework to an open source, cross-platform umbrella offering of all things .NET.

  • AWS Open Sources .NET Porting Assistant GUI

    After previously open sourcing components of its Porting Assistant for .NET, Amazon Web Services open sourced the tool's GUI.

Upcoming Events