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);
}
