public void Remove(FAQDBModel faqDB)
{
base.BaseRemove(GetElementKey(faqDB));
}
public static FAQDBResult DetectDBStatus(List <FAQDBModel> dbModels)
{
if (dbModels == null || dbModels.Count == 0)
{
throw new ArgumentException("dbModels");
}
FAQDBResult result = new FAQDBResult();
result.Detail = new List <FAQDBModel>();
Stopwatch watch = new Stopwatch();
foreach (var db in dbModels)
{
watch.Start();
var dbModel = new FAQDBModel();
try
{
using (SqlConnection conn = new SqlConnection(db.ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(db.SqlScript, conn))
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
dbModel.IsSuccessful = true;
}
else
{
dbModel.IsSuccessful = false;
}
if (reader != null)
{
reader.Close();
}
watch.Stop();
}
}
}
catch (Exception ex)
{
watch.Stop();
dbModel.IsSuccessful = false;
dbModel.ExceptionMessage = ex.Message;
}
finally
{
dbModel.DBInstanceName = db.DBInstanceName;
dbModel.DBName = db.DBName;
dbModel.SqlScript = db.SqlScript;
dbModel.ResponseTime = watch.ElapsedMilliseconds;
result.Detail.Add(dbModel);
if (watch != null)
{
watch.Reset();
}
}
}
result.Flag = (result.Detail.Where(p => p.IsSuccessful == true).Count() == dbModels.Count) ? true : false;
return(result);
}
public void Add(FAQDBModel faqDB)
{
base.BaseAdd(faqDB);
}
