public VerifyConnectionSuccessModel VerifyConnection() { VerifyConnectionSuccessModel successModel = new VerifyConnectionSuccessModel() { ConnectionVerified = false }; //string success = "onon"; try { using (var db = new OggleMySqlDbContext()) { var dbTest = db.CategoryFolders.Where(f => f.Id == 1).FirstOrDefault(); if (dbTest != null) { successModel.ConnectionVerified = true; } successModel.Success = "ok"; } } catch (Exception ex) { successModel.Success = Helpers.ErrorDetails(ex); } return(successModel); }
public VerifyConnectionSuccessModel VerifyConnection() { var timer = new System.Diagnostics.Stopwatch(); timer.Start(); VerifyConnectionSuccessModel successModel = new VerifyConnectionSuccessModel() { ConnectionVerified = false }; using (var db = new OggleBoobleMySqlContext()) { try { //using (var db = new OggleBoobleMSSqlContext()) var dbTest = db.CategoryFolders.Where(f => f.Id == 1).FirstOrDefault(); successModel.ConnectionVerified = (dbTest != null); timer.Stop(); successModel.Message = timer.Elapsed.ToString(); System.Diagnostics.Debug.WriteLine("VerifyConnection took: " + timer.Elapsed); successModel.Success = "ok"; } catch (Exception ex) { successModel.Success = Helpers.ErrorDetails(ex); } } return(successModel); }