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.

Object Model

Syntax

Visual Basic
C#

'Declaration
 
Public NotInheritable Class DbCompare

'Usage
 
Dim instance As DbCompare

public sealed class DbCompare

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 XP SP3 (32-bit and 64-bit), Windows 7 (32-bit and 64-bit)

Not all Operating Systems are supported on all products. Visit the ArcFM Solution Supported Versions page for full details.

Reference

DbCompare Members
Miner.Data.Access Namespace