Class SqlDataProvider

Inheritance

object

DataProvider

SqlDataProvider

Inherited Members

DataProvider.Instance()

DataProvider.CommitTransaction(DbTransaction)

DataProvider.GetTransaction()

DataProvider.RollbackTransaction(DbTransaction)

DataProvider.GetNull(object)

DataProvider.FindDatabaseVersion(int, int, int)

DataProvider.GetDatabaseEngineVersion()

DataProvider.GetDatabaseVersion()

DataProvider.GetDatabaseInstallVersion()

DataProvider.GetVersion()

DataProvider.GetInstallVersion()

DataProvider.GetConnectionStringBuilder()

DataProvider.GetProviderPath()

DataProvider.TestDatabaseConnection(DbConnectionStringBuilder, string, string)

DataProvider.UpdateDatabaseVersion(int, int, int, string)

DataProvider.UpdateDatabaseVersionIncrement(int, int, int, int, string)

DataProvider.GetLastAppliedIteration(int, int, int)

DataProvider.GetUnappliedIterations(string)

DataProvider.GetHostSetting(string)

DataProvider.GetHostSettings()

DataProvider.UpdateHostSetting(string, string, bool, int)

DataProvider.DeleteServer(int)

DataProvider.GetServers()

DataProvider.UpdateServer(int, string, string, bool, string)

DataProvider.UpdateServerActivity(string, string, DateTime, DateTime, int, bool)

DataProvider.CreatePortal(string, string, DateTime, double, double, int, int, int, string, string, int)

DataProvider.DeletePortalInfo(int)

DataProvider.DeletePortalSetting(int, string, string)

DataProvider.DeletePortalSettings(int, string)

DataProvider.GetExpiredPortals()

DataProvider.GetPortals(string)

DataProvider.GetAllPortals()

DataProvider.GetPortalsByName(string, int, int)

DataProvider.GetPortalsByUser(int)

DataProvider.GetPortalSettings(int, string)

DataProvider.GetPortalSpaceUsed(int)

DataProvider.UpdatePortalInfo(int, int, string, string, string, DateTime, int, int, string, int, double, double, int, int, string, string, string, string, string, string, int, int, int, int, int, int, int, int, int, int, int, string, string, int, string)

DataProvider.UpdatePortalSetting(int, string, string, int, string, bool)

DataProvider.UpdatePortalSetup(int, int, int, int, int, int, int, int, int, int, int, int, int, int, int, string)

DataProvider.AddTabAfter(TabInfo, int, int)

DataProvider.AddTabBefore(TabInfo, int, int)

DataProvider.AddTabToEnd(TabInfo, int)

DataProvider.DeleteTab(int)

DataProvider.DeleteTabSetting(int, string)

DataProvider.DeleteTabSettings(int)

DataProvider.DeleteTabUrl(int, int)

DataProvider.DeleteTabVersion(int)

DataProvider.DeleteTabVersionDetail(int)

DataProvider.DeleteTabVersionDetailByModule(int)

DataProvider.DeleteTranslatedTabs(int, string)

DataProvider.EnsureNeutralLanguage(int, string)

DataProvider.ConvertTabToNeutralLanguage(int, int, string)

DataProvider.GetAllTabs()

DataProvider.GetTab(int)

DataProvider.GetTabByUniqueID(Guid)

DataProvider.GetTabPanes(int)

DataProvider.GetTabPaths(int, string)

DataProvider.GetTabs(int)

DataProvider.GetTabsByModuleID(int)

DataProvider.GetTabsByTabModuleID(int)

DataProvider.GetTabsByPackageID(int, int, bool)

DataProvider.GetTabSetting(int, string)

DataProvider.GetTabSettings(int)

DataProvider.GetTabAliasSkins(int)

DataProvider.GetTabCustomAliases(int)

DataProvider.GetTabUrls(int)

DataProvider.GetTabVersions(int)

DataProvider.GetTabVersionDetails(int)

DataProvider.GetTabVersionDetailsHistory(int, int)

DataProvider.GetCustomAliasesForTabs()

DataProvider.LocalizeTab(int, string, int)

DataProvider.MoveTabAfter(int, int, int)

DataProvider.MoveTabBefore(int, int, int)

DataProvider.MoveTabToParent(int, int, int)

DataProvider.SaveTabUrl(int, int, int, int, string, string, string, string, bool, int)

DataProvider.SaveTabVersion(int, int, DateTime, int, bool, int, int)

DataProvider.SaveTabVersionDetail(int, int, int, int, string, int, int, int, int)

DataProvider.UpdateTab(int, int, int, Guid, Guid, Guid, string, bool, bool, int, string, string, string, string, string, bool, string, string, string, DateTime, DateTime, int, string, bool, bool, float, int, string, bool)

DataProvider.UpdateTabOrder(int, int, int, int)

DataProvider.UpdateTabSetting(int, string, string, int)

DataProvider.UpdateTabTranslationStatus(int, Guid, int)

DataProvider.MarkAsPublished(int)

DataProvider.UpdateTabVersion(int, Guid)

DataProvider.AddModule(int, int, int, bool, DateTime, DateTime, bool, bool, bool, bool, int)

DataProvider.AddTabModule(int, int, string, string, string, int, string, int, string, string, string, string, string, int, string, bool, bool, bool, bool, string, DateTime, int, Guid, Guid, Guid, Guid, string, int)

DataProvider.DeleteModule(int)

DataProvider.DeleteModuleSetting(int, string)

DataProvider.DeleteModuleSettings(int)

DataProvider.DeleteTabModule(int, int, bool, int)

DataProvider.DeleteTabModuleSetting(int, string)

DataProvider.DeleteTabModuleSettings(int)

DataProvider.GetTabModuleSettingsByName(int, string)

DataProvider.GetTabModuleIdsBySettingNameAndValue(int, string, string)

DataProvider.GetAllModules()

DataProvider.GetAllTabsModules(int, bool)

DataProvider.GetAllTabsModulesByModuleID(int)

DataProvider.GetModule(int, int)

DataProvider.GetModuleByDefinition(int, string)

DataProvider.GetModuleByUniqueID(Guid)

DataProvider.GetModules(int)

DataProvider.GetModuleSetting(int, string)

DataProvider.GetModuleSettings(int)

DataProvider.GetModuleSettingsByTab(int)

DataProvider.GetSearchModules(int)

DataProvider.GetTabModule(int)

DataProvider.GetTabModuleOrder(int, string)

DataProvider.GetTabModules(int)

DataProvider.GetTabModuleSetting(int, string)

DataProvider.GetTabModuleSettings(int)

DataProvider.GetTabModuleSettingsByTab(int)

DataProvider.MoveTabModule(int, int, int, string, int)

DataProvider.RestoreTabModule(int, int)

DataProvider.UpdateModule(int, int, int, bool, DateTime, DateTime, bool, bool, bool, bool, int)

DataProvider.UpdateModuleLastContentModifiedOnDate(int)

DataProvider.UpdateModuleOrder(int, int, int, string)

DataProvider.UpdateModuleSetting(int, string, string, int)

DataProvider.UpdateTabModule(int, int, int, string, string, string, int, string, int, string, string, string, string, string, int, string, bool, bool, bool, bool, string, DateTime, int, Guid, Guid, Guid, string, int)

DataProvider.UpdateTabModuleTranslationStatus(int, Guid, int)

DataProvider.UpdateTabModuleSetting(int, string, string, int)

DataProvider.UpdateTabModuleVersion(int, Guid)

DataProvider.UpdateTabModuleVersionByModule(int)

DataProvider.GetInstalledModules()

DataProvider.AddDesktopModule(int, string, string, string, string, string, bool, bool, string, int, int, string, string, string, int, int, string, string)

DataProvider.DeleteDesktopModule(int)

DataProvider.GetDesktopModules()

DataProvider.GetDesktopModulesByPortal(int)

DataProvider.UpdateDesktopModule(int, int, string, string, string, string, string, bool, bool, string, int, int, string, string, string, int, int, string, string)

DataProvider.AddPortalDesktopModule(int, int, int)

DataProvider.DeletePortalDesktopModules(int, int)

DataProvider.GetPortalDesktopModules(int, int)

DataProvider.AddModuleDefinition(int, string, string, int, int)

DataProvider.DeleteModuleDefinition(int)

DataProvider.GetModuleDefinitions()

DataProvider.UpdateModuleDefinition(int, string, string, int, int)

DataProvider.AddModuleControl(int, string, string, string, string, int, int, string, bool, bool, int)

DataProvider.DeleteModuleControl(int)

DataProvider.GetModuleControls()

DataProvider.UpdateModuleControl(int, int, string, string, string, string, int, int, string, bool, bool, int)

DataProvider.AddFolder(int, Guid, Guid, string, string, int, bool, bool, DateTime, int, int, bool, int, int)

DataProvider.DeleteFolder(int, string)

DataProvider.GetFolder(int)

DataProvider.GetFolder(int, string)

DataProvider.GetFolderByUniqueID(Guid)

DataProvider.GetFoldersByPortal(int)

DataProvider.GetFoldersByPortalAndPermissions(int, string, int)

DataProvider.GetLegacyFolderCount()

DataProvider.UpdateFolder(int, Guid, int, string, int, string, bool, bool, DateTime, int, int, bool, int, int)

DataProvider.UpdateFolderVersion(int, Guid)

DataProvider.UpdateLegacyFolders()

DataProvider.AddFile(int, Guid, Guid, string, string, long, int, int, string, string, int, int, string, DateTime, string, string, DateTime, DateTime, bool, int)

DataProvider.SetFileHasBeenPublished(int, bool)

DataProvider.CountLegacyFiles()

DataProvider.ClearFileContent(int)

DataProvider.DeleteFile(int, string, int)

DataProvider.DeleteFiles(int)

DataProvider.GetAllFiles()

DataProvider.GetFile(string, int, bool)

DataProvider.GetFileById(int, bool)

DataProvider.GetFileByUniqueID(Guid)

DataProvider.GetFileContent(int)

DataProvider.GetFileVersionContent(int, int)

DataProvider.GetFiles(int, bool, bool)

DataProvider.UpdateFile(int, Guid, string, string, long, int, int, string, int, int, string, DateTime, string, string, DateTime, DateTime, bool, int)

DataProvider.UpdateFileLastModificationTime(int, DateTime)

DataProvider.UpdateFileHashCode(int, string)

DataProvider.UpdateFileContent(int, byte[])

DataProvider.UpdateFileVersion(int, Guid)

DataProvider.AddPermission(string, int, string, string, int)

DataProvider.DeletePermission(int)

DataProvider.UpdatePermission(int, string, int, string, string, int)

DataProvider.AddModulePermission(int, int, int, int, bool, int, int)

DataProvider.DeleteModulePermission(int)

DataProvider.DeleteModulePermissionsByModuleID(int, int)

DataProvider.DeleteModulePermissionsByUserID(int, int)

DataProvider.GetModulePermission(int)

DataProvider.GetModulePermissionsByModuleID(int, int)

DataProvider.GetModulePermissionsByPortal(int)

DataProvider.GetModulePermissionsByTabID(int)

DataProvider.UpdateModulePermission(int, int, int, int, int, bool, int, int)

DataProvider.AddTabPermission(int, int, int, bool, int, int)

DataProvider.DeleteTabPermission(int)

DataProvider.DeleteTabPermissionsByTabID(int)

DataProvider.DeleteTabPermissionsByUserID(int, int)

DataProvider.GetTabPermissionsByPortal(int)

DataProvider.GetTabPermissionsByTabID(int, int)

DataProvider.UpdateTabPermission(int, int, int, int, bool, int, int)

DataProvider.AddFolderPermission(int, int, int, bool, int, int)

DataProvider.GetPortalPermissionsByPortal(int)

DataProvider.AddPortalPermission(int, int, int, bool, int, int)

DataProvider.DeletePortalPermission(int)

DataProvider.DeletePortalPermissionsByPortalID(int)

DataProvider.DeletePortalPermissionsByUserID(int, int)

DataProvider.DeleteFolderPermission(int)

DataProvider.DeleteFolderPermissionsByFolderPath(int, string)

DataProvider.DeleteFolderPermissionsByUserID(int, int)

DataProvider.GetFolderPermission(int)

DataProvider.GetFolderPermissionsByFolderPath(int, string, int)

DataProvider.GetFolderPermissionsByPortal(int)

DataProvider.GetFolderPermissionsByPortalAndPath(int, string)

DataProvider.UpdateFolderPermission(int, int, int, int, bool, int, int)

DataProvider.AddDesktopModulePermission(int, int, int, bool, int, int)

DataProvider.DeleteDesktopModulePermission(int)

DataProvider.DeleteDesktopModulePermissionsByPortalDesktopModuleID(int)

DataProvider.DeleteDesktopModulePermissionsByUserID(int, int)

DataProvider.GetDesktopModulePermission(int)

DataProvider.GetDesktopModulePermissions()

DataProvider.GetDesktopModulePermissionsByPortalDesktopModuleID(int)

DataProvider.UpdateDesktopModulePermission(int, int, int, int, bool, int, int)

DataProvider.AddRoleGroup(int, string, string, int)

DataProvider.DeleteRoleGroup(int)

DataProvider.GetRoleGroup(int, int)

DataProvider.GetRoleGroupByName(int, string)

DataProvider.GetRoleGroups(int)

DataProvider.UpdateRoleGroup(int, string, string, int)

DataProvider.AddRole(int, int, string, string, float, string, string, float, int, string, bool, bool, string, string, int, int, int, bool)

DataProvider.DeleteRole(int)

DataProvider.GetPortalRoles(int)

DataProvider.GetRoles()

DataProvider.GetRolesBasicSearch(int, int, int, string)

DataProvider.GetRoleSettings(int)

DataProvider.UpdateRole(int, int, string, string, float, string, string, float, int, string, bool, bool, string, string, int, int, int, bool)

DataProvider.UpdateRoleSetting(int, string, string, int)

DataProvider.AddUser(int, string, string, string, int, bool, string, string, bool, bool, int)

DataProvider.AddUserPortal(int, int)

DataProvider.ChangeUsername(int, string)

DataProvider.DeleteUserFromPortal(int, int)

DataProvider.GetAllUsers(int, int, int, bool, bool)

DataProvider.GetDeletedUsers(int)

DataProvider.GetUnAuthorizedUsers(int, bool, bool)

DataProvider.GetUser(int, int)

DataProvider.GetUserByAuthToken(int, string, string)

DataProvider.GetUserByDisplayName(int, string)

DataProvider.GetUserByUsername(int, string)

DataProvider.GetUserByUsername(string, string)

DataProvider.GetUserByVanityUrl(int, string)

DataProvider.GetUserByPasswordResetToken(int, string)

DataProvider.GetDisplayNameForUser(int, string)

DataProvider.GetUserCountByPortal(int)

DataProvider.GetUsersAdvancedSearch(int, int, int, int, int, bool, int, int, string, bool, string, string)

DataProvider.GetUsersBasicSearch(int, int, int, string, bool, string, string)

DataProvider.GetUsersByEmail(int, string, int, int, bool, bool)

DataProvider.GetUsersByProfileProperty(int, string, string, int, int, bool, bool)

DataProvider.GetUsersByRolename(int, string)

DataProvider.GetUsersByUsername(int, string, int, int, bool, bool)

DataProvider.GetUsersByDisplayname(int, string, int, int, bool, bool)

DataProvider.GetDuplicateEmailCount(int)

DataProvider.GetSingleUserByEmail(int, string)

DataProvider.RemoveUser(int, int)

DataProvider.ReplaceServerOnSchedules(string, string)

DataProvider.ResetTermsAgreement(int)

DataProvider.RestoreUser(int, int)

DataProvider.UpdateUser(int, int, string, string, bool, string, string, string, bool, bool, bool, string, Guid, DateTime, bool, int)

DataProvider.UpdateUserLastIpAddress(int, string)

DataProvider.UserAgreedToTerms(int, int)

DataProvider.UserRequestsRemoval(int, int, bool)

DataProvider.AddUserRole(int, int, int, int, bool, DateTime, DateTime, int)

DataProvider.DeleteUserRole(int, int)

DataProvider.GetServices(int, int)

DataProvider.GetUserRole(int, int, int)

DataProvider.GetUserRoles(int, int)

DataProvider.GetUserRolesByUsername(int, string, string)

DataProvider.UpdateUserRole(int, int, bool, DateTime, DateTime, int)

DataProvider.AddPropertyDefinition(int, int, int, string, string, string, bool, bool, string, int, bool, int, int, int)

DataProvider.DeletePropertyDefinition(int)

DataProvider.GetPropertyDefinition(int)

DataProvider.GetPropertyDefinitionByName(int, string)

DataProvider.GetPropertyDefinitionsByPortal(int)

DataProvider.GetUserProfile(int)

DataProvider.UpdateProfileProperty(int, int, int, string, int, string, DateTime)

DataProvider.UpdatePropertyDefinition(int, int, string, string, string, bool, bool, string, int, bool, int, int, int)

DataProvider.SearchProfilePropertyValues(int, string, string)

DataProvider.AddSkinControl(int, string, string, bool, int)

DataProvider.DeleteSkinControl(int)

DataProvider.GetSkinControls()

DataProvider.GetSkinControl(int)

DataProvider.GetSkinControlByKey(string)

DataProvider.GetSkinControlByPackageID(int)

DataProvider.UpdateSkinControl(int, int, string, string, bool, int)

DataProvider.AddSkin(int, string)

DataProvider.AddSkinPackage(int, int, string, string, int)

DataProvider.CanDeleteSkin(string, string)

DataProvider.DeleteSkin(int)

DataProvider.DeleteSkinPackage(int)

DataProvider.GetSkinByPackageID(int)

DataProvider.GetSkinPackage(int, string, string)

DataProvider.UpdateSkin(int, string)

DataProvider.UpdateSkinPackage(int, int, int, string, string, int)

DataProvider.AddProfile(int, int)

DataProvider.GetAllProfiles()

DataProvider.GetProfile(int, int)

DataProvider.UpdateProfile(int, int, string)

DataProvider.AddUrl(int, string)

DataProvider.AddUrlLog(int, int)

DataProvider.AddUrlTracking(int, string, string, bool, bool, int, bool)

DataProvider.DeleteUrl(int, string)

DataProvider.DeleteUrlTracking(int, string, int)

DataProvider.GetUrl(int, string)

DataProvider.GetUrlLog(int, DateTime, DateTime)

DataProvider.GetUrls(int)

DataProvider.GetUrlTracking(int, string, int)

DataProvider.UpdateUrlTracking(int, string, bool, bool, int, bool)

DataProvider.UpdateUrlTrackingStats(int, string, int)

DataProvider.GetDefaultLanguageByModule(string)

DataProvider.GetSearchCommonWordsByLocale(string)

DataProvider.GetSearchIndexers()

DataProvider.GetSearchResultModules(int)

DataProvider.GetSearchSettings(int)

DataProvider.AddListEntry(string, string, string, int, int, bool, int, string, int, bool, int)

DataProvider.DeleteList(string, string)

DataProvider.DeleteListEntryByID(int, bool)

DataProvider.DeleteListEntryByListName(string, string, bool)

DataProvider.GetList(string, string, int)

DataProvider.GetListEntriesByListName(string, string, int)

DataProvider.GetListEntry(string, string)

DataProvider.GetListEntry(int)

DataProvider.GetLists(int)

DataProvider.UpdateListEntry(int, string, string, string, int)

DataProvider.UpdateListSortOrder(int, bool)

DataProvider.AddPortalAlias(int, string, string, string, string, bool, int)

DataProvider.DeletePortalAlias(int)

DataProvider.GetPortalAliases()

DataProvider.GetPortalByPortalAliasID(int)

DataProvider.UpdatePortalAlias(string, int)

DataProvider.UpdatePortalAliasInfo(int, int, string, string, string, string, bool, int)

DataProvider.AddEventMessage(string, int, string, string, string, string, string, string, string, DateTime, DateTime, string)

DataProvider.GetEventMessages(string)

DataProvider.GetEventMessagesBySubscriber(string, string)

DataProvider.SetEventMessageComplete(int)

DataProvider.AddAuthentication(int, string, bool, string, string, string, int)

DataProvider.AddUserAuthentication(int, string, string, int)

DataProvider.GetUserAuthentication(int)

DataProvider.DeleteAuthentication(int)

DataProvider.GetAuthenticationService(int)

DataProvider.GetAuthenticationServiceByPackageID(int)

DataProvider.GetAuthenticationServiceByType(string)

DataProvider.GetAuthenticationServices()

DataProvider.GetEnabledAuthenticationServices()

DataProvider.UpdateAuthentication(int, int, string, bool, string, string, string, int)

DataProvider.AddPackage(int, string, string, string, string, string, string, string, string, string, string, string, string, bool, int, string, string)

DataProvider.DeletePackage(int)

DataProvider.GetModulePackagesInUse(int, bool)

DataProvider.GetPackageDependencies()

DataProvider.GetPackages(int)

DataProvider.GetPackageTypes()

DataProvider.RegisterAssembly(int, string, string)

DataProvider.SavePackageDependency(int, int, string, string)

DataProvider.UnRegisterAssembly(int, string)

DataProvider.UpdatePackage(int, int, string, string, string, string, string, string, string, string, string, string, string, bool, int, string, string)

DataProvider.SetCorePackageVersions()

DataProvider.AddLanguage(string, string, string, int)

DataProvider.AddLanguagePack(int, int, int, int)

DataProvider.AddPortalLanguage(int, int, bool, int)

DataProvider.DeleteLanguage(int)

DataProvider.DeleteLanguagePack(int)

DataProvider.DeletePortalLanguages(int, int)

DataProvider.EnsureLocalizationExists(int, string)

DataProvider.RemovePortalLocalization(int, string)

DataProvider.GetPortalLocalizations(int)

DataProvider.GetLanguages()

DataProvider.GetLanguagePackByPackage(int)

DataProvider.GetLanguagesByPortal(int)

DataProvider.GetPortalDefaultLanguage(int)

DataProvider.UpdateLanguage(int, string, string, string, int)

DataProvider.UpdateLanguagePack(int, int, int, int, int)

DataProvider.UpdatePortalDefaultLanguage(int, string)

DataProvider.UpdatePortalLanguage(int, int, bool, int)

DataProvider.AddDefaultFolderTypes(int)

DataProvider.AddFolderMapping(int, string, string, int)

DataProvider.AddFolderMappingSetting(int, string, string, int)

DataProvider.DeleteFolderMapping(int)

DataProvider.GetFolderMapping(int)

DataProvider.GetFolderMappingByMappingName(int, string)

DataProvider.GetFolderMappings(int)

DataProvider.GetFolderMappingSetting(int, string)

DataProvider.GetFolderMappingSettings(int)

DataProvider.UpdateFolderMapping(int, string, int, int)

DataProvider.UpdateFolderMappingSetting(int, string, string, int)

DataProvider.GetPasswordHistory(int, int, int)

DataProvider.AddPasswordHistory(int, string, string, int, int)

DataProvider.GetDatabaseTimeUtc()

DataProvider.GetDatabaseTime()

DataProvider.GetDatabaseTimeOffset()

DataProvider.DeletePreviewProfile(int)

DataProvider.DeleteRedirection(int)

DataProvider.DeleteRedirectionRule(int)

DataProvider.GetAllRedirections()

DataProvider.GetPreviewProfiles(int)

DataProvider.GetRedirectionRules(int)

DataProvider.GetRedirections(int)

DataProvider.SavePreviewProfile(int, int, string, int, int, string, int, int)

DataProvider.SaveRedirection(int, int, string, int, int, int, bool, int, object, bool, int)

DataProvider.SaveRedirectionRule(int, int, string, string)

DataProvider.AddLog(string, string, int, string, int, string, DateTime, string, string, int, ExceptionInfo, bool)

DataProvider.AddLogType(string, string, string, string, string)

DataProvider.AddLogTypeConfigInfo(bool, string, string, int, bool, int, int, int, string, string)

DataProvider.ClearLog()

DataProvider.DeleteLog(string)

DataProvider.DeleteLogType(string)

DataProvider.DeleteLogTypeConfigInfo(string)

DataProvider.GetEventLogPendingNotif(int)

DataProvider.GetEventLogPendingNotifConfig()

DataProvider.GetLogs(int, string, int, int)

DataProvider.GetLogTypeConfigInfo()

DataProvider.GetLogTypeConfigInfoByID(int)

DataProvider.GetLogTypeInfo()

DataProvider.GetSingleLog(string)

DataProvider.PurgeLog()

DataProvider.UpdateEventLogPendingNotif(int)

DataProvider.UpdateLogType(string, string, string, string, string)

DataProvider.UpdateLogTypeConfigInfo(string, bool, string, string, int, bool, int, int, int, string, string)

DataProvider.AddSchedule(string, int, string, int, string, int, string, bool, bool, string, string, int, string, DateTime)

DataProvider.AddScheduleHistory(int, DateTime, string)

DataProvider.AddScheduleItemSetting(int, string, string)

DataProvider.DeleteSchedule(int)

DataProvider.GetNextScheduledTask(string)

DataProvider.GetSchedule()

DataProvider.GetSchedule(string)

DataProvider.GetSchedule(int)

DataProvider.GetSchedule(string, string)

DataProvider.GetScheduleByEvent(string, string)

DataProvider.GetScheduleHistory(int)

DataProvider.GetScheduleItemSettings(int)

DataProvider.PurgeScheduleHistory()

DataProvider.UpdateSchedule(int, string, int, string, int, string, int, string, bool, bool, string, string, int, string, DateTime)

DataProvider.UpdateScheduleHistory(int, DateTime, bool, string, DateTime)

DataProvider.AddExtensionUrlProvider(int, int, string, string, string, bool, bool, bool, bool)

DataProvider.DeleteExtensionUrlProvider(int)

DataProvider.GetExtensionUrlProviders(int)

DataProvider.SaveExtensionUrlProviderSetting(int, int, string, string)

DataProvider.UpdateExtensionUrlProvider(int, bool)

DataProvider.GetIPFilters()

DataProvider.AddIPFilter(string, string, int, int, string)

DataProvider.DeleteIPFilter(int)

DataProvider.UpdateIPFilter(int, string, string, int, int, string)

DataProvider.GetIPFilter(int)

DataProvider.GetFileVersions(int)

DataProvider.GetFileVersionsInFolder(int)

DataProvider.AddFileVersion(int, Guid, Guid, string, string, long, int, int, string, string, int, int, string, DateTime, string, bool, DateTime, DateTime, int, bool, byte[])

DataProvider.DeleteFileVersion(int, int)

DataProvider.ResetFilePublishedVersion(int)

DataProvider.GetFileVersion(int, int)

DataProvider.SetPublishedVersion(int, int)

DataProvider.GetContentWorkflowUsageCount(int)

DataProvider.GetContentWorkflowUsage(int, int, int)

DataProvider.GetContentWorkflowStateUsageCount(int)

DataProvider.AddContentWorkflowStatePermission(int, int, int, bool, int, int)

DataProvider.UpdateContentWorkflowStatePermission(int, int, int, int, bool, int, int)

DataProvider.DeleteContentWorkflowStatePermission(int)

DataProvider.GetContentWorkflowStatePermission(int)

DataProvider.GetContentWorkflowStatePermissions()

DataProvider.GetContentWorkflowStatePermissionsByStateID(int)

DataProvider.GetAllSearchTypes()

DataProvider.GetAllSynonymsGroups(int, string)

DataProvider.AddSynonymsGroup(string, int, int, string)

DataProvider.UpdateSynonymsGroup(int, string, int)

DataProvider.DeleteSynonymsGroup(int)

DataProvider.GetSearchStopWords(int, string)

DataProvider.AddSearchStopWords(string, int, int, string)

DataProvider.UpdateSearchStopWords(int, string, int)

DataProvider.DeleteSearchStopWords(int)

DataProvider.AddSearchDeletedItems(SearchDocumentToDelete)

DataProvider.DeleteProcessedSearchDeletedItems(DateTime)

DataProvider.GetSearchDeletedItems(DateTime)

DataProvider.GetAvailableUsersForIndex(int, DateTime, int, int)

DataProvider.AddOutputCacheItem(int, string, string, DateTime)

DataProvider.GetOutputCacheItem(string)

DataProvider.GetOutputCacheItemCount(int)

DataProvider.GetOutputCacheKeys()

DataProvider.GetOutputCacheKeys(int)

DataProvider.PurgeExpiredOutputCacheItems()

DataProvider.PurgeOutputCache()

DataProvider.RemoveOutputCacheItem(int)

DataProvider.AddRedirectMessage(int, int, string)

DataProvider.GetRedirectMessage(Guid)

DataProvider.DeleteOldRedirectMessage(DateTime)

DataProvider.UpdateAuthCookie(string, DateTime, int)

DataProvider.FindAuthCookie(string)

DataProvider.DeleteAuthCookie(string)

DataProvider.DeleteExpiredAuthCookies(DateTime)

DataProvider.SetAllPortalTabsSecure(int, bool)

DataProvider.ExecuteDataSet(string, params object[])

DataProvider.ExecuteSQL(string, params IDataParameter[])

DataProvider.CreatePortal(string, string, DateTime, double, double, int, int, int, string, int)

DataProvider.DeleteUsersOnline(int)

DataProvider.GetOnlineUser(int)

DataProvider.GetOnlineUsers(int)

DataProvider.UpdateUsersOnline(Hashtable)

DataProvider.GetPasswordHistory(int)

DataProvider.AddPasswordHistory(int, string, string, int)

DataProvider.AddIPFilter(string, string, int, int)

DataProvider.UpdateIPFilter(int, string, string, int, int)

DataProvider.AddContentWorkflow(int, string, string, bool, bool, bool, bool)

DataProvider.GetContentWorkflow(int)

DataProvider.GetContentWorkflows(int)

DataProvider.UpdateContentWorkflow(int, string, string, bool, bool, bool, bool)

DataProvider.AddContentWorkflowState(int, string, int, bool, bool, bool, bool, string, string, string, string)

DataProvider.DeleteContentWorkflowState(int)

DataProvider.UpdateContentWorkflowState(int, string, int, bool, bool, bool, bool, string, string, string, string)

DataProvider.GetContentWorkflowState(int)

DataProvider.GetContentWorkflowStates(int)

DataProvider.AddContentWorkflowLog(string, string, int, int, int)

DataProvider.GetContentWorkflowLogs(int, int)

DataProvider.DeleteContentWorkflowLogs(int, int)

DataProvider.GetContentWorkflowSource(int, string)

DataProvider.AddContentWorkflowSource(int, string, string)

DataProvider.ExecuteScalar(string, params object[])

DataProvider.GetFiles(int, bool)

DataProvider.ConnectionString

DataProvider.DatabaseOwner

DataProvider.DefaultProviderName

DataProvider.ObjectQualifier

DataProvider.ProviderName

DataProvider.ProviderPath

DataProvider.UpgradeConnectionString

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

Namespace: DotNetNuke.Data

Assembly: DotNetNuke.dll

Syntax

public sealed class SqlDataProvider : DataProvider

Constructors

SqlDataProvider()

Declaration

public SqlDataProvider()

Properties

IsConnectionValid

Declaration

public override bool IsConnectionValid { get; }

Property Value

Type	Description
bool

Overrides

DataProvider.IsConnectionValid

Settings

Declaration

public override Dictionary<string, string> Settings { get; }

Property Value

Type	Description
Dictionary<string, string>

Overrides

DataProvider.Settings

Methods

BulkInsert(string, string, DataTable)

Declaration

public override void BulkInsert(string procedureName, string tableParameterName, DataTable dataTable)

Parameters

Type	Name	Description
string	procedureName
string	tableParameterName
DataTable	dataTable

Overrides

DataProvider.BulkInsert(string, string, DataTable)

BulkInsert(string, string, DataTable, Dictionary<string, object>)

Declaration

public override void BulkInsert(string procedureName, string tableParameterName, DataTable dataTable, Dictionary<string, object> commandParameters)

Parameters

Type	Name	Description
string	procedureName
string	tableParameterName
DataTable	dataTable
Dictionary<string, object>	commandParameters

Overrides

DataProvider.BulkInsert(string, string, DataTable, Dictionary<string, object>)

BulkInsert(string, string, DataTable, int)

Declaration

public override void BulkInsert(string procedureName, string tableParameterName, DataTable dataTable, int timeoutSec)

Parameters

Type	Name	Description
string	procedureName
string	tableParameterName
DataTable	dataTable
int	timeoutSec

Overrides

DataProvider.BulkInsert(string, string, DataTable, int)

BulkInsert(string, string, DataTable, int, Dictionary<string, object>)

Declaration

public override void BulkInsert(string procedureName, string tableParameterName, DataTable dataTable, int timeoutSec, Dictionary<string, object> commandParameters)

Parameters

Type	Name	Description
string	procedureName
string	tableParameterName
DataTable	dataTable
int	timeoutSec
Dictionary<string, object>	commandParameters

Overrides

DataProvider.BulkInsert(string, string, DataTable, int, Dictionary<string, object>)

ExecuteNonQuery(int, string, params object[])

Declaration

public override void ExecuteNonQuery(int timeoutSec, string procedureName, params object[] commandParameters)

Parameters

Type	Name	Description
int	timeoutSec
string	procedureName
object[]	commandParameters

Overrides

DataProvider.ExecuteNonQuery(int, string, params object[])

ExecuteNonQuery(string, params object[])

Declaration

public override void ExecuteNonQuery(string procedureName, params object[] commandParameters)

Parameters

Type	Name	Description
string	procedureName
object[]	commandParameters

Overrides

DataProvider.ExecuteNonQuery(string, params object[])

ExecuteReader(int, string, params object[])

Declaration

public override IDataReader ExecuteReader(int timeoutSec, string procedureName, params object[] commandParameters)

Parameters

Type	Name	Description
int	timeoutSec
string	procedureName
object[]	commandParameters

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteReader(int, string, params object[])

ExecuteReader(string, params object[])

Declaration

public override IDataReader ExecuteReader(string procedureName, params object[] commandParameters)

Parameters

Type	Name	Description
string	procedureName
object[]	commandParameters

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteReader(string, params object[])

ExecuteSQL(string)

Declaration

public override IDataReader ExecuteSQL(string sql)

Parameters

Type	Name	Description
string	sql

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQL(string)

ExecuteSQL(string, int)

Declaration

public override IDataReader ExecuteSQL(string sql, int timeoutSec)

Parameters

Type	Name	Description
string	sql
int	timeoutSec

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQL(string, int)

ExecuteSQLTemp(string, string)

Declaration

public override IDataReader ExecuteSQLTemp(string connectionString, string sql)

Parameters

Type	Name	Description
string	connectionString
string	sql

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQLTemp(string, string)

ExecuteSQLTemp(string, string, int)

Declaration

public override IDataReader ExecuteSQLTemp(string connectionString, string sql, int timeoutSec)

Parameters

Type	Name	Description
string	connectionString
string	sql
int	timeoutSec

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQLTemp(string, string, int)

ExecuteSQLTemp(string, string, int, out string)

Declaration

public override IDataReader ExecuteSQLTemp(string connectionString, string sql, int timeoutSec, out string errorMessage)

Parameters

Type	Name	Description
string	connectionString
string	sql
int	timeoutSec
string	errorMessage

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQLTemp(string, string, int, out string)

ExecuteSQLTemp(string, string, out string)

Declaration

public override IDataReader ExecuteSQLTemp(string connectionString, string sql, out string errorMessage)

Parameters

Type	Name	Description
string	connectionString
string	sql
string	errorMessage

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQLTemp(string, string, out string)

ExecuteScalar<T>(int, string, params object[])

Declaration

public override T ExecuteScalar<T>(int timeoutSec, string procedureName, params object[] commandParameters)

Parameters

Type	Name	Description
int	timeoutSec
string	procedureName
object[]	commandParameters

Returns

Type	Description
T

Type Parameters

Name	Description
T

Overrides

DataProvider.ExecuteScalar<T>(int, string, params object[])

ExecuteScalar<T>(string, params object[])

Declaration

public override T ExecuteScalar<T>(string procedureName, params object[] commandParameters)

Parameters

Type	Name	Description
string	procedureName
object[]	commandParameters

Returns

Type	Description
T

Type Parameters

Name	Description
T

Overrides

DataProvider.ExecuteScalar<T>(string, params object[])

ExecuteScript(string)

Declaration

public override string ExecuteScript(string script)

Parameters

Type	Name	Description
string	script

Returns

Type	Description
string

Overrides

DataProvider.ExecuteScript(string)

ExecuteScript(string, int)

Declaration

public override string ExecuteScript(string script, int timeoutSec)

Parameters

Type	Name	Description
string	script
int	timeoutSec

Returns

Type	Description
string

Overrides

DataProvider.ExecuteScript(string, int)

ExecuteScript(string, string)

Declaration

public override string ExecuteScript(string connectionString, string script)

Parameters

Type	Name	Description
string	connectionString
string	script

Returns

Type	Description
string

Overrides

DataProvider.ExecuteScript(string, string)

ExecuteScript(string, string, int)

Declaration

public override string ExecuteScript(string connectionString, string script, int timeoutSec)

Parameters

Type	Name	Description
string	connectionString
string	script
int	timeoutSec

Returns

Type	Description
string

Overrides

DataProvider.ExecuteScript(string, string, int)

Extension Methods

JsonExtensionsWeb.ToJson(object)