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:

Sybase	http://dcx.sybase.com/1200/en/uladmin_en12/soundex-function.html
Oracle	http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions148.htm
SQL Server	http://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)