C# Class TSqlFlex.Core.FieldScripting

Show file Open project: nycdotnet/TSqlFlex Class Usage Examples

Public Methods

Method	Description
DataTypeName ( SQLColumn fieldInfo ) : string
DataTypeParameterIfAny ( SQLColumn fieldInfo ) : string
EscapeObjectName ( string rawObjectName ) : string
EscapeObjectNames ( string dotSeparatedRawObjectNames ) : string
FieldNameOrDefault ( SQLColumn column, int fieldIndex ) : string
NullOrNotNull ( Object allowDbNull ) : string
ResultIsRenderableAsCreateTable ( FlexResult result ) : System.Boolean
ResultIsRenderableAsScriptedData ( FlexResult result ) : System.Boolean
ScriptResultDataAsInsert ( FlexResult result, string tableName, int maxRowsInValuesClause ) : StringBuilder
formatBinary ( object data, int fieldLength ) : string
formatBit ( object data ) : string
formatChar ( object data, bool forTSQLScript = true ) : string
formatDate ( object data, bool forTSQLScript = true ) : string
formatDateTime ( object data, bool forTSQLScript = true ) : string
formatDatetime2 ( object data, bool forTSQLScript = true ) : string
formatDatetimeoffset ( object data, bool forTSQLScript = true ) : string
formatDecimal ( object data ) : string
formatDouble ( object data ) : string
formatGeography ( object data, bool forTSQLScript = true ) : string
formatGeometry ( object data, bool forTSQLScript = true ) : string
formatGuid ( object data, bool forTSQLScript = true ) : string
formatHierarchyId ( object data ) : string
formatImage ( object data ) : string
formatNchar ( object data, bool forTSQLScript = true ) : string
formatNtext ( object data, bool forTSQLScript = true ) : string
formatNvarchar ( object data, bool forTSQLScript = true ) : string
formatSingle ( object data ) : string
formatSmallDateTime ( object data, bool forTSQLScript = true ) : string
formatText ( object data, bool forTSQLScript = true ) : string
formatTime ( object data, bool forTSQLScript = true ) : string
formatTimestamp ( object data ) : string
formatVarbinary ( object data ) : string
formatVarchar ( object data, bool forTSQLScript = true ) : string
formatXml ( object data, bool forTSQLScript = true ) : string
getDataAsAppropriateNumericFormat ( object data ) : string
getDataAsSql_variantFormat ( object data, bool forTSQLScript = true ) : string
latinHexEncodeStringBytes ( string hexEncodedData ) : string
partAfterDecimal ( decimal theDec ) : decimal
partAfterDecimal ( Double theDbl ) : double
partAfterDecimal ( System.Single theSingle ) : double
possiblyEncloseInQuotes ( string theThing, bool useQuotes ) : string
scriptDataAsInsertForSQL2008Plus ( string tableName, FlexResult result, int MaxRowsInValuesClause ) : StringBuilder
valueAsTSQLLiteral ( object data, SQLColumn fieldInfo, bool forTSQLScript = true ) : string

Private Methods

Method	Description
IsBracketEscaped ( string objectName ) : bool
singleQuoteIfTrue ( bool singleQuote, string prependThisString = "" ) : string

Method Details

DataTypeName() public static method

public static DataTypeName ( SQLColumn fieldInfo ) : string
fieldInfo	SQLColumn
return	string

DataTypeParameterIfAny() public static method

public static DataTypeParameterIfAny ( SQLColumn fieldInfo ) : string
fieldInfo	SQLColumn
return	string

EscapeObjectName() public static method

public static EscapeObjectName ( string rawObjectName ) : string
rawObjectName	string
return	string

EscapeObjectNames() public static method

public static EscapeObjectNames ( string dotSeparatedRawObjectNames ) : string
dotSeparatedRawObjectNames	string
return	string

FieldNameOrDefault() public static method

public static FieldNameOrDefault ( SQLColumn column, int fieldIndex ) : string
column	SQLColumn
fieldIndex	int
return	string

NullOrNotNull() public static method

public static NullOrNotNull ( Object allowDbNull ) : string
allowDbNull	Object
return	string

ResultIsRenderableAsCreateTable() public static method

public static ResultIsRenderableAsCreateTable ( FlexResult result ) : System.Boolean
result	FlexResult
return	System.Boolean

ResultIsRenderableAsScriptedData() public static method

public static ResultIsRenderableAsScriptedData ( FlexResult result ) : System.Boolean
result	FlexResult
return	System.Boolean

ScriptResultDataAsInsert() public static method

public static ScriptResultDataAsInsert ( FlexResult result, string tableName, int maxRowsInValuesClause ) : StringBuilder
result	FlexResult
tableName	string
maxRowsInValuesClause	int
return	StringBuilder

formatBinary() public static method

public static formatBinary ( object data, int fieldLength ) : string
data	object
fieldLength	int
return	string

formatBit() public static method

public static formatBit ( object data ) : string
data	object
return	string

formatChar() public static method

public static formatChar ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatDate() public static method

public static formatDate ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatDateTime() public static method

public static formatDateTime ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatDatetime2() public static method

public static formatDatetime2 ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatDatetimeoffset() public static method

public static formatDatetimeoffset ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatDecimal() public static method

public static formatDecimal ( object data ) : string
data	object
return	string

formatDouble() public static method

public static formatDouble ( object data ) : string
data	object
return	string

formatGeography() public static method

public static formatGeography ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatGeometry() public static method

public static formatGeometry ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatGuid() public static method

public static formatGuid ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatHierarchyId() public static method

public static formatHierarchyId ( object data ) : string
data	object
return	string

formatImage() public static method

public static formatImage ( object data ) : string
data	object
return	string

formatNchar() public static method

public static formatNchar ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatNtext() public static method

public static formatNtext ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatNvarchar() public static method

public static formatNvarchar ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatSingle() public static method

public static formatSingle ( object data ) : string
data	object
return	string

formatSmallDateTime() public static method

public static formatSmallDateTime ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatText() public static method

public static formatText ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatTime() public static method

public static formatTime ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatTimestamp() public static method

public static formatTimestamp ( object data ) : string
data	object
return	string

formatVarbinary() public static method

public static formatVarbinary ( object data ) : string
data	object
return	string

formatVarchar() public static method

public static formatVarchar ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

formatXml() public static method

public static formatXml ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

getDataAsAppropriateNumericFormat() public static method

public static getDataAsAppropriateNumericFormat ( object data ) : string
data	object
return	string

getDataAsSql_variantFormat() public static method

public static getDataAsSql_variantFormat ( object data, bool forTSQLScript = true ) : string
data	object
forTSQLScript	bool
return	string

latinHexEncodeStringBytes() public static method

public static latinHexEncodeStringBytes ( string hexEncodedData ) : string
hexEncodedData	string
return	string

partAfterDecimal() public static method

public static partAfterDecimal ( decimal theDec ) : decimal
theDec	decimal
return	decimal

partAfterDecimal() public static method

public static partAfterDecimal ( Double theDbl ) : double
theDbl	Double
return	double

partAfterDecimal() public static method

public static partAfterDecimal ( System.Single theSingle ) : double
theSingle	System.Single
return	double

possiblyEncloseInQuotes() public static method

public static possiblyEncloseInQuotes ( string theThing, bool useQuotes ) : string
theThing	string
useQuotes	bool
return	string

scriptDataAsInsertForSQL2008Plus() public static method

public static scriptDataAsInsertForSQL2008Plus ( string tableName, FlexResult result, int MaxRowsInValuesClause ) : StringBuilder
tableName	string
result	FlexResult
MaxRowsInValuesClause	int
return	StringBuilder

valueAsTSQLLiteral() public static method

public static valueAsTSQLLiteral ( object data, SQLColumn fieldInfo, bool forTSQLScript = true ) : string
data	object
fieldInfo	SQLColumn
forTSQLScript	bool
return	string