Show / Hide Table of Contents

Class Soundex

Soundex is a database-specific algorithm that returns a phonetic representation of the argument string expression. These values should not be stored, only used in comparisons, in order to avoid problems when moving from one database to another.

Inheritance
Object
QueryElement
Argument
ArgumentFunction
Soundex
Implements
ICloneable
Inherited Members
ArgumentFunction.GetMainField()
ArgumentFunction.ArgumentObject
Argument.Equal(Argument)
Argument.UnEqual(Argument)
Argument.LessThan(Argument)
Argument.LessThanOrEqual(Argument)
Argument.GreaterThan(Argument)
Argument.GreaterThanOrEqual(Argument)
Argument.Like(Argument)
Argument.Like(String)
Argument.NotLike(Argument)
Argument.NotBetween(Argument, Argument)
Argument.Between(Argument, Argument)
Argument.In(Argument[])
Argument.HasAny(Argument[])
Argument.HasAll(Argument[])
Argument.MissingAny(Argument[])
Argument.MissingAll(Argument[])
Argument.IsNull()
Argument.IsNotNull()
Argument.NotIn(Argument[])
Argument.ToArgumentArray<T>(T[])
Argument.ToArgumentArray<T>(T[], Boolean)
Argument.GetSubElements()
Argument.Alias
Argument.DataType
Argument.Size
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public class Soundex : ArgumentFunction, ICloneable
Remarks

While the actual algorithm varies between databases, the return value is generally a short string, that is a coded representation of the phonetic properties of the string. Similar source strings will result in identical codes. More documentation can be found here:

Sybasehttp://dcx.sybase.com/1200/en/uladmin_en12/soundex-function.html
Oraclehttp://docs.oracle.com/cd/B19306_01/server.102/b14200/functions148.htm
SQL Serverhttp://msdn.microsoft.com/en-us/library/ms187384.aspx
Typical usage is to compare the soundex'es of two fields within a query. If they match, then the fields are the same or phonetically very close.

Constructors

Soundex(Argument)

Construct the query element, argument should be a field reference or another string-valued function

Declaration
public Soundex(Argument arg)
Parameters
Type Name Description
Argument arg

Methods

Clone()

Deep clone of query element and argument

Declaration
public override object Clone()
Returns
Type Description
Object
Overrides
QueryElement.Clone()

ToString()

ToString override for debugging

Declaration
public override string ToString()
Returns
Type Description
String
Overrides
Object.ToString()

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top