/// <summary> /// Returns the role Id given a role name /// </summary> /// <param name="roleName">Role's name</param> /// <returns>Role's Id</returns> public string GetRoleId(string roleName) { string roleId = null; string commandText = "Select Id from Roles where Name = @name"; Dictionary <string, object> parameters = new Dictionary <string, object>() { { "@name", roleName } }; var result = _database.QueryValue(commandText, parameters); if (result != null) { return(Convert.ToString(result)); } return(roleId); }