private static CostcoDevStatusEntities createContext() { const string ConnectionString = "Server=tcp:costcosu.database.windows.net,1433;Database=CostcoDevStatus;User ID=SUAdmin@costcosu;Password=39ffbJeo;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; CostcoDevStatusEntities context = CostcoDevStatusEntities.Create(ConnectionString); return(context); }
private static bool deleteAllData() { try { CostcoDevStatusEntities context = createContext(); IEnumerable <StatusUpdate> updates = context.StatusUpdates; foreach (StatusUpdate update in updates) { Console.WriteLine("Removing Status Update " + update.ProjectName + "," + update.UpdateKey); context.StatusUpdates.Remove(update); } context.SaveChanges(); IEnumerable <ProjectPhase> statusSequences = context.ProjectPhases; foreach (ProjectPhase statusSequence in statusSequences) { Console.WriteLine("Removing ProjectPhase record " + statusSequence.Project.ProjectName + "_" + statusSequence.UpdateKey); context.ProjectPhases.Remove(statusSequence); } context.SaveChanges(); IEnumerable <Project> projects = context.Projects; foreach (Project project in projects) { Console.WriteLine("Removing Project " + project.ProjectName); context.Projects.Remove(project); } context.SaveChanges(); } catch (Exception e) { errorMessage = e.Message; return(false); } return(true); }
public AccessService() { context = CostcoDevStatusEntities.Create(ConnectionString); }