DbCompare Class

This non-creatable class contains helper methods for performing type-agnostic comparisons necessary when working with values whose types are not exactly known until runtime, such as DataRow column values. All methods are null and DBNull aware. This non-creatable class contains helper methods for performing type-agnostic comparisons necessary when working with values whose types are not exactly known until runtime, such as DataRow column values. All methods are null and DBNull aware.

Object Model

Syntax

Visual Basic
C#
Delphi
JScript
Managed Extensions for C++
C++/CLI

'Declaration
 
<System.Diagnostics.DebuggerStepThroughAttribute()>
Public MustInherit NotInheritable Class DbCompare

'Usage
 
Dim instance As DbCompare

[System.Diagnostics.DebuggerStepThrough()]
public static class DbCompare

public class DbCompare abstract; sealed;

System.Diagnostics.DebuggerStepThroughAttribute()
public abstract sealed class DbCompare

[System.Diagnostics.DebuggerStepThrough()]
public __gc abstract __sealed class DbCompare

[System.Diagnostics.DebuggerStepThrough()]
public ref class DbCompare abstract sealed

Remarks

One of the problems with comparing column values is that the type of a column may vary from database to database (such as using a string instead of a number) or the data type may not be exactly as expected. For example, many of the values we consider to be integers are really stored as decimal in the database. This leads to problems with comparisons (because (int)1 does not equal (decimal)1). These helper methods convert the arguments to the same type before comparision. There is a performance implication here, but it is offset by the increased resilence of the code to column type changes.

Inheritance Hierarchy

System.Object
Miner.Data.Access.DbCompare

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DbCompare Members
Miner.Data.Access Namespace