PFExternalConnection_Location_SQL Class |
Contains the information required to access
the SQL data source of a PFExternalConnection.
Currently, this location will target a SQL table from an Access or MS SQL Server database.
Inheritance HierarchySystemObject
Packflow.CorePFExternalConnection_Location
Packflow.CorePFExternalConnection_Location_SQL
Packflow.CorePFExternalConnection_Location
Packflow.CorePFExternalConnection_Location_SQL
Namespace: Packflow.Core
Assembly: MicaSystems.Packflow.Core (in MicaSystems.Packflow.Core.dll) Version: 1.0.0.0 (3.2.0.306)
SyntaxC#
[DataContractAttribute] public class PFExternalConnection_Location_SQL : PFExternalConnection_Location
The PFExternalConnection_Location_SQL type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | PFExternalConnection_Location_SQL |
Properties| Name | Description | |
|---|---|---|
 | ConnectionString |
Gets or sets the connection string targeting the SQL database.
|
| DatabaseType |
Gets or sets the type of targeted database.
|
| Query |
Gets or sets the SQL query used to obtain the data from the database.
This is optional.
|
| TableName |
Gets or sets the name of the SQL table where the data can be found.
Note: you should include the schema name, "SCHEMA.TABLE". |
| Type |
Gets the type of location in an enum form.
(Overrides PFExternalConnection_LocationType.) |
Methods| Name | Description | |
|---|---|---|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
Extension Methods| Name | Description | |
|---|---|---|
 | AsT |
Casts an object to another type. Returns default(T) if the object is null.
(Defined by Utils_Other.) |
| EqualsAll |
Checks that this object is equal to every object in parameters.
(Defined by Utils_Other.) |
| EqualsAny |
Checks that this object is equal to at least one of the parameters.
(Defined by Utils_Other.) |
| GetString |
Converts an object to String using ToString() method, else returns String.Empty.
(Defined by Utils_Other.) |
| IsGenericList | Overloaded.
Checks if this object is a System.Collections.Generic.List.
(Defined by Utils_Linq.) |
| IsGenericList(Type) | Overloaded.
Checks if this object is a System.Collections.Generic.List using type as T.
(Defined by Utils_Linq.) |
| Serialize | Overloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.) |
| Serialize(String) | Overloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.) |
| SerializeJson | Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.) |
| SerializeJson(ListType) | Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.) |
| SerializeJson(DataContractJsonSerializerSettings) | Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.) |
See Also