Class BaseSqlBuilder

SQL builder base class

Inheritance
Object
BaseSqlBuilder
Inherited Members
Namespace: XData.Database.Dialect
Assembly: XData.docfx.dll
Syntax
[DatabaseAdapter("NONE")]
public abstract class BaseSqlBuilder : ISqlBuilder, ISqlBuilderInternal, IEnumerable<Query>, IEnumerable

Fields

| Improve this Doc View Source

SqlStrings

SQL dialect specific format strings
WARNING! Mast be filled in constructor!

Declaration
protected SortedList<SqlStringType, string> SqlStrings
Field Value
Type Description
SortedList<SqlStringType, String>

Properties

| Improve this Doc View Source

Config

SQL dialect configuration

Declaration
protected IConfiguration Config { get; }
Property Value
Type Description
IConfiguration
| Improve this Doc View Source

Context

Context name

Declaration
protected string Context { get; }
Property Value
Type Description
String
| Improve this Doc View Source

DialectOptions

Dialect options
WARNING! Mast to be filled in constructor!

Declaration
public virtual DialectOptions DialectOptions { get; }
Property Value
Type Description
DialectOptions
| Improve this Doc View Source

Item[Enum]

Predefined queries enumerator

Declaration
public Query this[Enum i] { get; }
Parameters
Type Name Description
Enum i

Predefined query enumeration key
Property Value
Type Description
Query

Query
Exceptions
Type Condition
XDataAdapterException
| Improve this Doc View Source

ParameterPrefix

Parameter prefix symbol

Declaration
public abstract string ParameterPrefix { get; }
Property Value
Type Description
String
| Improve this Doc View Source

Queries

List of predefined queries
WARNING! Mast to be filled in constructor!

Declaration
protected List<Query> Queries { set; }
Property Value
Type Description
List<Query>
| Improve this Doc View Source

SqlBlockVariablePrefix

Declaration
protected virtual string SqlBlockVariablePrefix { get; }
Property Value
Type Description
String
| Improve this Doc View Source

SqlTypes

List of supported SQL types
WARNING! Mast to be filled in constructor!

Declaration
public DbType[] SqlTypes { get; protected set; }
Property Value
Type Description
DbType[]
| Improve this Doc View Source

SqlTypeSizes

List of supported type size applicable
WARNING! Mast to be filled in constructor!

Declaration
public Dictionary<string, SqlTypeSize> SqlTypeSizes { get; protected set; }
Property Value
Type Description
Dictionary<String, SqlTypeSize>
| Improve this Doc View Source

TypeNames

List of supported column type names
WARNING! Mast to be filled in constructor!

Declaration
public string[] TypeNames { get; protected set; }
Property Value
Type Description
String[]
| Improve this Doc View Source

TypeSynonyms

List of supported type synonyms
WARNING! Mast to be filled in constructor!

Declaration
public string[] TypeSynonyms { get; protected set; }
Property Value
Type Description
String[]

Methods

| Improve this Doc View Source

AddOrderBy(IDataStructure, SortedList<String, Object>, ref StringBuilder, ref Query, ref List<Tuple<String, Type, String>>, ICollection<String>, ref SortedList<String, Tuple<String, String>>, ref Dictionary<String, Object>, Boolean)

Add order by statement to query

Declaration
protected virtual void AddOrderBy(IDataStructure structure, SortedList<string, object> filterValues, ref StringBuilder strCommand, ref Query query, ref List<Tuple<string, Type, string>> withSources, ICollection<string> skipped, ref SortedList<string, Tuple<string, string>> fields, ref Dictionary<string, object> paramValues, bool doNotSkip)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
SortedList<String, Object> filterValues

Filter values
StringBuilder strCommand

Query string builder
Query query

Query
List<Tuple<String, Type, String>> withSources

Common-Table-Expression (WITH) data sources
ICollection<String> skipped

Skipped sources collection
SortedList<String, Tuple<String, String>> fields

Parsed fields
Dictionary<String, Object> paramValues

Query parameter values
Boolean doNotSkip

Don't skip empty sources
| Improve this Doc View Source

AddReturning2Command(ref StringBuilder, String, SortedList<Tuple<String, String>, Tuple<String, Boolean, Boolean>>, Boolean, Boolean)

Add returning auto increment identity column values statement in query

Declaration
protected abstract void AddReturning2Command(ref StringBuilder sb, string alias, SortedList<Tuple<string, string>, Tuple<string, bool, bool>> identity, bool defaultValues = false, bool close = false)
Parameters
Type Name Description
StringBuilder sb

Query string builder
String alias

Table alias
SortedList<Tuple<String, String>, Tuple<String, Boolean, Boolean>> identity

Identity column name and parameter name
Boolean defaultValues

Insert default values flag
Boolean close

Close values parenthesis flag
| Improve this Doc View Source

AddSkipLimitAndOrder(IDataStructure, SortedList<String, Object>, ref StringBuilder, Int32, String, ref Query, ref List<Tuple<String, Type, String>>, ICollection<String>, ref SortedList<String, Tuple<String, String>>, ref Dictionary<String, Object>, Boolean)

Add skip, limit, and order statements to query

Declaration
protected abstract void AddSkipLimitAndOrder(IDataStructure structure, SortedList<string, object> filterValues, ref StringBuilder strCommand, int fromPosition, string selectAll, ref Query query, ref List<Tuple<string, Type, string>> withSources, ICollection<string> skipped, ref SortedList<string, Tuple<string, string>> fields, ref Dictionary<string, object> paramValues, bool doNotSkip = false)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
SortedList<String, Object> filterValues

Filter values
StringBuilder strCommand

Query string builder
Int32 fromPosition

From statement start position
String selectAll

All fields list string
Query query

Query
List<Tuple<String, Type, String>> withSources

Common-Table-Expression (WITH) data sources
ICollection<String> skipped

Skipped sources collection
SortedList<String, Tuple<String, String>> fields

Parsed fields
Dictionary<String, Object> paramValues

Query parameter values
Boolean doNotSkip

Don't skip empty sources
| Improve this Doc View Source

Beautify(String)

Returns formatted SQL string

Declaration
public static string Beautify(string sql)
Parameters
Type Name Description
String sql

SQL string to format
Returns
Type Description
String

Formatted SQL string
| Improve this Doc View Source

BeautifyRtf(String)

Returns RTF formatted SQL string

Declaration
public static string BeautifyRtf(string sql)
Parameters
Type Name Description
String sql

SQL string to format
Returns
Type Description
String

RTF formatted SQL string
| Improve this Doc View Source

BuildSqlBlock(Expression<SqlBlockDefinition>, Expression<Func<ISqlParamAdapter, ISqlParam>>[])

Declaration
public Query BuildSqlBlock(Expression<SqlBlockDefinition> sqlBlock, Expression<Func<ISqlParamAdapter, ISqlParam>>[] parameters)
Parameters
Type Name Description
Expression<SqlBlockDefinition> sqlBlock
Expression<Func<ISqlParamAdapter, ISqlParam>>[] parameters
Returns
Type Description
Query
| Improve this Doc View Source

BuildSqlBlock<T>(Expression<SqlBlockDefinition<T>>, Expression<Func<ISqlParamAdapter, ISqlParam>>[], out Func<DataRow, T>)

Declaration
public Query BuildSqlBlock<T>(Expression<SqlBlockDefinition<T>> sqlBlock, Expression<Func<ISqlParamAdapter, ISqlParam>>[] parameters, out Func<DataRow, T> mapper)
    where T : class, new()
Parameters
Type Name Description
Expression<SqlBlockDefinition<T>> sqlBlock
Expression<Func<ISqlParamAdapter, ISqlParam>>[] parameters
Func<DataRow, T> mapper
Returns
Type Description
Query
Type Parameters
Name Description
T
| Improve this Doc View Source

CompleteInsert(String, SortedList<Tuple<String, String>, Tuple<String, Boolean, Boolean>>, Type)

Returns string contains SQL expression to complete insert statement

Declaration
protected virtual string CompleteInsert(string alias, SortedList<Tuple<string, string>, Tuple<string, bool, bool>> identity, Type objectType)
Parameters
Type Name Description
String alias

Base table alias
SortedList<Tuple<String, String>, Tuple<String, Boolean, Boolean>> identity

Identity fields and query parameters
Type objectType

Mapped object type
Returns
Type Description
String

SQL expression to complete insert statement
| Improve this Doc View Source

ConvertTextExpr(IField, String)

Convert expression text for field native data type

Declaration
protected virtual string ConvertTextExpr(IField field, string exprText)
Parameters
Type Name Description
IField field

Field
String exprText

Expression text
Returns
Type Description
String

Expression text
| Improve this Doc View Source

ExtractXmlQuery(String, String, String[], IComparable[], String, KeyValuePair<String, String>[])

Returns query to extract xml data by XPath expression

Declaration
public Query ExtractXmlQuery(string table, string column, string[] tablePrimaryKey, IComparable[] primaryKeyValue, string path, params KeyValuePair<string, string>[] namespaces)
Parameters
Type Name Description
String table

Table name
String column

Xml column name
String[] tablePrimaryKey

Table primary key columns
IComparable[] primaryKeyValue

Table primary key values
String path

XPath expression
KeyValuePair<String, String>[] namespaces

XPath namespaces
Returns
Type Description
Query

XPath result
Exceptions
Type Condition
XDataQueryStructureException

Field not found
| Improve this Doc View Source

FormatConstValue(Object, out DbType)

Declaration
protected string FormatConstValue(object constVal, out DbType sqlType)
Parameters
Type Name Description
Object constVal
DbType sqlType
Returns
Type Description
String
| Improve this Doc View Source

FormatFieldName(String, String)

Format field name

Declaration
public static string FormatFieldName(string alias, string fieldName)
Parameters
Type Name Description
String alias

Source alias
String fieldName

Field name
Returns
Type Description
String

Formatted field name
| Improve this Doc View Source

FormatQuery(Query, Object[])

Returns formatted query string with parameter values

Declaration
public static string FormatQuery(Query query, params object[] paramValues)
Parameters
Type Name Description
Query query

Query
Object[] paramValues

Parameter values
Returns
Type Description
String

Formatted SQL string
| Improve this Doc View Source

FormatSql(SqlStringType, Object[])

Format SQL dialect specific syntax strings
Hint: Override to realize ugly non standard syntax (if needed)

Declaration
protected virtual string FormatSql(SqlStringType sqlStringType, params object[] args)
Parameters
Type Name Description
SqlStringType sqlStringType

SQL syntax key
Object[] args

Syntax arguments
Returns
Type Description
String
| Improve this Doc View Source

FormatStoredProcedure(StoredProcedure, Object[])

Returns formatted query string with parameter values

Declaration
public static string FormatStoredProcedure(StoredProcedure storedProcedure, params object[] paramValues)
Parameters
Type Name Description
StoredProcedure storedProcedure

Stored procedure
Object[] paramValues

Parameter values
Returns
Type Description
String

Formatted SQL string
| Improve this Doc View Source

GetAcquireBlobQuery(String, String, IEnumerable<String>, IComparable[], String)

Returns query to acquire blob data

Declaration
public Query GetAcquireBlobQuery(string table, string column, IEnumerable<string> tablePrimaryKey, IComparable[] primaryKeyValue, string nativeSqlType = null)
Parameters
Type Name Description
String table

Table name
String column

Blob column name
IEnumerable<String> tablePrimaryKey

Table primary key columns
IComparable[] primaryKeyValue

Table primary key values
String nativeSqlType

Native SQL type name
Returns
Type Description
Query

Query
| Improve this Doc View Source

GetAcquireXmlQuery(String, String, String[], IComparable[])

Returns query to acquire xml data

Declaration
public Query GetAcquireXmlQuery(string table, string column, string[] tablePrimaryKey, IComparable[] primaryKeyValue)
Parameters
Type Name Description
String table

Table name
String column

Xml column name
String[] tablePrimaryKey

Table primary key columns
IComparable[] primaryKeyValue

Table primary key values
Returns
Type Description
Query

Query
Exceptions
Type Condition
XDataQueryStructureException

Field not found
| Improve this Doc View Source

GetAllQuery(IDataStructure)

Returns query to check compliance of all repository objects
Hint: Used in XData LINQ expressions

Declaration
public Query GetAllQuery(IDataStructure structure)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
Returns
Type Description
Query

Query
| Improve this Doc View Source

GetAnyQuery(IDataStructure)

Returns query to check existence of repository objects
Hint: Used in XData LINQ expressions

Declaration
public Query GetAnyQuery(IDataStructure structure)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
Returns
Type Description
Query

Query
| Improve this Doc View Source

GetBlobSizeQuery(String, String, String[], IComparable[])

Returns query to get Large Object size

Declaration
public Query GetBlobSizeQuery(string table, string column, string[] tablePrimaryKey, IComparable[] primaryKeyValue)
Parameters
Type Name Description
String table

Table name contained LOB
String column

LOB column name
String[] tablePrimaryKey

Primary key column names
IComparable[] primaryKeyValue

Primary key values
Returns
Type Description
Query

Query to get Large Object size
| Improve this Doc View Source

GetCall(IDataStructure, String)

Declaration
public StoredProcedure GetCall(IDataStructure structure, string userName)
Parameters
Type Name Description
IDataStructure structure
String userName
Returns
Type Description
StoredProcedure
Exceptions
Type Condition
XDataQueryStructureException
XDataAdapterException

stored procedure
| Improve this Doc View Source

GetClearQuery(IDataStructure)

Returns query to clear all repository objects

Declaration
public Query GetClearQuery(IDataStructure structure)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
Returns
Type Description
Query

Query
Exceptions
Type Condition
XDataQueryStructureException
| Improve this Doc View Source

GetConnectionInfo(String, Dictionary<CredentialsType, String>)

Declaration
public XConnectionInfo GetConnectionInfo(string connectionString, Dictionary<CredentialsType, string> credentials = null)
Parameters
Type Name Description
String connectionString
Dictionary<CredentialsType, String> credentials
Returns
Type Description
XConnectionInfo
| Improve this Doc View Source

GetConnectionString(String, String, Boolean, String, String, String)

Compose specific connection string from parts

Declaration
protected abstract string GetConnectionString(string server, string schema, bool integratedSecurity, string user, string password, string partialConnectionString)
Parameters
Type Name Description
String server

Server name
String schema

Schema name
Boolean integratedSecurity

Integrated security flag
String user

User login
String password

User password
String partialConnectionString

Additional connection string settings
Returns
Type Description
String

Connection string
| Improve this Doc View Source

GetCountQuery(IDataStructure)

Returns query to select count of data objects in repository

Declaration
public Query GetCountQuery(IDataStructure structure)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
Returns
Type Description
Query

Query
| Improve this Doc View Source

GetDeleteQuery(IDataStructure, IDataObject, String, Boolean)

Returns query to delete data object

Declaration
public Query GetDeleteQuery(IDataStructure structure, IDataObject data, string userName, bool ignoreConcurrency = true)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
IDataObject data

Data object instance
String userName

User name
Boolean ignoreConcurrency

Ignore concurrency flag
Returns
Type Description
Query

Query
Exceptions
Type Condition
XDataQueryStructureException
| Improve this Doc View Source

GetEnumerator()

Predefined queries enumerator

Declaration
public IEnumerator<Query> GetEnumerator()
Returns
Type Description
IEnumerator<Query>

Predefined queries enumerator
| Improve this Doc View Source

GetExpressionText(IDataStructure, ExpressionContext, Type, Expression, out DbType)

Compose SQL expression from XData LINQ expression

Declaration
public string GetExpressionText(IDataStructure structure, ExpressionContext context, Type queryType, Expression expression, out DbType sqlType)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
ExpressionContext context

Expression context
Type queryType

Data query type
Expression expression

XData LINQ expression
DbType sqlType

Expression sql type
Returns
Type Description
String

SQL expression
Exceptions
Type Condition
XDataQueryStructureException

LINQ expression has unsupported type
XDataQueryStructureException

Property not found
XDataQueryStructureException

LINQ expression has unsupported method parameters
XDataAdapterException
| Improve this Doc View Source

GetExprSize(IField)

Declaration
protected string GetExprSize(IField field)
Parameters
Type Name Description
IField field
Returns
Type Description
String
| Improve this Doc View Source

GetInsertQuery(IDataStructure, IDataObject, String, Boolean)

Returns query to insert data object

Declaration
public Query GetInsertQuery(IDataStructure structure, IDataObject data, string userName, bool ignoreConcurrency = true)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
IDataObject data

Data object instance
String userName

User name
Boolean ignoreConcurrency

Ignore concurrency flag
Returns
Type Description
Query

Query
Exceptions
Type Condition
XDataQueryStructureException
| Improve this Doc View Source

GetLockQuery(IDataStructure)

Returns query to lock single data object

Declaration
public Query GetLockQuery(IDataStructure structure)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
Returns
Type Description
Query

Query
| Improve this Doc View Source

GetOrderByString(IDataStructure, SortedList<String, Object>, ref Query, ref List<Tuple<String, Type, String>>, ICollection<String>, ref SortedList<String, Tuple<String, String>>, ref Dictionary<String, Object>, Boolean, Boolean)

Returns order by string

Declaration
protected string GetOrderByString(IDataStructure structure, SortedList<string, object> filterValues, ref Query query, ref List<Tuple<string, Type, string>> withSources, ICollection<string> skipped, ref SortedList<string, Tuple<string, string>> fields, ref Dictionary<string, object> paramValues, bool doNotSkip, bool useGrouping = false)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
SortedList<String, Object> filterValues

Filter values
Query query

Query
List<Tuple<String, Type, String>> withSources

Common-Table-Expression (WITH) data sources
ICollection<String> skipped

Skipped sources collection
SortedList<String, Tuple<String, String>> fields

Parsed fields
Dictionary<String, Object> paramValues

Query parameter values
Boolean doNotSkip

Don't skip empty sources
Boolean useGrouping

Used in GROUP BY generation
Returns
Type Description
String

Order by string
Exceptions
Type Condition
XDataQueryStructureException

Field not found
| Improve this Doc View Source

GetParameterName(String)

Formats field name as parameter name

Declaration
public virtual string GetParameterName(string fieldName)
Parameters
Type Name Description
String fieldName

Field name
Returns
Type Description
String

Parameter name
| Improve this Doc View Source

GetRefreshQuery(IDataStructure)

Returns query to refresh single data object

Declaration
public Query GetRefreshQuery(IDataStructure structure)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
Returns
Type Description
Query

Query
| Improve this Doc View Source

GetSafeConvertExpression(Type, Expression, Expression)

Safe convert expression

Declaration
public virtual Expression GetSafeConvertExpression(Type type, Expression dataRow, Expression fieldName)
Parameters
Type Name Description
Type type

Type of expression
Expression dataRow

Data row expression
Expression fieldName

Field name expression
Returns
Type Description
Expression

Expression
| Improve this Doc View Source

GetSaveBlobQuery(String, String, IEnumerable<String>, IComparable[], ref Byte[], String)

Returns query to save blob data

Declaration
public Query GetSaveBlobQuery(string table, string column, IEnumerable<string> tablePrimaryKey, IComparable[] primaryKeyValue, ref byte[] body, string nativeSqlType = null)
Parameters
Type Name Description
String table

Table name
String column

Blob column name
IEnumerable<String> tablePrimaryKey

Table primary key columns
IComparable[] primaryKeyValue

Table primary key values
Byte[] body

Blob body
String nativeSqlType

Native SQL type name
Returns
Type Description
Query

Query
| Improve this Doc View Source

GetSaveXmlQuery(String, String, String[], IComparable[], ref String)

Returns query to save xml data

Declaration
public Query GetSaveXmlQuery(string table, string column, string[] tablePrimaryKey, IComparable[] primaryKeyValue, ref string body)
Parameters
Type Name Description
String table

Table name
String column

Xml column name
String[] tablePrimaryKey

Table primary key columns
IComparable[] primaryKeyValue

Table primary key values
String body

Blob body
Returns
Type Description
Query

Query
Exceptions
Type Condition
XDataQueryStructureException

Field not found
| Improve this Doc View Source

GetSelectQuery(IDataStructure, Boolean, Boolean)

Returns query to select data objects

Declaration
public Query GetSelectQuery(IDataStructure structure, bool markProperties = false, bool doNotSkip = false)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
Boolean markProperties

Mark properties with comments
Boolean doNotSkip

Don't skip sources
Returns
Type Description
Query

Query
| Improve this Doc View Source

GetSequenceName(String, String, String)

Returns sequence name

Declaration
public string GetSequenceName(string context, string table, string column)
Parameters
Type Name Description
String context

Context name
String table

Table name
String column

Column name
Returns
Type Description
String

Sequence name
| Improve this Doc View Source

GetSqlTypeName(DbType)

Returns SQL type name for System.DbType

Declaration
protected virtual string GetSqlTypeName(DbType dbType)
Parameters
Type Name Description
DbType dbType

System.DbType enumeration key
Returns
Type Description
String

SQL type name
Exceptions
Type Condition
XDataAdapterException

Type not supported
| Improve this Doc View Source

GetUpdateQuery(IDataStructure, IDataObject, String, Boolean)

Returns query to update data object

Declaration
public Query GetUpdateQuery(IDataStructure structure, IDataObject data, string userName, bool ignoreConcurrency = true)
Parameters
Type Name Description
IDataStructure structure

Structure metadata
IDataObject data

Data object instance
String userName

User name
Boolean ignoreConcurrency

Ignore concurrency flag
Returns
Type Description
Query

Query
Exceptions
Type Condition
XDataQueryStructureException
| Improve this Doc View Source

GetXmlNamespaces(KeyValuePair<String, String>[])

Returns Xml namespaces string

Declaration
protected abstract string GetXmlNamespaces(KeyValuePair<string, string>[] namespaces)
Parameters
Type Name Description
KeyValuePair<String, String>[] namespaces

Xml namespaces
Returns
Type Description
String

Xml namespaces string
| Improve this Doc View Source

Init()

Dialect adapter initialization

Declaration
protected virtual void Init()
| Improve this Doc View Source

Init(String, IConfiguration, String)

Dialect adapter initialization

Declaration
public void Init(string context, IConfiguration config, string sequence)
Parameters
Type Name Description
String context

Context name
IConfiguration config

Specific dialect adapter configuration Xml
String sequence

Sequence generator assembly qualified class name
| Improve this Doc View Source

ParseConnectionString(String, ref String, ref String, ref Boolean, ref String, ref String, out String)

Parse specific connection string to parts

Declaration
protected abstract void ParseConnectionString(string connectionString, ref string server, ref string schema, ref bool integratedSecurity, ref string user, ref string password, out string partialConnectionString)
Parameters
Type Name Description
String connectionString

Connection string
String server

Server name
String schema

Schema name
Boolean integratedSecurity

Integrated security flag
String user

User login
String password

User password
String partialConnectionString

Additional connection string settings
| Improve this Doc View Source

PrepareTempTables(IDataStructure, ref StringBuilder, Query, ICollection<String>, Boolean, Boolean)

Declaration
protected virtual bool PrepareTempTables(IDataStructure structure, ref StringBuilder strCommand, Query query, ICollection<string> skippedSources, bool riseErrors, bool doNotSkip)
Parameters
Type Name Description
IDataStructure structure
StringBuilder strCommand
Query query
ICollection<String> skippedSources
Boolean riseErrors
Boolean doNotSkip
Returns
Type Description
Boolean
| Improve this Doc View Source

RegisterResultSet(IResultSetDescription)

Declaration
protected virtual QueryParam RegisterResultSet(IResultSetDescription resultSet)
Parameters
Type Name Description
IResultSetDescription resultSet
Returns
Type Description
QueryParam
| Improve this Doc View Source

SequenceGeneration(out Boolean)

Sequence generation supported

Declaration
public bool SequenceGeneration(out bool required)
Parameters
Type Name Description
Boolean required
Returns
Type Description
Boolean

Sequence generation supported flag
See Also
| Improve this Doc View Source

SetQueryParameters(ref Query, IEnumerable<IParameterDescription>, SortedList<String, Object>, String, DialectOptions)

Declaration
public void SetQueryParameters(ref Query query, IEnumerable<IParameterDescription> parameters, SortedList<string, object> variableValues, string userName, DialectOptions dialectOptions)
Parameters
Type Name Description
Query query
IEnumerable<IParameterDescription> parameters
SortedList<String, Object> variableValues
String userName
DialectOptions dialectOptions
Exceptions
Type Condition
XDataAdapterException
| Improve this Doc View Source

SetQueryParameterValues(ref Query, SortedList<String, Object>)

Set query parameter values

Declaration
public void SetQueryParameterValues(ref Query query, SortedList<string, object> paramValues)
Parameters
Type Name Description
Query query

Query
SortedList<String, Object> paramValues

Parameter values
| Improve this Doc View Source

ToDataSet<TSource>(String, IEnumerable<TSource>)

Compose union structure over source object sequence

Declaration
public string ToDataSet<TSource>(string prefix, IEnumerable<TSource> source)
Parameters
Type Name Description
String prefix

Column prefix
IEnumerable<TSource> source

Source sequence
Returns
Type Description
String

Data source
Type Parameters
Name Description
TSource

Source type

Explicit Interface Implementations

| Improve this Doc View Source

IEnumerable.GetEnumerator()

Predefined queries enumerator

Declaration
IEnumerator IEnumerable.GetEnumerator()
Returns
Type Description
IEnumerator

Predefined queries enumerator

Implements

Extension Methods