Returns a list of records from the dest table which related to the source system. collapseRecords=true, only records from dest table which are related to the source tables (.ie., INNER JOIN) collapseRecords=false, all records from dest table including optional related source records (i.e., LEFT JOIN)

Namespace: Caisis.DataAccess
Assembly: Caisis.DataAccess (in Caisis.DataAccess.dll) Version: 4.0.4947.22627

Syntax

C#
public static DataTable GetRelatedRecordsByTableAndKey(
	int patientId,
	string destTable,
	string destTableKeyName,
	Nullable<int> destTableKeyValue,
	string sourceTable,
	string sourceTableKeyName,
	bool collapseRecords
)
Visual Basic
Public Shared Function GetRelatedRecordsByTableAndKey ( 
	patientId As Integer,
	destTable As String,
	destTableKeyName As String,
	destTableKeyValue As Nullable(Of Integer),
	sourceTable As String,
	sourceTableKeyName As String,
	collapseRecords As Boolean
) As DataTable
Visual C++
public:
static DataTable^ GetRelatedRecordsByTableAndKey(
	int patientId, 
	String^ destTable, 
	String^ destTableKeyName, 
	Nullable<int> destTableKeyValue, 
	String^ sourceTable, 
	String^ sourceTableKeyName, 
	bool collapseRecords
)

Parameters

patientId
Type: System..::..Int32
The patient id
destTable
Type: System..::..String
The table which to check for relation
destTableKeyName
Type: System..::..String
The table's pri key used for relation
destTableKeyValue
Type: System..::..Nullable<(Of <(<'Int32>)>)>

[Missing <param name="destTableKeyValue"/> documentation for "M:Caisis.DataAccess.RelatedRecordsDa.GetRelatedRecordsByTableAndKey(System.Int32,System.String,System.String,System.Nullable{System.Int32},System.String,System.String,System.Boolean)"]

sourceTable
Type: System..::..String
The table which to check for relations
sourceTableKeyName
Type: System..::..String

[Missing <param name="sourceTableKeyName"/> documentation for "M:Caisis.DataAccess.RelatedRecordsDa.GetRelatedRecordsByTableAndKey(System.Int32,System.String,System.String,System.Nullable{System.Int32},System.String,System.String,System.Boolean)"]

collapseRecords
Type: System..::..Boolean
True=inner join, False=outer join

Return Value

Type: DataTable

[Missing <returns> documentation for "M:Caisis.DataAccess.RelatedRecordsDa.GetRelatedRecordsByTableAndKey(System.Int32,System.String,System.String,System.Nullable{System.Int32},System.String,System.String,System.Boolean)"]

See Also