Show / Hide Table of Contents

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, 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, 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.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.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)
Back to top by the community, for the community... #DNNCMS