void CreateBook_Click( object sender, RoutedEventArgs e )
{
BooksDataContext db = new BooksDataContext( "isostore:/bookDB.sdf" );
Progress.Items.Add("Connected to bookDB.sdf...");
Publisher pub = new Publisher()
{
PublisherID = "1",
Name = "APress",
City = "Acton",
Url = "http://Apress.com"
};
db.Publishers.InsertOnSubmit( pub );
Progress.Items.Add( "Pub (Apress) created..." );
Publisher pub2 = new Publisher()
{
PublisherID = "2",
Name = "O'Reilly",
City = "Cambridge",
Url = "http://Oreilly.com"
};
db.Publishers.InsertOnSubmit( pub );
Progress.Items.Add( "Pub (O'Reilly) created..." );
Book theBook = new Book()
{
BookID = "1",
BookPublisher = pub,
PublicationDate = DateTime.Now,
Title = "Programming Reactive Extensions"
};
db.Books.InsertOnSubmit( theBook );
Progress.Items.Add( "Book (Rx) created..." );
theBook = new Book()
{
BookID = "2",
BookPublisher = pub,
PublicationDate = DateTime.Now,
Title="Migrating to Windows Phone"
};
db.Books.InsertOnSubmit( theBook );
Progress.Items.Add( "Book (Migrating) created..." );
theBook = new Book()
{
BookID = "3",
BookPublisher = pub2,
PublicationDate = DateTime.Now,
Title = "Programming C#"
};
db.Books.InsertOnSubmit( theBook );
Progress.Items.Add( "Book (C#) created..." );
db.SubmitChanges();
Progress.Items.Add( "DB Updated." );
Progress.SelectedIndex = Progress.Items.Count -1;
}
public MainPage()
{
InitializeComponent();
DataContext db = new BooksDataContext( "isostore:/bookDB.sdf" );
if (db.DatabaseExists())
db.DeleteDatabase();
db.CreateDatabase();
CreateBook.Click += new RoutedEventHandler( CreateBook_Click );
ShowData.Click += new RoutedEventHandler( ShowData_Click );
}
void ShowData_Click( object sender, RoutedEventArgs e )
{
BooksDataContext db = new BooksDataContext( "isostore:/bookDB.sdf" );
var q = from b in db.Books
orderby b.Title
select new
{
b.Title,
b.PublicationDate,
b.BookPublisher
};
BooksLB.ItemsSource = q;
}