private DatabaseHandler()
{
db = new DataContextBuilder(ConnectionString);
}
/// <summary>
/// Constructor for the Application object.
/// </summary>
public App()
{
// Global handler for uncaught exceptions.
UnhandledException += Application_UnhandledException;
// Standard XAML initialization
InitializeComponent();
// Phone-specific initialization
InitializePhoneApplication();
// Language display initialization
InitializeLanguage();
// Show graphics profiling information while debugging.
if (Debugger.IsAttached)
{
// Display the current frame rate counters
Current.Host.Settings.EnableFrameRateCounter = true;
// Show the areas of the app that are being redrawn in each frame.
//Application.Current.Host.Settings.EnableRedrawRegions = true;
// Enable non-production analysis visualization mode,
// which shows areas of a page that are handed off to GPU with a colored overlay.
//Application.Current.Host.Settings.EnableCacheVisualization = true;
// Prevent the screen from turning off while under the debugger by disabling
// the application's idle detection.
// Caution:- Use this under debug mode only. Application that disables user idle detection will continue to run
// and consume battery power when the user is not using the phone.
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
}
using (DataContextBuilder db = new DataContextBuilder(DataContextBuilder.DBConnectionString))
{
if (db.DatabaseExists() == false)
{
db.CreateDatabase();
}
}
DatabaseHandler dbHandler = DatabaseHandler.DbHandler;
DataContextBuilder dbTest = new DataContextBuilder("DataSource=isostore:/RUISviewDB.sdf");
Photos photo = new Photos()
{
p_Location = "pLocation",
p_PhotoName = "testPhoto",
p_ShowTime = 0,
p_TimesShown = 10
};
dbHandler.Interact(0, null, photo);
Maps map = new Maps();
map.m_MapLocation = "Testlocation";
map.m_MapName = "Testname";
Photos p2 = new Photos()
{
p_Location = "pLocation2",
p_PhotoName = "testPhoto2",
p_ShowTime = 2,
p_TimesShown = 20
};
dbHandler.Interact(0, map, null);
Maps m = dbTest.Maps.First();
string s = m.m_MapName;
photo.m_MapId = m.m_MapId;
dbHandler.Interact(0, null, p2);
}