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