} //end of checking
/// <summary>
/// Check the authentication user is db owner
/// </summary>
/// <param name="connectionString"></param>
/// <returns></returns>
private bool IsDBOwner(string connectionString)
{
string dbOwnerCheckingSql = "select is_member('db_owner')";
int owner;
bool isDbOwner;
owner = (int)SqlTool.ExecuteScalar(connectionString, dbOwnerCheckingSql);
isDbOwner = (owner == 1);
return(isDbOwner);
}
private string GetVersionID(string connectionString)
{
string dbVersionCheckingSql = ConfigurationSettings.AppSettings["GetVersionScript"];
string version;
try
{
version = (string)SqlTool.ExecuteScalar(connectionString, dbVersionCheckingSql);
}
//If the get version script doesn't exist, it means wrong schema
catch
{
version = "";
}
return(version);
}
