Class SqlDataProvider

Inheritance

System.Object

DataProvider

SqlDataProvider

Inherited Members

DataProvider.ConnectionString

DataProvider.DatabaseOwner

DataProvider.DefaultProviderName

DataProvider.ObjectQualifier

DataProvider.ProviderName

DataProvider.ProviderPath

DataProvider.UpgradeConnectionString

DataProvider.Instance()

DataProvider.CommitTransaction(DbTransaction)

DataProvider.GetTransaction()

DataProvider.RollbackTransaction(DbTransaction)

DataProvider.GetNull(Object)

DataProvider.FindDatabaseVersion(Int32, Int32, Int32)

DataProvider.GetDatabaseEngineVersion()

DataProvider.GetDatabaseVersion()

DataProvider.GetDatabaseInstallVersion()

DataProvider.GetVersion()

DataProvider.GetInstallVersion()

DataProvider.GetConnectionStringBuilder()

DataProvider.GetProviderPath()

DataProvider.TestDatabaseConnection(DbConnectionStringBuilder, String, String)

DataProvider.UpdateDatabaseVersion(Int32, Int32, Int32, String)

DataProvider.UpdateDatabaseVersionIncrement(Int32, Int32, Int32, Int32, String)

DataProvider.GetLastAppliedIteration(Int32, Int32, Int32)

DataProvider.GetUnappliedIterations(String)

DataProvider.GetHostSetting(String)

DataProvider.GetHostSettings()

DataProvider.UpdateHostSetting(String, String, Boolean, Int32)

DataProvider.DeleteServer(Int32)

DataProvider.GetServers()

DataProvider.UpdateServer(Int32, String, String, Boolean, String)

DataProvider.UpdateServerActivity(String, String, DateTime, DateTime, Int32, Boolean)

DataProvider.CreatePortal(String, String, DateTime, Double, Double, Int32, Int32, Int32, String, Int32)

DataProvider.CreatePortal(String, String, DateTime, Double, Double, Int32, Int32, Int32, String, String, Int32)

DataProvider.DeletePortalInfo(Int32)

DataProvider.DeletePortalSetting(Int32, String, String)

DataProvider.DeletePortalSettings(Int32, String)

DataProvider.GetExpiredPortals()

DataProvider.GetPortals(String)

DataProvider.GetAllPortals()

DataProvider.GetPortalsByName(String, Int32, Int32)

DataProvider.GetPortalsByUser(Int32)

DataProvider.GetPortalSettings(Int32, String)

DataProvider.GetPortalSpaceUsed(Int32)

DataProvider.UpdatePortalInfo(Int32, Int32, String, String, String, DateTime, Int32, Int32, String, Int32, Double, Double, Int32, Int32, String, String, String, String, String, String, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, String, String, Int32, String)

DataProvider.UpdatePortalSetting(Int32, String, String, Int32, String, Boolean)

DataProvider.UpdatePortalSetup(Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, String)

DataProvider.AddTabAfter(TabInfo, Int32, Int32)

DataProvider.AddTabBefore(TabInfo, Int32, Int32)

DataProvider.AddTabToEnd(TabInfo, Int32)

DataProvider.DeleteTab(Int32)

DataProvider.DeleteTabSetting(Int32, String)

DataProvider.DeleteTabSettings(Int32)

DataProvider.DeleteTabUrl(Int32, Int32)

DataProvider.DeleteTabVersion(Int32)

DataProvider.DeleteTabVersionDetail(Int32)

DataProvider.DeleteTabVersionDetailByModule(Int32)

DataProvider.DeleteTranslatedTabs(Int32, String)

DataProvider.EnsureNeutralLanguage(Int32, String)

DataProvider.ConvertTabToNeutralLanguage(Int32, Int32, String)

DataProvider.GetAllTabs()

DataProvider.GetTab(Int32)

DataProvider.GetTabByUniqueID(Guid)

DataProvider.GetTabPanes(Int32)

DataProvider.GetTabPaths(Int32, String)

DataProvider.GetTabs(Int32)

DataProvider.GetTabsByModuleID(Int32)

DataProvider.GetTabsByTabModuleID(Int32)

DataProvider.GetTabsByPackageID(Int32, Int32, Boolean)

DataProvider.GetTabSetting(Int32, String)

DataProvider.GetTabSettings(Int32)

DataProvider.GetTabAliasSkins(Int32)

DataProvider.GetTabCustomAliases(Int32)

DataProvider.GetTabUrls(Int32)

DataProvider.GetTabVersions(Int32)

DataProvider.GetTabVersionDetails(Int32)

DataProvider.GetTabVersionDetailsHistory(Int32, Int32)

DataProvider.GetCustomAliasesForTabs()

DataProvider.LocalizeTab(Int32, String, Int32)

DataProvider.MoveTabAfter(Int32, Int32, Int32)

DataProvider.MoveTabBefore(Int32, Int32, Int32)

DataProvider.MoveTabToParent(Int32, Int32, Int32)

DataProvider.SaveTabUrl(Int32, Int32, Int32, Int32, String, String, String, String, Boolean, Int32)

DataProvider.SaveTabVersion(Int32, Int32, DateTime, Int32, Boolean, Int32, Int32)

DataProvider.SaveTabVersionDetail(Int32, Int32, Int32, Int32, String, Int32, Int32, Int32, Int32)

DataProvider.UpdateTab(Int32, Int32, Int32, Guid, Guid, Guid, String, Boolean, Boolean, Int32, String, String, String, String, String, Boolean, String, String, String, DateTime, DateTime, Int32, String, Boolean, Boolean, Single, Int32, String, Boolean)

DataProvider.UpdateTabOrder(Int32, Int32, Int32, Int32)

DataProvider.UpdateTabSetting(Int32, String, String, Int32)

DataProvider.UpdateTabTranslationStatus(Int32, Guid, Int32)

DataProvider.MarkAsPublished(Int32)

DataProvider.UpdateTabVersion(Int32, Guid)

DataProvider.AddModule(Int32, Int32, Int32, Boolean, DateTime, DateTime, Boolean, Boolean, Boolean, Boolean, Int32)

DataProvider.AddTabModule(Int32, Int32, String, String, String, Int32, String, Int32, String, String, String, String, String, Int32, String, Boolean, Boolean, Boolean, Boolean, String, DateTime, Int32, Guid, Guid, Guid, Guid, String, Int32)

DataProvider.DeleteModule(Int32)

DataProvider.DeleteModuleSetting(Int32, String)

DataProvider.DeleteModuleSettings(Int32)

DataProvider.DeleteTabModule(Int32, Int32, Boolean, Int32)

DataProvider.DeleteTabModuleSetting(Int32, String)

DataProvider.DeleteTabModuleSettings(Int32)

DataProvider.GetTabModuleSettingsByName(Int32, String)

DataProvider.GetTabModuleIdsBySettingNameAndValue(Int32, String, String)

DataProvider.GetAllModules()

DataProvider.GetAllTabsModules(Int32, Boolean)

DataProvider.GetAllTabsModulesByModuleID(Int32)

DataProvider.GetModule(Int32, Int32)

DataProvider.GetModuleByDefinition(Int32, String)

DataProvider.GetModuleByUniqueID(Guid)

DataProvider.GetModules(Int32)

DataProvider.GetModuleSetting(Int32, String)

DataProvider.GetModuleSettings(Int32)

DataProvider.GetModuleSettingsByTab(Int32)

DataProvider.GetSearchModules(Int32)

DataProvider.GetTabModule(Int32)

DataProvider.GetTabModuleOrder(Int32, String)

DataProvider.GetTabModules(Int32)

DataProvider.GetTabModuleSetting(Int32, String)

DataProvider.GetTabModuleSettings(Int32)

DataProvider.GetTabModuleSettingsByTab(Int32)

DataProvider.MoveTabModule(Int32, Int32, Int32, String, Int32)

DataProvider.RestoreTabModule(Int32, Int32)

DataProvider.UpdateModule(Int32, Int32, Int32, Boolean, DateTime, DateTime, Boolean, Boolean, Boolean, Boolean, Int32)

DataProvider.UpdateModuleLastContentModifiedOnDate(Int32)

DataProvider.UpdateModuleOrder(Int32, Int32, Int32, String)

DataProvider.UpdateModuleSetting(Int32, String, String, Int32)

DataProvider.UpdateTabModule(Int32, Int32, Int32, String, String, String, Int32, String, Int32, String, String, String, String, String, Int32, String, Boolean, Boolean, Boolean, Boolean, String, DateTime, Int32, Guid, Guid, Guid, String, Int32)

DataProvider.UpdateTabModuleTranslationStatus(Int32, Guid, Int32)

DataProvider.UpdateTabModuleSetting(Int32, String, String, Int32)

DataProvider.UpdateTabModuleVersion(Int32, Guid)

DataProvider.UpdateTabModuleVersionByModule(Int32)

DataProvider.GetInstalledModules()

DataProvider.AddDesktopModule(Int32, String, String, String, String, String, Boolean, Boolean, String, Int32, Int32, String, String, String, Int32, Int32, String, String)

DataProvider.DeleteDesktopModule(Int32)

DataProvider.GetDesktopModules()

DataProvider.GetDesktopModulesByPortal(Int32)

DataProvider.UpdateDesktopModule(Int32, Int32, String, String, String, String, String, Boolean, Boolean, String, Int32, Int32, String, String, String, Int32, Int32, String, String)

DataProvider.AddPortalDesktopModule(Int32, Int32, Int32)

DataProvider.DeletePortalDesktopModules(Int32, Int32)

DataProvider.GetPortalDesktopModules(Int32, Int32)

DataProvider.AddModuleDefinition(Int32, String, String, Int32, Int32)

DataProvider.DeleteModuleDefinition(Int32)

DataProvider.GetModuleDefinitions()

DataProvider.UpdateModuleDefinition(Int32, String, String, Int32, Int32)

DataProvider.AddModuleControl(Int32, String, String, String, String, Int32, Int32, String, Boolean, Boolean, Int32)

DataProvider.DeleteModuleControl(Int32)

DataProvider.GetModuleControls()

DataProvider.UpdateModuleControl(Int32, Int32, String, String, String, String, Int32, Int32, String, Boolean, Boolean, Int32)

DataProvider.AddFolder(Int32, Guid, Guid, String, String, Int32, Boolean, Boolean, DateTime, Int32, Int32, Boolean, Int32, Int32)

DataProvider.DeleteFolder(Int32, String)

DataProvider.GetFolder(Int32)

DataProvider.GetFolder(Int32, String)

DataProvider.GetFolderByUniqueID(Guid)

DataProvider.GetFoldersByPortal(Int32)

DataProvider.GetFoldersByPortalAndPermissions(Int32, String, Int32)

DataProvider.GetLegacyFolderCount()

DataProvider.UpdateFolder(Int32, Guid, Int32, String, Int32, String, Boolean, Boolean, DateTime, Int32, Int32, Boolean, Int32, Int32)

DataProvider.UpdateFolderVersion(Int32, Guid)

DataProvider.UpdateLegacyFolders()

DataProvider.AddFile(Int32, Guid, Guid, String, String, Int64, Int32, Int32, String, String, Int32, Int32, String, DateTime, String, String, DateTime, DateTime, Boolean, Int32)

DataProvider.SetFileHasBeenPublished(Int32, Boolean)

DataProvider.CountLegacyFiles()

DataProvider.ClearFileContent(Int32)

DataProvider.DeleteFile(Int32, String, Int32)

DataProvider.DeleteFiles(Int32)

DataProvider.GetAllFiles()

DataProvider.GetFile(String, Int32, Boolean)

DataProvider.GetFileById(Int32, Boolean)

DataProvider.GetFileByUniqueID(Guid)

DataProvider.GetFileContent(Int32)

DataProvider.GetFileVersionContent(Int32, Int32)

DataProvider.GetFiles(Int32, Boolean, Boolean)

DataProvider.UpdateFile(Int32, Guid, String, String, Int64, Int32, Int32, String, Int32, Int32, String, DateTime, String, String, DateTime, DateTime, Boolean, Int32)

DataProvider.UpdateFileLastModificationTime(Int32, DateTime)

DataProvider.UpdateFileHashCode(Int32, String)

DataProvider.UpdateFileContent(Int32, Byte[])

DataProvider.UpdateFileVersion(Int32, Guid)

DataProvider.AddPermission(String, Int32, String, String, Int32)

DataProvider.DeletePermission(Int32)

DataProvider.UpdatePermission(Int32, String, Int32, String, String, Int32)

DataProvider.AddModulePermission(Int32, Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.DeleteModulePermission(Int32)

DataProvider.DeleteModulePermissionsByModuleID(Int32, Int32)

DataProvider.DeleteModulePermissionsByUserID(Int32, Int32)

DataProvider.GetModulePermission(Int32)

DataProvider.GetModulePermissionsByModuleID(Int32, Int32)

DataProvider.GetModulePermissionsByPortal(Int32)

DataProvider.GetModulePermissionsByTabID(Int32)

DataProvider.UpdateModulePermission(Int32, Int32, Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.AddTabPermission(Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.DeleteTabPermission(Int32)

DataProvider.DeleteTabPermissionsByTabID(Int32)

DataProvider.DeleteTabPermissionsByUserID(Int32, Int32)

DataProvider.GetTabPermissionsByPortal(Int32)

DataProvider.GetTabPermissionsByTabID(Int32, Int32)

DataProvider.UpdateTabPermission(Int32, Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.AddFolderPermission(Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.GetPortalPermissionsByPortal(Int32)

DataProvider.AddPortalPermission(Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.DeletePortalPermission(Int32)

DataProvider.DeletePortalPermissionsByPortalID(Int32)

DataProvider.DeletePortalPermissionsByUserID(Int32, Int32)

DataProvider.DeleteFolderPermission(Int32)

DataProvider.DeleteFolderPermissionsByFolderPath(Int32, String)

DataProvider.DeleteFolderPermissionsByUserID(Int32, Int32)

DataProvider.GetFolderPermission(Int32)

DataProvider.GetFolderPermissionsByFolderPath(Int32, String, Int32)

DataProvider.GetFolderPermissionsByPortal(Int32)

DataProvider.GetFolderPermissionsByPortalAndPath(Int32, String)

DataProvider.UpdateFolderPermission(Int32, Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.AddDesktopModulePermission(Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.DeleteDesktopModulePermission(Int32)

DataProvider.DeleteDesktopModulePermissionsByPortalDesktopModuleID(Int32)

DataProvider.DeleteDesktopModulePermissionsByUserID(Int32, Int32)

DataProvider.GetDesktopModulePermission(Int32)

DataProvider.GetDesktopModulePermissions()

DataProvider.GetDesktopModulePermissionsByPortalDesktopModuleID(Int32)

DataProvider.UpdateDesktopModulePermission(Int32, Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.AddRoleGroup(Int32, String, String, Int32)

DataProvider.DeleteRoleGroup(Int32)

DataProvider.GetRoleGroup(Int32, Int32)

DataProvider.GetRoleGroupByName(Int32, String)

DataProvider.GetRoleGroups(Int32)

DataProvider.UpdateRoleGroup(Int32, String, String, Int32)

DataProvider.AddRole(Int32, Int32, String, String, Single, String, String, Single, Int32, String, Boolean, Boolean, String, String, Int32, Int32, Int32, Boolean)

DataProvider.DeleteRole(Int32)

DataProvider.GetPortalRoles(Int32)

DataProvider.GetRoles()

DataProvider.GetRolesBasicSearch(Int32, Int32, Int32, String)

DataProvider.GetRoleSettings(Int32)

DataProvider.UpdateRole(Int32, Int32, String, String, Single, String, String, Single, Int32, String, Boolean, Boolean, String, String, Int32, Int32, Int32, Boolean)

DataProvider.UpdateRoleSetting(Int32, String, String, Int32)

DataProvider.AddUser(Int32, String, String, String, Int32, Boolean, String, String, Boolean, Boolean, Int32)

DataProvider.AddUserPortal(Int32, Int32)

DataProvider.ChangeUsername(Int32, String)

DataProvider.DeleteUserFromPortal(Int32, Int32)

DataProvider.GetAllUsers(Int32, Int32, Int32, Boolean, Boolean)

DataProvider.GetDeletedUsers(Int32)

DataProvider.GetUnAuthorizedUsers(Int32, Boolean, Boolean)

DataProvider.GetUser(Int32, Int32)

DataProvider.GetUserByAuthToken(Int32, String, String)

DataProvider.GetUserByDisplayName(Int32, String)

DataProvider.GetUserByUsername(Int32, String)

DataProvider.GetUserByUsername(String, String)

DataProvider.GetUserByVanityUrl(Int32, String)

DataProvider.GetUserByPasswordResetToken(Int32, String)

DataProvider.GetDisplayNameForUser(Int32, String)

DataProvider.GetUserCountByPortal(Int32)

DataProvider.GetUsersAdvancedSearch(Int32, Int32, Int32, Int32, Int32, Boolean, Int32, Int32, String, Boolean, String, String)

DataProvider.GetUsersBasicSearch(Int32, Int32, Int32, String, Boolean, String, String)

DataProvider.GetUsersByEmail(Int32, String, Int32, Int32, Boolean, Boolean)

DataProvider.GetUsersByProfileProperty(Int32, String, String, Int32, Int32, Boolean, Boolean)

DataProvider.GetUsersByRolename(Int32, String)

DataProvider.GetUsersByUsername(Int32, String, Int32, Int32, Boolean, Boolean)

DataProvider.GetUsersByDisplayname(Int32, String, Int32, Int32, Boolean, Boolean)

DataProvider.GetDuplicateEmailCount(Int32)

DataProvider.GetSingleUserByEmail(Int32, String)

DataProvider.RemoveUser(Int32, Int32)

DataProvider.ReplaceServerOnSchedules(String, String)

DataProvider.ResetTermsAgreement(Int32)

DataProvider.RestoreUser(Int32, Int32)

DataProvider.UpdateUser(Int32, Int32, String, String, Boolean, String, String, String, Boolean, Boolean, Boolean, String, Guid, DateTime, Boolean, Int32)

DataProvider.UpdateUserLastIpAddress(Int32, String)

DataProvider.UserAgreedToTerms(Int32, Int32)

DataProvider.UserRequestsRemoval(Int32, Int32, Boolean)

DataProvider.AddUserRole(Int32, Int32, Int32, Int32, Boolean, DateTime, DateTime, Int32)

DataProvider.DeleteUserRole(Int32, Int32)

DataProvider.GetServices(Int32, Int32)

DataProvider.GetUserRole(Int32, Int32, Int32)

DataProvider.GetUserRoles(Int32, Int32)

DataProvider.GetUserRolesByUsername(Int32, String, String)

DataProvider.UpdateUserRole(Int32, Int32, Boolean, DateTime, DateTime, Int32)

DataProvider.DeleteUsersOnline(Int32)

DataProvider.GetOnlineUser(Int32)

DataProvider.GetOnlineUsers(Int32)

DataProvider.UpdateUsersOnline(Hashtable)

DataProvider.AddPropertyDefinition(Int32, Int32, Int32, String, String, String, Boolean, Boolean, String, Int32, Boolean, Int32, Int32, Int32)

DataProvider.DeletePropertyDefinition(Int32)

DataProvider.GetPropertyDefinition(Int32)

DataProvider.GetPropertyDefinitionByName(Int32, String)

DataProvider.GetPropertyDefinitionsByPortal(Int32)

DataProvider.GetUserProfile(Int32)

DataProvider.UpdateProfileProperty(Int32, Int32, Int32, String, Int32, String, DateTime)

DataProvider.UpdatePropertyDefinition(Int32, Int32, String, String, String, Boolean, Boolean, String, Int32, Boolean, Int32, Int32, Int32)

DataProvider.SearchProfilePropertyValues(Int32, String, String)

DataProvider.AddSkinControl(Int32, String, String, Boolean, Int32)

DataProvider.DeleteSkinControl(Int32)

DataProvider.GetSkinControls()

DataProvider.GetSkinControl(Int32)

DataProvider.GetSkinControlByKey(String)

DataProvider.GetSkinControlByPackageID(Int32)

DataProvider.UpdateSkinControl(Int32, Int32, String, String, Boolean, Int32)

DataProvider.AddSkin(Int32, String)

DataProvider.AddSkinPackage(Int32, Int32, String, String, Int32)

DataProvider.CanDeleteSkin(String, String)

DataProvider.DeleteSkin(Int32)

DataProvider.DeleteSkinPackage(Int32)

DataProvider.GetSkinByPackageID(Int32)

DataProvider.GetSkinPackage(Int32, String, String)

DataProvider.UpdateSkin(Int32, String)

DataProvider.UpdateSkinPackage(Int32, Int32, Int32, String, String, Int32)

DataProvider.AddProfile(Int32, Int32)

DataProvider.GetAllProfiles()

DataProvider.GetProfile(Int32, Int32)

DataProvider.UpdateProfile(Int32, Int32, String)

DataProvider.AddUrl(Int32, String)

DataProvider.AddUrlLog(Int32, Int32)

DataProvider.AddUrlTracking(Int32, String, String, Boolean, Boolean, Int32, Boolean)

DataProvider.DeleteUrl(Int32, String)

DataProvider.DeleteUrlTracking(Int32, String, Int32)

DataProvider.GetUrl(Int32, String)

DataProvider.GetUrlLog(Int32, DateTime, DateTime)

DataProvider.GetUrls(Int32)

DataProvider.GetUrlTracking(Int32, String, Int32)

DataProvider.UpdateUrlTracking(Int32, String, Boolean, Boolean, Int32, Boolean)

DataProvider.UpdateUrlTrackingStats(Int32, String, Int32)

DataProvider.GetDefaultLanguageByModule(String)

DataProvider.GetSearchCommonWordsByLocale(String)

DataProvider.GetSearchIndexers()

DataProvider.GetSearchResultModules(Int32)

DataProvider.GetSearchSettings(Int32)

DataProvider.AddListEntry(String, String, String, Int32, Int32, Boolean, Int32, String, Int32, Boolean, Int32)

DataProvider.DeleteList(String, String)

DataProvider.DeleteListEntryByID(Int32, Boolean)

DataProvider.DeleteListEntryByListName(String, String, Boolean)

DataProvider.GetList(String, String, Int32)

DataProvider.GetListEntriesByListName(String, String, Int32)

DataProvider.GetListEntry(String, String)

DataProvider.GetListEntry(Int32)

DataProvider.GetLists(Int32)

DataProvider.UpdateListEntry(Int32, String, String, String, Int32)

DataProvider.UpdateListSortOrder(Int32, Boolean)

DataProvider.AddPortalAlias(Int32, String, String, String, String, Boolean, Int32)

DataProvider.DeletePortalAlias(Int32)

DataProvider.GetPortalAliases()

DataProvider.GetPortalByPortalAliasID(Int32)

DataProvider.UpdatePortalAlias(String, Int32)

DataProvider.UpdatePortalAliasInfo(Int32, Int32, String, String, String, String, Boolean, Int32)

DataProvider.AddEventMessage(String, Int32, String, String, String, String, String, String, String, DateTime, DateTime, String)

DataProvider.GetEventMessages(String)

DataProvider.GetEventMessagesBySubscriber(String, String)

DataProvider.SetEventMessageComplete(Int32)

DataProvider.AddAuthentication(Int32, String, Boolean, String, String, String, Int32)

DataProvider.AddUserAuthentication(Int32, String, String, Int32)

DataProvider.GetUserAuthentication(Int32)

DataProvider.DeleteAuthentication(Int32)

DataProvider.GetAuthenticationService(Int32)

DataProvider.GetAuthenticationServiceByPackageID(Int32)

DataProvider.GetAuthenticationServiceByType(String)

DataProvider.GetAuthenticationServices()

DataProvider.GetEnabledAuthenticationServices()

DataProvider.UpdateAuthentication(Int32, Int32, String, Boolean, String, String, String, Int32)

DataProvider.AddPackage(Int32, String, String, String, String, String, String, String, String, String, String, String, String, Boolean, Int32, String, String)

DataProvider.DeletePackage(Int32)

DataProvider.GetModulePackagesInUse(Int32, Boolean)

DataProvider.GetPackageDependencies()

DataProvider.GetPackages(Int32)

DataProvider.GetPackageTypes()

DataProvider.RegisterAssembly(Int32, String, String)

DataProvider.SavePackageDependency(Int32, Int32, String, String)

DataProvider.UnRegisterAssembly(Int32, String)

DataProvider.UpdatePackage(Int32, Int32, String, String, String, String, String, String, String, String, String, String, String, Boolean, Int32, String, String)

DataProvider.SetCorePackageVersions()

DataProvider.AddLanguage(String, String, String, Int32)

DataProvider.AddLanguagePack(Int32, Int32, Int32, Int32)

DataProvider.AddPortalLanguage(Int32, Int32, Boolean, Int32)

DataProvider.DeleteLanguage(Int32)

DataProvider.DeleteLanguagePack(Int32)

DataProvider.DeletePortalLanguages(Int32, Int32)

DataProvider.EnsureLocalizationExists(Int32, String)

DataProvider.RemovePortalLocalization(Int32, String)

DataProvider.GetPortalLocalizations(Int32)

DataProvider.GetLanguages()

DataProvider.GetLanguagePackByPackage(Int32)

DataProvider.GetLanguagesByPortal(Int32)

DataProvider.GetPortalDefaultLanguage(Int32)

DataProvider.UpdateLanguage(Int32, String, String, String, Int32)

DataProvider.UpdateLanguagePack(Int32, Int32, Int32, Int32, Int32)

DataProvider.UpdatePortalDefaultLanguage(Int32, String)

DataProvider.UpdatePortalLanguage(Int32, Int32, Boolean, Int32)

DataProvider.AddDefaultFolderTypes(Int32)

DataProvider.AddFolderMapping(Int32, String, String, Int32)

DataProvider.AddFolderMappingSetting(Int32, String, String, Int32)

DataProvider.DeleteFolderMapping(Int32)

DataProvider.GetFolderMapping(Int32)

DataProvider.GetFolderMappingByMappingName(Int32, String)

DataProvider.GetFolderMappings(Int32)

DataProvider.GetFolderMappingSetting(Int32, String)

DataProvider.GetFolderMappingSettings(Int32)

DataProvider.UpdateFolderMapping(Int32, String, Int32, Int32)

DataProvider.UpdateFolderMappingSetting(Int32, String, String, Int32)

DataProvider.GetPasswordHistory(Int32)

DataProvider.GetPasswordHistory(Int32, Int32, Int32)

DataProvider.AddPasswordHistory(Int32, String, String, Int32)

DataProvider.AddPasswordHistory(Int32, String, String, Int32, Int32)

DataProvider.GetDatabaseTimeUtc()

DataProvider.GetDatabaseTime()

DataProvider.GetDatabaseTimeOffset()

DataProvider.DeletePreviewProfile(Int32)

DataProvider.DeleteRedirection(Int32)

DataProvider.DeleteRedirectionRule(Int32)

DataProvider.GetAllRedirections()

DataProvider.GetPreviewProfiles(Int32)

DataProvider.GetRedirectionRules(Int32)

DataProvider.GetRedirections(Int32)

DataProvider.SavePreviewProfile(Int32, Int32, String, Int32, Int32, String, Int32, Int32)

DataProvider.SaveRedirection(Int32, Int32, String, Int32, Int32, Int32, Boolean, Int32, Object, Boolean, Int32)

DataProvider.SaveRedirectionRule(Int32, Int32, String, String)

DataProvider.AddLog(String, String, Int32, String, Int32, String, DateTime, String, String, Int32, ExceptionInfo, Boolean)

DataProvider.AddLogType(String, String, String, String, String)

DataProvider.AddLogTypeConfigInfo(Boolean, String, String, Int32, Boolean, Int32, Int32, Int32, String, String)

DataProvider.ClearLog()

DataProvider.DeleteLog(String)

DataProvider.DeleteLogType(String)

DataProvider.DeleteLogTypeConfigInfo(String)

DataProvider.GetEventLogPendingNotif(Int32)

DataProvider.GetEventLogPendingNotifConfig()

DataProvider.GetLogs(Int32, String, Int32, Int32)

DataProvider.GetLogTypeConfigInfo()

DataProvider.GetLogTypeConfigInfoByID(Int32)

DataProvider.GetLogTypeInfo()

DataProvider.GetSingleLog(String)

DataProvider.PurgeLog()

DataProvider.UpdateEventLogPendingNotif(Int32)

DataProvider.UpdateLogType(String, String, String, String, String)

DataProvider.UpdateLogTypeConfigInfo(String, Boolean, String, String, Int32, Boolean, Int32, Int32, Int32, String, String)

DataProvider.AddSchedule(String, Int32, String, Int32, String, Int32, String, Boolean, Boolean, String, String, Int32, String, DateTime)

DataProvider.AddScheduleHistory(Int32, DateTime, String)

DataProvider.AddScheduleItemSetting(Int32, String, String)

DataProvider.DeleteSchedule(Int32)

DataProvider.GetNextScheduledTask(String)

DataProvider.GetSchedule()

DataProvider.GetSchedule(String)

DataProvider.GetSchedule(Int32)

DataProvider.GetSchedule(String, String)

DataProvider.GetScheduleByEvent(String, String)

DataProvider.GetScheduleHistory(Int32)

DataProvider.GetScheduleItemSettings(Int32)

DataProvider.PurgeScheduleHistory()

DataProvider.UpdateSchedule(Int32, String, Int32, String, Int32, String, Int32, String, Boolean, Boolean, String, String, Int32, String, DateTime)

DataProvider.UpdateScheduleHistory(Int32, DateTime, Boolean, String, DateTime)

DataProvider.AddExtensionUrlProvider(Int32, Int32, String, String, String, Boolean, Boolean, Boolean, Boolean)

DataProvider.DeleteExtensionUrlProvider(Int32)

DataProvider.GetExtensionUrlProviders(Int32)

DataProvider.SaveExtensionUrlProviderSetting(Int32, Int32, String, String)

DataProvider.UpdateExtensionUrlProvider(Int32, Boolean)

DataProvider.GetIPFilters()

DataProvider.AddIPFilter(String, String, Int32, Int32)

DataProvider.AddIPFilter(String, String, Int32, Int32, String)

DataProvider.DeleteIPFilter(Int32)

DataProvider.UpdateIPFilter(Int32, String, String, Int32, Int32)

DataProvider.UpdateIPFilter(Int32, String, String, Int32, Int32, String)

DataProvider.GetIPFilter(Int32)

DataProvider.GetFileVersions(Int32)

DataProvider.GetFileVersionsInFolder(Int32)

DataProvider.AddFileVersion(Int32, Guid, Guid, String, String, Int64, Int32, Int32, String, String, Int32, Int32, String, DateTime, String, Boolean, DateTime, DateTime, Int32, Boolean, Byte[])

DataProvider.DeleteFileVersion(Int32, Int32)

DataProvider.ResetFilePublishedVersion(Int32)

DataProvider.GetFileVersion(Int32, Int32)

DataProvider.SetPublishedVersion(Int32, Int32)

DataProvider.GetContentWorkflowUsageCount(Int32)

DataProvider.GetContentWorkflowUsage(Int32, Int32, Int32)

DataProvider.GetContentWorkflowStateUsageCount(Int32)

DataProvider.AddContentWorkflow(Int32, String, String, Boolean, Boolean, Boolean, Boolean)

DataProvider.GetContentWorkflow(Int32)

DataProvider.GetContentWorkflows(Int32)

DataProvider.UpdateContentWorkflow(Int32, String, String, Boolean, Boolean, Boolean, Boolean)

DataProvider.AddContentWorkflowState(Int32, String, Int32, Boolean, Boolean, Boolean, Boolean, String, String, String, String)

DataProvider.DeleteContentWorkflowState(Int32)

DataProvider.UpdateContentWorkflowState(Int32, String, Int32, Boolean, Boolean, Boolean, Boolean, String, String, String, String)

DataProvider.GetContentWorkflowState(Int32)

DataProvider.GetContentWorkflowStates(Int32)

DataProvider.AddContentWorkflowLog(String, String, Int32, Int32, Int32)

DataProvider.GetContentWorkflowLogs(Int32, Int32)

DataProvider.DeleteContentWorkflowLogs(Int32, Int32)

DataProvider.AddContentWorkflowStatePermission(Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.UpdateContentWorkflowStatePermission(Int32, Int32, Int32, Int32, Boolean, Int32, Int32)

DataProvider.DeleteContentWorkflowStatePermission(Int32)

DataProvider.GetContentWorkflowStatePermission(Int32)

DataProvider.GetContentWorkflowStatePermissions()

DataProvider.GetContentWorkflowStatePermissionsByStateID(Int32)

DataProvider.GetContentWorkflowSource(Int32, String)

DataProvider.AddContentWorkflowSource(Int32, String, String)

DataProvider.GetAllSearchTypes()

DataProvider.GetAllSynonymsGroups(Int32, String)

DataProvider.AddSynonymsGroup(String, Int32, Int32, String)

DataProvider.UpdateSynonymsGroup(Int32, String, Int32)

DataProvider.DeleteSynonymsGroup(Int32)

DataProvider.GetSearchStopWords(Int32, String)

DataProvider.AddSearchStopWords(String, Int32, Int32, String)

DataProvider.UpdateSearchStopWords(Int32, String, Int32)

DataProvider.DeleteSearchStopWords(Int32)

DataProvider.AddSearchDeletedItems(SearchDocumentToDelete)

DataProvider.DeleteProcessedSearchDeletedItems(DateTime)

DataProvider.GetSearchDeletedItems(DateTime)

DataProvider.GetAvailableUsersForIndex(Int32, DateTime, Int32, Int32)

DataProvider.AddOutputCacheItem(Int32, String, String, DateTime)

DataProvider.GetOutputCacheItem(String)

DataProvider.GetOutputCacheItemCount(Int32)

DataProvider.GetOutputCacheKeys()

DataProvider.GetOutputCacheKeys(Int32)

DataProvider.PurgeExpiredOutputCacheItems()

DataProvider.PurgeOutputCache()

DataProvider.RemoveOutputCacheItem(Int32)

DataProvider.AddRedirectMessage(Int32, Int32, String)

DataProvider.GetRedirectMessage(Guid)

DataProvider.DeleteOldRedirectMessage(DateTime)

DataProvider.UpdateAuthCookie(String, DateTime, Int32)

DataProvider.FindAuthCookie(String)

DataProvider.DeleteAuthCookie(String)

DataProvider.DeleteExpiredAuthCookies(DateTime)

DataProvider.SetAllPortalTabsSecure(Int32, Boolean)

DataProvider.ExecuteDataSet(String, Object[])

DataProvider.ExecuteScalar(String, Object[])

DataProvider.ExecuteSQL(String, IDataParameter[])

DataProvider.GetFiles(Int32, Boolean)

Namespace: DotNetNuke.Data

Assembly: DotNetNuke.dll

Syntax

public sealed class SqlDataProvider : DataProvider

Properties

| Improve this Doc View Source

IsConnectionValid

Declaration

public override bool IsConnectionValid { get; }

Property Value

Type	Description
System.Boolean

Overrides

DataProvider.IsConnectionValid

| Improve this Doc View Source

Settings

Declaration

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

Property Value

Type	Description
Dictionary<System.String, System.String>

Overrides

DataProvider.Settings

Methods

| Improve this Doc View Source

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
System.String	procedureName
System.String	tableParameterName
DataTable	dataTable
Dictionary<System.String, System.Object>	commandParameters

Overrides

DataProvider.BulkInsert(String, String, DataTable, Dictionary<String, Object>)

| Improve this Doc View Source

BulkInsert(String, String, DataTable, Int32, Dictionary<String, Object>)

Declaration

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

Parameters

Type	Name	Description
System.String	procedureName
System.String	tableParameterName
DataTable	dataTable
System.Int32	timeoutSec
Dictionary<System.String, System.Object>	commandParameters

Overrides

DataProvider.BulkInsert(String, String, DataTable, Int32, Dictionary<String, Object>)

| Improve this Doc View Source

BulkInsert(String, String, DataTable, Int32)

Declaration

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

Parameters

Type	Name	Description
System.String	procedureName
System.String	tableParameterName
DataTable	dataTable
System.Int32	timeoutSec

Overrides

DataProvider.BulkInsert(String, String, DataTable, Int32)

| Improve this Doc View Source

BulkInsert(String, String, DataTable)

Declaration

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

Parameters

Type	Name	Description
System.String	procedureName
System.String	tableParameterName
DataTable	dataTable

Overrides

DataProvider.BulkInsert(String, String, DataTable)

| Improve this Doc View Source

ExecuteNonQuery(Int32, String, Object[])

Declaration

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

Parameters

Type	Name	Description
System.Int32	timeoutSec
System.String	procedureName
System.Object[]	commandParameters

Overrides

DataProvider.ExecuteNonQuery(Int32, String, Object[])

| Improve this Doc View Source

ExecuteNonQuery(String, Object[])

Declaration

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

Parameters

Type	Name	Description
System.String	procedureName
System.Object[]	commandParameters

Overrides

DataProvider.ExecuteNonQuery(String, Object[])

| Improve this Doc View Source

ExecuteReader(Int32, String, Object[])

Declaration

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

Parameters

Type	Name	Description
System.Int32	timeoutSec
System.String	procedureName
System.Object[]	commandParameters

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteReader(Int32, String, Object[])

| Improve this Doc View Source

ExecuteReader(String, Object[])

Declaration

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

Parameters

Type	Name	Description
System.String	procedureName
System.Object[]	commandParameters

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteReader(String, Object[])

| Improve this Doc View Source

ExecuteScalar<T>(Int32, String, Object[])

Declaration

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

Parameters

Type	Name	Description
System.Int32	timeoutSec
System.String	procedureName
System.Object[]	commandParameters

Returns

Type	Description
T

Type Parameters

Name	Description
T

Overrides

DataProvider.ExecuteScalar<T>(Int32, String, Object[])

| Improve this Doc View Source

ExecuteScalar<T>(String, Object[])

Declaration

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

Parameters

Type	Name	Description
System.String	procedureName
System.Object[]	commandParameters

Returns

Type	Description
T

Type Parameters

Name	Description
T

Overrides

DataProvider.ExecuteScalar<T>(String, Object[])

| Improve this Doc View Source

ExecuteScript(String, Int32)

Declaration

public override string ExecuteScript(string script, int timeoutSec)

Parameters

Type	Name	Description
System.String	script
System.Int32	timeoutSec

Returns

Type	Description
System.String

Overrides

DataProvider.ExecuteScript(String, Int32)

| Improve this Doc View Source

ExecuteScript(String, String, Int32)

Declaration

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

Parameters

Type	Name	Description
System.String	connectionString
System.String	script
System.Int32	timeoutSec

Returns

Type	Description
System.String

Overrides

DataProvider.ExecuteScript(String, String, Int32)

| Improve this Doc View Source

ExecuteScript(String, String)

Declaration

public override string ExecuteScript(string connectionString, string script)

Parameters

Type	Name	Description
System.String	connectionString
System.String	script

Returns

Type	Description
System.String

Overrides

DataProvider.ExecuteScript(String, String)

| Improve this Doc View Source

ExecuteScript(String)

Declaration

public override string ExecuteScript(string script)

Parameters

Type	Name	Description
System.String	script

Returns

Type	Description
System.String

Overrides

DataProvider.ExecuteScript(String)

| Improve this Doc View Source

ExecuteSQL(String, Int32)

Declaration

public override IDataReader ExecuteSQL(string sql, int timeoutSec)

Parameters

Type	Name	Description
System.String	sql
System.Int32	timeoutSec

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQL(String, Int32)

| Improve this Doc View Source

ExecuteSQL(String)

Declaration

public override IDataReader ExecuteSQL(string sql)

Parameters

Type	Name	Description
System.String	sql

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQL(String)

| Improve this Doc View Source

ExecuteSQLTemp(String, String, Int32, out String)

Declaration

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

Parameters

Type	Name	Description
System.String	connectionString
System.String	sql
System.Int32	timeoutSec
System.String	errorMessage

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQLTemp(String, String, Int32, out String)

| Improve this Doc View Source

ExecuteSQLTemp(String, String, Int32)

Declaration

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

Parameters

Type	Name	Description
System.String	connectionString
System.String	sql
System.Int32	timeoutSec

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQLTemp(String, String, Int32)

| Improve this Doc View Source

ExecuteSQLTemp(String, String, out String)

Declaration

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

Parameters

Type	Name	Description
System.String	connectionString
System.String	sql
System.String	errorMessage

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQLTemp(String, String, out String)

| Improve this Doc View Source

ExecuteSQLTemp(String, String)

Declaration

public override IDataReader ExecuteSQLTemp(string connectionString, string sql)

Parameters

Type	Name	Description
System.String	connectionString
System.String	sql

Returns

Type	Description
IDataReader

Overrides

DataProvider.ExecuteSQLTemp(String, String)

Extension Methods

JsonExtensionsWeb.ToJson(Object)