Click or drag to resize

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 Hierarchy

Namespace:  Packflow.Core
Assembly:  MicaSystems.Packflow.Core (in MicaSystems.Packflow.Core.dll) Version: 1.0.0.0 (3.2.0.306)
Syntax
C#
[DataContractAttribute]
public class PFExternalConnection_Location_SQL : PFExternalConnection_Location

The PFExternalConnection_Location_SQL type exposes the following members.

Constructors
Properties
  NameDescription
Public propertyConnectionString
Gets or sets the connection string targeting the SQL database.
Public propertyDatabaseType
Gets or sets the type of targeted database.
Public propertyQuery
Gets or sets the SQL query used to obtain the data from the database. This is optional.
Public propertyTableName
Gets or sets the name of the SQL table where the data can be found.

Note: you should include the schema name, "SCHEMA.TABLE".

Public propertyType
Gets the type of location in an enum form.
(Overrides PFExternalConnection_LocationType.)
Top
Methods
  NameDescription
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
Extension Methods
  NameDescription
Public Extension MethodAsT
Casts an object to another type. Returns default(T) if the object is null.
(Defined by Utils_Other.)
Public Extension MethodEqualsAll
Checks that this object is equal to every object in parameters.
(Defined by Utils_Other.)
Public Extension MethodEqualsAny
Checks that this object is equal to at least one of the parameters.
(Defined by Utils_Other.)
Public Extension MethodGetString
Converts an object to String using ToString() method, else returns String.Empty.
(Defined by Utils_Other.)
Public Extension MethodIsGenericListOverloaded.
Checks if this object is a System.Collections.Generic.List.
(Defined by Utils_Linq.)
Public Extension MethodIsGenericList(Type)Overloaded.
Checks if this object is a System.Collections.Generic.List using type as T.
(Defined by Utils_Linq.)
Public Extension MethodSerializeOverloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.)
Public Extension MethodSerialize(String)Overloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.)
Public Extension MethodSerializeJsonOverloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.)
Public Extension MethodSerializeJson(ListType)Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.)
Public Extension MethodSerializeJson(DataContractJsonSerializerSettings)Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.)
Top
See Also