Home
  • Simple
  • Detailed
  • Westwind Utilities
  • User Guide
    • Managing Configuration Settings with AppConfiguration
      • Basic Implemention of an AppConfiguration Subclass
      • Creating an Application wide, static Configuration Instance
      • Using Other Providers with AppConfiguration
      • Configuration with IConfigurationProviders
      • Storing Configuration Settings in .NET Configuration Files
      • Encrypting Property Keys
      • Storing Configuration Settings in a File, String or SQL Server
      • Adding Complex Types in .config Files
      • Keeping Properties from getting serialized
    • SqlDataAccess - A lightweight ADO.NET Data Access Layer
      • Connection Management
      • Executing Queries
      • Executing NonQueries
      • Executing Stored Procedures
      • Passing Parameters to Queries
  • Class Reference
    • Westwind.Utilities
      • System.IO
        • MemoryStreamExtensions
          • AsString
          • FromString
        • StreamExtensions
          • AsBytes
          • AsBytesAsync
          • AsString
      • Westwind.Utilities
        • AsyncUtils
          • DelayExecution
            • DelayExecution
          • FireAndForget
            • FireAndForget
          • RunSync
            • RunSync
            • RunSync
            • RunSync
          • Timeout
          • TimeoutWithResult
        • ComObject
          • Constructor
          • Constructor
          • Constructor
          • CreateFirstFrom
          • CreateFromProgId
          • Detach
          • Dispose
          • TryGetIndex
          • TryGetMember
          • TryInvokeMember
          • TrySetMember
        • DataUtils
          • CopyDataRow
          • CopyObjectData
            • CopyObjectData
            • CopyObjectData
            • CopyObjectData
          • CopyObjectFromDataRow
          • CopyObjectToDataRow
          • DataReaderToIEnumerable
          • DataReaderToList
          • DataReaderToObject
          • DataReaderToObjectList
          • DataTableToObjectList
          • DataTableToTypedList
          • DbTypeToDotNetType
          • DotNetTypeToDbType
          • DotNetTypeToSqlType
          • GenerateUniqueId
          • GenerateUniqueNumericId
          • GetRandomNumber
          • IndexOfByteArray
            • IndexOfByteArray
          • InitializeDataRowWithBlanks
          • RemoveBytes
          • SqlTypeToDotNetType
        • DebugUtils
          • GetInnerExceptions
          • GetInnerMostException
          • GetTextWithLineNumbers
          • ParseStackTrace
        • DelegateFactory
          • Create
            • Create
        • Encryption
          • BinaryToBinHex
          • BinHexToBinary
          • ComputeHash
            • ComputeHash
            • ComputeHash
          • DecryptBytes
            • DecryptBytes
            • DecryptBytes
            • DecryptBytes
            • DecryptBytes
          • DecryptString
            • DecryptString
            • DecryptString
          • EncryptBytes
            • EncryptBytes
            • EncryptBytes
            • EncryptBytes
          • EncryptString
            • EncryptString
            • EncryptString
          • GetChecksumFromBytes
          • GetChecksumFromFile
          • GZipFile
          • GZipMemory
            • GZipMemory
            • GZipMemory
        • Expando
          • Constructor
          • Constructor
          • Constructor
          • Contains
          • GetDynamicMemberNames
          • GetProperties
          • GetProperty
          • Initialize
          • InvokeMethod
          • SetProperty
          • TryGetMember
          • TryInvokeMember
          • TrySetMember
        • FileUtils
          • AddTrailingSlash
            • AddTrailingSlash
          • BreakFilenameIntoWords
          • CamelCaseSafeFilename
          • CopyDirectory
            • CopyDirectory
          • CopyFileEnsureDirectory
          • CopyStream
            • CopyStream
          • DeleteFiles
          • DeleteTimedoutFiles
          • ExpandPathEnvironmentVariables
          • FilePathAsUrl
          • FindFileInHierarchy
          • FindFilesInHierarchy
          • GetChecksumFromFile
          • GetCompactPath
          • GetFileEncoding
          • GetPhysicalPath
          • GetRelativeFilePath
          • GetRelativePath
          • GetShortPath
          • GetTempFilenameWithExtension
          • GetWindowsLongFilename
          • HasInvalidPathCharacters
          • IsRelativePath
          • NormalizeDirectory
          • NormalizePath
          • OpenStreamReaderWithEncoding
          • ReadAllBytesAsync
          • ReadAllTextAsync
          • ResolvePath
          • SafeFilename
          • TildefyUserPath
          • WriteAllBytesAsync
          • WriteAllTextAsync
        • GenericUtils
          • Inlist
            • Inlist
          • InList
            • InList
        • HtmlUtils
          • BinaryToEmbeddedBase64
          • DisplayMemo
          • DisplayMemoEncoded
          • EmbeddedBase64ToBinary
          • FixHTMLForDisplay
          • GetRelativeUrlPath
          • GetSiteBasePath
          • Href
            • Href
          • HtmlAbstract
          • HtmlEncode
          • ImgRef
          • SanitizeHtml
          • StripHtml
        • HttpClientRequestSettings
          • Constructor
          • AddPostFile
          • AddPostKey
            • AddPostKey
            • AddPostKey
            • AddPostKey
          • GetPostBuffer
          • GetPostBufferBytes
          • GetResponseDataAsync
          • GetResponseErrorMessage
          • GetResponseJson
          • GetResponseStringAsync
          • ResetPostData
          • SetPostStream
          • ToString
          • CapturedRequestContent
          • CapturedResponseContent
          • Credentials
          • Encoding
          • ErrorException
          • ErrorMessage
          • HasErrors
          • HasResponseContent
          • Headers
          • HttpVerb
          • HttpVersion
          • IgnoreCertificateErrors
          • IsRawData
          • MaxResponseSize
          • PreAuthenticate
          • Proxy
          • Request
          • RequestContent
          • RequestContentType
          • RequestFormPostMode
          • Response
          • ResponseByteData
          • ResponseStatusCode
          • ThrowExceptions
          • Timeout
          • Url
          • UserAgent
        • HttpClientUtils
          • Constructor
          • ApplySettingsToRequest
          • DownloadJsonAsync
            • DownloadJsonAsync
          • DownloadResponseMessage
          • DownloadResponseMessageAsync
          • DownloadString
          • DownloadStringAsync
            • DownloadStringAsync
          • GetHttpClient
        • HttpRequestSettings
          • Constructor
          • CapturedRequestContent
          • CapturedResponseContent
          • Content
          • ContentType
          • Credentials
          • DontThrowOnErrorStatusCodes
          • Encoding
          • Headers
          • HttpVerb
          • HttpVersion
          • IsRawData
          • PreAuthenticate
          • Proxy
          • Response
          • ResponseByteData
          • ResponseStatusCode
          • Timeout
          • Url
          • UserAgent
        • HttpUtils
          • CreateWebProxy
          • DownloadImageToFile
          • DownloadImageToFileAsync
          • HttpRequestBytes
            • HttpRequestBytes
          • HttpRequestBytesAsync
            • HttpRequestBytesAsync
          • HttpRequestString
            • HttpRequestString
          • HttpRequestStringAsync
            • HttpRequestStringAsync
          • JsonRequest
          • JsonRequestAsync
        • HttpUtilsWebClient
          • Constructor
          • GetWebRequest
          • GetWebResponse
            • GetWebResponse
          • Request
          • Response
          • Settings
        • ImageUtils
          • GetExtensionFromMediaType
          • GetImageMediaTypeFromFilename
          • IsImage
            • IsImage
        • JsonSerializationUtils
          • CreateJsonNet
          • Deserialize
            • Deserialize
          • DeserializeFromFile
            • DeserializeFromFile
          • FormatJsonString
          • Serialize
          • SerializeToFile
        • LanguageUtils
          • IgnoreErrors
            • IgnoreErrors
        • NetworkUtils
          • GetBaseDomain
            • GetBaseDomain
          • IsLocalIpAddress
            • IsLocalIpAddress
        • ObjectFactory
          • Constructor
          • CreateObject
          • CreateThreadScopedObject
          • GetUniqueObjectKey
        • PasswordScrubber
          • Constructor
          • ObscureValue
          • ScrubJsonValues
          • ScrubSqlConnectionStringValues
        • PropertyBag
          • Constructor
          • CreateFromXml
        • PropertyBag
          • Constructor
          • CreateFromXml
          • FromXml
          • GetSchema
          • ReadXml
          • ToXml
          • WriteXml
        • ReflectionUtils
          • CallMethod
            • CallMethod
          • CallMethodCom
          • CallMethodEx
          • CallMethodExCom
          • CallStaticMethod
          • CreateComInstance
          • CreateInstanceFromString
          • CreateInstanceFromType
          • GetEnumList
          • GetField
          • GetProperty
          • GetPropertyCom
          • GetPropertyEx
          • GetPropertyExCom
          • GetPropertyInfoEx
          • GetPropertyInfoInternal
          • GetStaticProperty
            • GetStaticProperty
          • GetTypeFromName
            • GetTypeFromName
          • InvokeEvent
          • IsAnonoymousType
          • LoadAssembly
          • SetField
          • SetProperty
          • SetPropertyCom
          • SetPropertyEx
          • SetPropertyExCom
          • ShallowClone
          • StringToTypedValue
            • StringToTypedValue
          • TypedValueToString
        • Scheduler
          • Constructor
          • AddItem
            • AddItem
            • AddItem
            • AddItem
          • Dispose
          • GetNextItem
          • OnError
          • OnExecuteScheduledEvent
          • PingServer
          • Start
            • Start
          • Stop
          • Cancelled
          • CheckFrequency
          • Items
          • WebServerPingUrl
        • SchedulerItem
          • Constructor
          • Data
          • Entered
          • TextData
          • Type
        • SecureStringExtensions
          • GetString
        • SerializationUtils
          • DeSerializeObject
            • DeSerializeObject
            • DeSerializeObject
            • DeSerializeObject
          • ObjectToString
          • SerializeObject
            • SerializeObject
            • SerializeObject
            • SerializeObject
          • SerializeObjectToString
        • ShellUtils
          • ExecuteCommandLine
          • ExecuteProcess
            • ExecuteProcess
            • ExecuteProcess
          • GoUrl
          • HttpGet
            • HttpGet
          • HttpGetBytes
            • HttpGetBytes
          • OpenFileInExplorer
          • OpenTerminal
          • OpenUrl
          • ShellExecute
          • ShowHtml
          • ShowString
          • ShowText
        • StringSerializer
          • Deserialize
          • DeserializeObject
          • SerializeObject
        • StringUtils
          • Base36Decode
          • Base36Encode
          • BinaryToBinHex
          • BinHexToBinary
          • BreakIntoWords
          • BytesToString
          • Contains
          • ContainsAny
            • ContainsAny
            • ContainsAny
            • ContainsAny
          • CountLines
          • DetokenizeString
          • EqualsAny
            • EqualsAny
          • EqualsNoCase
          • ExtractString
          • FromBase64String
          • FromCamelCase
          • GetLastCharacters
          • GetLines
          • GetMaxCharacters
          • GetProperty
          • GetUrlEncodedKey
          • IndexOfNth
            • IndexOfNth
          • Inlist
            • Inlist
          • IsStringInList
          • LastIndexOfNth
            • LastIndexOfNth
          • LogString
          • NewStringId
          • NormalizeIndentation
          • NormalizeLineFeeds
          • Occurs
            • Occurs
          • ParseDecimal
          • ParseInt
          • ProperCase
          • RandomString
          • ReplaceLastNthInstance
          • ReplaceMany
            • ReplaceMany
            • ReplaceMany
            • ReplaceMany
          • ReplaceString
          • ReplaceStringInstance
          • Replicate
            • Replicate
          • Right
          • SetProperty
          • SetUrlEncodedKey
          • StartsWithAny
            • StartsWithAny
          • StreamToString
          • StringToBytes
          • StringToStream
          • StripAfter
          • StripNonNumber
          • TerminateString
          • TextAbstract
          • ToBase64String
          • ToCamelCase
          • ToJsonString
          • TokenizeString
          • TrimEnd
          • TrimStart
          • TrimTo
          • Truncate
          • UrlDecode
          • UrlEncode
          • UrlEncodePathSafe
        • TimeUtils
          • DateTimeFromDateAndTime
            • DateTimeFromDateAndTime
          • FractionalHoursToString
            • FractionalHoursToString
          • FriendlyDateString
          • FriendlyElapsedTimeString
            • FriendlyElapsedTimeString
            • FriendlyElapsedTimeString
          • IsBetween
            • IsBetween
          • MimeDateTime
          • RoundDateToMinuteInterval
            • RoundDateToMinuteInterval
          • ShortDateString
            • ShortDateString
          • ShortTimeString
          • ToTimeZoneTime
            • ToTimeZoneTime
          • Truncate
        • UrlEncodingParser
          • Constructor
          • Parse
          • SetValues
          • ToString
        • UrlParser
          • Constructor
          • ExpandUrls
        • ValidationError
          • Constructor
          • Constructor
          • Constructor
          • Constructor
          • ToString
          • ControlID
          • ID
          • Message
        • ValidationErrorCollection
          • Constructor
          • Add
            • Add
          • AddFormat
          • Assert
            • Assert
            • Assert
            • Assert
          • Remove
          • ToHtml
          • ToString
            • ToString
          • HasErrors
          • Item
        • VersionExtensions
          • CompareVersions
          • FormatVersion
            • FormatVersion
        • XmlUtils
          • CreateXmlNamespaceManager
          • GetXmlAttributeBool
          • GetXmlAttributeInt
          • GetXmlAttributeString
          • GetXmlBool
          • GetXmlDateTime
          • GetXmlDecimal
          • GetXmlEnum
          • GetXmlInt
          • GetXmlNode
          • GetXmlString
          • MapTypeToXmlType
          • MapXmlTypeToType
          • XmlString
        • LateBoundMethod
          • Constructor
          • BeginInvoke
          • EndInvoke
          • Invoke
        • DataAccessProviderTypes
          • MySql
          • PostgreSql
          • SqLite
          • SqlServer
        • DateTimeResolution
          • Day
          • Hour
          • Millisecond
          • Minute
          • Month
          • Second
          • Tick
          • Year
        • HttpFormPostMode
          • MultiPart
          • UrlEncoded
        • LineFeedTypes
          • Auto
          • CrLf
          • Lf
        • ObjectToStringTypes
          • Fields
          • Properties
          • PropertiesAndFields
        • PathReturnOptions
          • PathAndHash
          • PathAndQuery
          • PathAndQueryAndHash
          • PathOnly
        • RoundingDirection
          • Round
          • RoundDown
          • RoundUp
        • TerminalModes
          • Bash
          • Command
          • Powershell
      • Westwind.Utilities.Configuration
        • AppConfiguration
          • Constructor
          • Initialize
          • OnCreateDefaultProvider
          • OnInitialize
          • Read
            • Read
            • Read
            • Read
            • Read
            • Read
          • Write
          • WriteAsString
        • ConfigurationProviderBase
          • Constructor
          • CreateConfigurationInstance
          • DecryptFields
          • EncryptFields
          • Read
            • Read
            • Read
            • Read
          • SetError
            • SetError
          • Write
          • WriteAsString
          • ConfigurationSection
          • EncryptionKey
          • ErrorMessage
          • PropertiesToEncrypt
        • JsonFileConfigurationProvider
          • Constructor
          • Read
            • Read
          • Write
          • JsonConfigurationFile
        • StringConfigurationProvider
          • Constructor
          • Read
            • Read
          • Write
          • InitialStringData
        • XmlFileConfigurationProvider
          • Constructor
          • Read
            • Read
          • Write
          • UseBinarySerialization
          • XmlConfigurationFile
        • IConfigurationProvider
          • DecryptFields
          • EncryptFields
          • Read
            • Read
            • Read
            • Read
          • Write
          • WriteAsString
          • ConfigurationSection
          • EncryptionKey
          • ErrorMessage
          • PropertiesToEncrypt
      • Westwind.Utilities.Extensions
        • DateTimeExtensions
          • BeginningOfDay
          • BeginningOfMonth
          • Between
          • EndOfDay
          • EndOfMonth
        • DictionaryExtensions
          • FromXml
          • ToXml
      • Westwind.Utilities.InternetTools
        • HttpClient
          • Constructor
          • ReceiveDataDelegate
          • ReceiveDataDelegate
          • AddPostFile
          • AddPostKey
            • AddPostKey
            • AddPostKey
            • AddPostKey
          • CreateWebRequestObject
          • Dispose
          • DownloadBytes
          • DownloadBytesAsync
          • DownloadFile
          • DownloadResponse
          • DownloadResponseAsync
          • DownloadStream
          • DownloadString
          • DownloadStringAsync
          • DownloadStringPartial
          • GetPostBuffer
          • GetUrl
          • GetUrlFile
          • GetUrlPartial
          • GetUrlResponse
          • ResetPostData
          • SetPostStream
          • StreamPostBuffer
          • BufferSize
          • Cancelled
          • ContentType
          • Cookies
          • Error
          • ErrorMessage
          • HandleCookies
          • HttpTimings
          • HttpVerb
          • IgnoreCertificateErrors
          • Password
          • PostMode
          • ProxyAddress
          • ProxyBypass
          • ProxyPassword
          • ProxyUsername
          • ThrowExceptions
          • Timeout
          • TimeoutMs
          • UseGZip
          • UserAgent
          • Username
          • WebRequest
          • WebResponse
        • HttpTimings
          • Constructor
          • IsEmpty
          • StartRequest
          • FirstByteTime
          • LastByteTime
          • StartedTime
          • TimeToFirstByteMs
          • TimeToLastByteMs
        • SmtpClientNative
          • Constructor
          • AddAlternateView
          • AddHeader
          • AddHeadersFromString
          • Close
          • Connect
          • Dispose
          • GetMessage
          • LoadSmtpClient
          • LogString
          • SendMail
          • SendMailAsync
          • SendMailRun
          • SendMessage
        • delSmtpNativeEvent
          • Constructor
          • BeginInvoke
          • EndInvoke
          • Invoke
        • HttpPostMode
          • Json
          • MultiPart
          • Raw
          • UrlEncoded
          • Xml
      • Westwind.Utilities.Linq
        • LinqExtensions
          • FlattenTree
    • Westwind.Utilities.Data
      • Westwind.Utilities.Configuration
        • SqlServerConfigurationProvider
          • Constructor
          • Read
            • Read
          • Write
          • ConnectionString
          • Key
          • ProviderFactory
          • Tablename
      • Westwind.Utilities.Data
        • ConnectionStringInfo
          • Constructor
          • GetConnectionStringInfo
          • ConnectionString
          • Provider
        • DataAccessBase
          • Constructor
          • Constructor
          • Constructor
          • Constructor
          • AddParameters
          • BeginTransaction
          • CloseConnection
            • CloseConnection
          • CommitTransaction
          • CreateCommand
            • CreateCommand
          • CreatePagingCommand
          • CreateParameter
            • CreateParameter
            • CreateParameter
            • CreateParameter
            • CreateParameter
          • Dispose
          • DoesTableExist
          • ExecuteDataSet
            • ExecuteDataSet
            • ExecuteDataSet
            • ExecuteDataSet
          • ExecuteDynamicDataReader
          • ExecuteNonQuery
            • ExecuteNonQuery
          • ExecuteNonQueryAsync
            • ExecuteNonQueryAsync
          • ExecuteReader
            • ExecuteReader
            • ExecuteReader
            • ExecuteReader
          • ExecuteScalar
            • ExecuteScalar
          • ExecuteScalarAsync
            • ExecuteScalarAsync
          • ExecuteStoredProcedureNonQuery
          • ExecuteStoredProcedureReader
            • ExecuteStoredProcedureReader
          • ExecuteTable
            • ExecuteTable
          • Find
          • FindEx
          • FindKey
          • GetConnectionInfo
          • GetEntity
            • GetEntity
            • GetEntity
          • GetInsertEntityCommand
          • GetUpdateEntityCommand
            • GetUpdateEntityCommand
          • InsertEntity
          • InsertEntityAsync
          • OpenConnection
          • ParseObjectParameters
          • Query
            • Query
          • QueryList
            • QueryList
          • QueryListWithExclusions
            • QueryListWithExclusions
          • QueryWithExclusions
            • QueryWithExclusions
          • RollbackTransaction
          • RunSqlScript
          • SaveEntity
          • SetError
            • SetError
            • SetError
            • SetError
            • SetError
            • SetError
          • UpdateEntity
            • UpdateEntity
          • Connection
          • ConnectionString
          • ErrorException
          • ErrorMessage
          • ErrorNumber
          • ExecuteWithSchema
          • GetIdentityKeySqlCommand
          • LastIdentityResult
          • LastSql
          • LeftFieldBracket
          • ParameterPrefix
          • RightFieldBracket
          • ThrowExceptions
          • Timeout
          • Transaction
          • UsePositionalParameters
        • DataTableDynamicExtensions
          • DynamicRow
          • DynamicRows
        • DynamicDataReader
          • Constructor
          • TryGetMember
          • TryInvokeMember
        • DynamicDataRow
          • Constructor
          • TryGetMember
          • TrySetMember
        • DynamicDataRows
          • Constructor
          • Dispose
          • MoveNext
          • Reset
        • SqlDataAccess
          • Constructor
          • Constructor
          • Constructor
          • Constructor
          • CreatePagingCommand
        • SqlUtils
          • Constructor
          • CloseConnection
          • GetDataTable
          • GetDbProviderFactory
            • GetDbProviderFactory
            • GetDbProviderFactory
          • GetSqlCommand
          • GetSqlDataReader
      • Westwind.Utilities.Data.Security
        • UserToken
          • Constructor
          • ToString
          • Data
          • Id
          • IsValidated
          • ReferenceId
          • Scope
          • TokenIdentifier
          • Updated
          • UserId
        • UserTokenManager
          • Constructor
          • CreateNewToken
          • CreateUserTokenSqlTable
          • DeleteExpiredTokens
          • DeleteToken
          • DeleteTokenForUserId
          • GetToken
          • GetTokenByTokenIdentifier
          • IsTokenValid
          • IsUserTokenTable
          • SetError
            • SetError
            • SetError
          • AllowMultipleTokensPerUser
          • ErrorMessage
          • Tablename
          • TokenServerConnectionString
          • TokenTimeoutSeconds