public void BackupDB()
{
string NewBackup = "ImeTrackrDbBAK" + DateTime.Today.ToString("MM-dd-yyyy") + ".sdf";
string BackUpPath = @"C:\Users\McArlo\Documents\Visual Studio 2010\Projects\ImeTrackr\ImeTrackr\App_Data\" + NewBackup;
var db = new ImeTrackrContext();
db.Database.Connection.Close();
File.Delete(BackUpPath);
File.Copy(@"C:\Users\McArlo\Documents\Visual Studio 2010\Projects\ImeTrackr\ImeTrackr\App_Data\ImeTrackrDB.sdf",
BackUpPath);
db.Database.Connection.Open();
}
private static IEnumerable<Contact> GetContacts()
{
IEnumerable<Contact> contacts;
using (ImeTrackrContext db = new ImeTrackrContext())
{
contacts = (from one in db.Contacts
orderby one.LastName
select one).ToList();
}
ImeTrackrContext context = new ImeTrackrContext();
return contacts;
}
