internal void RecreateDatabase()
{
// purge
db.Categories.DeleteAllOnSubmit(db.Categories);
db.Widgets.DeleteAllOnSubmit(db.Widgets);
db.SubmitChanges();
// create new
_category1 = new Category() { CategoryName = "Category 1" };
_category2 = new Category() { CategoryName = "Category 2" };
db.Categories.InsertOnSubmit(_category1);
db.Categories.InsertOnSubmit(_category2);
db.Widgets.InsertOnSubmit(new Widget() { WidgetName = "Widget 1", WidgetCategory = _category1 });
db.Widgets.InsertOnSubmit(new Widget() { WidgetName = "Widget 2", WidgetCategory = _category2 });
db.Widgets.InsertOnSubmit(new Widget() { WidgetName = "Widget 3", WidgetCategory = _category1 });
db.Widgets.InsertOnSubmit(new Widget() { WidgetName = "Widget 4", WidgetCategory = _category2 });
db.Widgets.InsertOnSubmit(new Widget() { WidgetName = "Widget 5", WidgetCategory = _category1 });
counter = 6;
db.SubmitChanges();
Refresh();
}
public void Refresh()
{
// ensure that data exists - just for this test app
if (db.Categories.Count() == 0 || db.Widgets.Count() == 0)
{
RecreateDatabase();
}
Widgets = null;
Widgets = new ObservableCollection<Widget>(db.Widgets);
_category1 = db.Categories.First();
_category2 = db.Categories.Skip(1).Take(1).First();
}