Show / Hide Table of Contents

Class QuerySource

Represents query source code with pre-processed pragmas

Inheritance
System.Object
QuerySource
Implements
INamed
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: NFX.DataAccess.CRUD
Assembly: NFX.dll
Syntax
public sealed class QuerySource : INamed
Examples

pragma

modify=tbl_patient key=counter,ssn ignore=doctor_phone,doctor_id load= store= @last_name=lname @first_name=fname .doctor_id=This is description for column

select t1.ssn, t1.lname as last_name, t1.fname as first_name, t1.c_doctor, t2.phone as doctor_phone, t2.NPI as doctor_id from tbl_patient t1 left outer join tbl_doctor t2 on t1.c_doctor = t2.counter where t1.lname like ?LN

Constructors

QuerySource(String, String)

Declaration
public QuerySource(string name, string source)
Parameters
Type Name Description
System.String name
System.String source

Fields

COLUMN_ALIAS_PREFIX

Declaration
public const string COLUMN_ALIAS_PREFIX = "@"
Field Value
Type Description
System.String

COLUMN_DESCRIPTION_PREFIX

Declaration
public const string COLUMN_DESCRIPTION_PREFIX = "."
Field Value
Type Description
System.String

COLUMN_IGNORE_SECTION

Declaration
public const string COLUMN_IGNORE_SECTION = "ignore"
Field Value
Type Description
System.String

COLUMN_INVISIBLE_SECTION

Declaration
public const string COLUMN_INVISIBLE_SECTION = "invisible"
Field Value
Type Description
System.String

COLUMN_KEY_SECTION

Declaration
public const string COLUMN_KEY_SECTION = "key"
Field Value
Type Description
System.String

COLUMN_LOAD_SECTION

Declaration
public const string COLUMN_LOAD_SECTION = "load"
Field Value
Type Description
System.String

COLUMN_REQUIRED_SECTION

Declaration
public const string COLUMN_REQUIRED_SECTION = "required"
Field Value
Type Description
System.String

COLUMN_STORE_SECTION

Declaration
public const string COLUMN_STORE_SECTION = "store"
Field Value
Type Description
System.String

PRAGMA

Declaration
public const string PRAGMA = "#pragma"
Field Value
Type Description
System.String

TABLE_MODIFY_SECTION

Declaration
public const string TABLE_MODIFY_SECTION = "modify"
Field Value
Type Description
System.String

Properties

ColumnDefs

Returns column definitions defined by #pragma

Declaration
public IRegistry<QuerySource.ColumnDef> ColumnDefs { get; }
Property Value
Type Description
IRegistry<QuerySource.ColumnDef>

HasPragma

Returns true when #pragma was defined in source

Declaration
public bool HasPragma { get; }
Property Value
Type Description
System.Boolean

ModifyTarget

Returns modification target (table name to insert/update/delete against) if query is not read-only

Declaration
public string ModifyTarget { get; }
Property Value
Type Description
System.String

Name

Rerurns name of query source

Declaration
public string Name { get; }
Property Value
Type Description
System.String

OriginalSource

Returns original source of query including pragma text (if any)

Declaration
public string OriginalSource { get; }
Property Value
Type Description
System.String

ReadOnly

Returns true when pragma does not specify any modification target (table name to insert/update/delete against)

Declaration
public bool ReadOnly { get; }
Property Value
Type Description
System.Boolean

StatementSource

Returns source of query excluding pragma text (if any was present in the original)

Declaration
public string StatementSource { get; }
Property Value
Type Description
System.String

Implements

INamed

Extension Methods

MiscUtils.NonNull<T>(T, Func<Exception>, String)
ObjectValueConversion.AsString(Object, String, ConvertErrorHandling)
ObjectValueConversion.AsNonNullOrEmptyString(Object)
ObjectValueConversion.AsLaconicConfig(Object, ConfigSectionNode, String, ConvertErrorHandling)
ObjectValueConversion.AsJSONConfig(Object, ConfigSectionNode, String, ConvertErrorHandling)
ObjectValueConversion.AsXMLConfig(Object, ConfigSectionNode, ConvertErrorHandling)
ObjectValueConversion.AsChar(Object, Char, ConvertErrorHandling)
ObjectValueConversion.AsNullableChar(Object, Nullable<Char>, ConvertErrorHandling)
ObjectValueConversion.AsByte(Object, Byte, ConvertErrorHandling)
ObjectValueConversion.AsNullableByte(Object, Nullable<Byte>, ConvertErrorHandling)
ObjectValueConversion.AsSByte(Object, SByte, ConvertErrorHandling)
ObjectValueConversion.AsNullableSByte(Object, Nullable<SByte>, ConvertErrorHandling)
ObjectValueConversion.AsShort(Object, Int16, ConvertErrorHandling)
ObjectValueConversion.AsNullableShort(Object, Nullable<Int16>, ConvertErrorHandling)
ObjectValueConversion.AsUShort(Object, UInt16, ConvertErrorHandling)
ObjectValueConversion.AsNullableUShort(Object, Nullable<UInt16>, ConvertErrorHandling)
ObjectValueConversion.AsInt(Object, Int32, ConvertErrorHandling)
ObjectValueConversion.AsNullableInt(Object, Nullable<Int32>, ConvertErrorHandling)
ObjectValueConversion.AsUInt(Object, UInt32, ConvertErrorHandling)
ObjectValueConversion.AsNullableUInt(Object, Nullable<UInt32>, ConvertErrorHandling)
ObjectValueConversion.AsLong(Object, Int64, ConvertErrorHandling)
ObjectValueConversion.AsNullableLong(Object, Nullable<Int64>, ConvertErrorHandling)
ObjectValueConversion.AsULong(Object, UInt64, ConvertErrorHandling)
ObjectValueConversion.AsNullableULong(Object, Nullable<UInt64>, ConvertErrorHandling)
ObjectValueConversion.AsDouble(Object, Double, ConvertErrorHandling)
ObjectValueConversion.AsNullableDouble(Object, Nullable<Double>, ConvertErrorHandling)
ObjectValueConversion.AsFloat(Object, Single, ConvertErrorHandling)
ObjectValueConversion.AsNullableFloat(Object, Nullable<Single>, ConvertErrorHandling)
ObjectValueConversion.AsDecimal(Object, Decimal, ConvertErrorHandling)
ObjectValueConversion.AsNullableDecimal(Object, Nullable<Decimal>, ConvertErrorHandling)
ObjectValueConversion.AsBool(Object, Boolean, ConvertErrorHandling)
ObjectValueConversion.AsNullableBool(Object, Nullable<Boolean>, ConvertErrorHandling)
ObjectValueConversion.AsGUID(Object, Guid, ConvertErrorHandling)
ObjectValueConversion.AsNullableGUID(Object, Nullable<Guid>, ConvertErrorHandling)
ObjectValueConversion.AsDateTime(Object)
ObjectValueConversion.AsDateTime(Object, DateTime, ConvertErrorHandling)
ObjectValueConversion.AsNullableDateTime(Object, Nullable<DateTime>, ConvertErrorHandling)
ObjectValueConversion.AsGDID(Object)
ObjectValueConversion.AsGDID(Object, GDID, ConvertErrorHandling)
ObjectValueConversion.AsNullableGDID(Object, Nullable<GDID>, ConvertErrorHandling)
ObjectValueConversion.AsGDIDSymbol(Object)
ObjectValueConversion.AsGDIDSymbol(Object, GDIDSymbol, ConvertErrorHandling)
ObjectValueConversion.AsNullableGDIDSymbol(Object, Nullable<GDIDSymbol>, ConvertErrorHandling)
ObjectValueConversion.AsTimeSpan(Object)
ObjectValueConversion.AsTimeSpan(Object, TimeSpan, ConvertErrorHandling)
ObjectValueConversion.AsNullableTimeSpan(Object, Nullable<TimeSpan>, ConvertErrorHandling)
ObjectValueConversion.AsEnum<TEnum>(Object, TEnum, ConvertErrorHandling)
ObjectValueConversion.AsNullableEnum<TEnum>(Object, Nullable<TEnum>, ConvertErrorHandling)
ObjectValueConversion.AsUri(Object, Uri, ConvertErrorHandling)
JSONExtensions.ToJSON(Object, JSONWritingOptions)
JSONExtensions.ToJSON(Object, TextWriter, JSONWritingOptions)
JSONExtensions.ToJSON(Object, Stream, JSONWritingOptions, Encoding)
ErlObject.ToErlObject(Object)
ErlObject.ToErlObject(Object, ErlTypeOrder, Boolean)
Back to top Copyright © 2006-2018 Agnicore Inc
Generated by DocFX