Online Help - Region 4: [CORE HL7 MSSQL]
|
|
|
DLL File Name: .Net COREHL7MSSQL.dll .Net Framework COREHL7FWMSSQL.dll
Name Space: .Net COREHL7 .Net Framework COREHL7FW
SQL Schema API Architecture
Class Architecture
The HL7MSSQLController object is your master object it is a subclass of the HL7Controller object of the CORE HL7 API outlined in Region 1. It has ALL of the properties and methods of that object and is created the same way, with an important caveats and some additional classes.
Caveat: This object REQUIRES a CORE Enterprise license as outlined in Licenses And Pricing in Region 1.
Before You Begin Project Development: You should familiarize yourself with COREHL7MSSQLConnector object since these classes are all about working with Microsoft SQL Server and HL7.
private static HL7MSSQLController GetController()
{
string licensefile = "C:\\Licenses\\COREAPI.txt";
return new HL7MSSQLController(licensefile);
}
|
Property
|
Description
|
All Base Class Properties
|
See HL7Controller object in Region 1.
|
There are no new public properties associated with this subclassed object
|
|
Public Methods:
Method
|
Return Value
|
All Base Class Methods
|
See HL7Controller object in Region 1.
|
IfTableExistsSQL(string, string)
|
string (SQL) Pass a table name in parameter 1 and a SQL statement in parameter 2 and will return your SQL statement wrapped in an If Exists(.....) BEGIN...END block. See .
|
IfTableExistsElseSQL(string, string, string)
|
string (SQL) Pass a table name in parameter 1 and a SQL statement in parameter 2 and a SQL statement in parameter 3 and will return your SQL statements wrapped in an If Exists(.....) BEGIN...END..ELSE..BEGIN...END block. See .
|
NewCOREHL7MSSQLSchema(2 parms)
|
Parameter 1: COREHL7MSSQLConnector - VerifyProperties() must be true.
Parameter 2: string - ValidSchemaPrefix(parm2) must be true..
Returns: COREHL7MSSQLSchema object (or null if parameters are not valid)
|
NewMSSQLConnector()
|
COREHL7MSSQLConnector object.
There are 3 different definitions of this method allowing you to pass different constructor values to create your SQL Connector object.
|
ValidSchemaPrefix(string)
|
bool - Returns true if the string in parameter 1 is a valid CORE HL7 SQL Schema false if not.
|
|
See Next: The COREHL7MSSQLSchema Object
