Interface ISqlBuilder

Namespace: LinqToDB.SqlProvider
Assembly: linq2db.dll
Syntax
public interface ISqlBuilder

Properties

| Improve this Doc View Source

MappingSchema

Declaration
MappingSchema MappingSchema { get; }
Property Value
Type Description
MappingSchema
| Improve this Doc View Source

Name

Declaration
string Name { get; }
Property Value
Type Description
System.String
| Improve this Doc View Source

QueryName

Declaration
string? QueryName { get; }
Property Value
Type Description
System.Nullable<System.String>
| Improve this Doc View Source

SqlProviderFlags

Declaration
SqlProviderFlags SqlProviderFlags { get; }
Property Value
Type Description
SqlProviderFlags
| Improve this Doc View Source

StringBuilder

Declaration
StringBuilder StringBuilder { get; }
Property Value
Type Description
StringBuilder
| Improve this Doc View Source

TableIDs

Declaration
Dictionary<string, TableIDInfo>? TableIDs { get; }
Property Value
Type Description
System.Nullable<Dictionary<System.String, TableIDInfo>>
| Improve this Doc View Source

TablePath

Declaration
string? TablePath { get; }
Property Value
Type Description
System.Nullable<System.String>

Methods

| Improve this Doc View Source

ApplyQueryHints(String, IReadOnlyCollection<String>)

Declaration
string ApplyQueryHints(string sqlText, IReadOnlyCollection<string> queryHints)
Parameters
Type Name Description
System.String sqlText
IReadOnlyCollection<System.String> queryHints
Returns
Type Description
System.String
| Improve this Doc View Source

BuildDataType(StringBuilder, SqlDataType)

Declaration
StringBuilder BuildDataType(StringBuilder sb, SqlDataType dataType)
Parameters
Type Name Description
StringBuilder sb
SqlDataType dataType
Returns
Type Description
StringBuilder
| Improve this Doc View Source

BuildExpression(StringBuilder, ISqlExpression, Boolean)

Declaration
void BuildExpression(StringBuilder sb, ISqlExpression expr, bool buildTableName)
Parameters
Type Name Description
StringBuilder sb
ISqlExpression expr
System.Boolean buildTableName
| Improve this Doc View Source

BuildObjectName(StringBuilder, SqlObjectName, ConvertType, Boolean, TableOptions)

Writes database object name into provided StringBuilder instance.

Declaration
StringBuilder BuildObjectName(StringBuilder sb, SqlObjectName name, ConvertType objectType = ConvertType.NameToQueryTable, bool escape = true, TableOptions tableOptions = default(TableOptions))
Parameters
Type Name Description
StringBuilder sb

String builder for generated object name.
LinqToDB.SqlQuery.SqlObjectName name

Name of database object (e.g. table, view, procedure or function).
ConvertType objectType

Type of database object, used to select proper name converter.
System.Boolean escape

If true, apply required escaping to name components. Must be true except rare cases when escaping is not needed.
TableOptions tableOptions

Table options if called for table. Used to properly generate names for temporary tables.
Returns
Type Description
StringBuilder

sb parameter value.
| Improve this Doc View Source

BuildSql(Int32, SqlStatement, StringBuilder, OptimizationContext, Int32)

Declaration
void BuildSql(int commandNumber, SqlStatement statement, StringBuilder sb, OptimizationContext optimizationContext, int startIndent = 0)
Parameters
Type Name Description
System.Int32 commandNumber
SqlStatement statement
StringBuilder sb
OptimizationContext optimizationContext
System.Int32 startIndent
| Improve this Doc View Source

BuildSqlID(Sql.SqlID)

Declaration
string? BuildSqlID(Sql.SqlID id)
Parameters
Type Name Description
Sql.SqlID id
Returns
Type Description
System.Nullable<System.String>
| Improve this Doc View Source

CommandCount(SqlStatement)

Declaration
int CommandCount(SqlStatement statement)
Parameters
Type Name Description
SqlStatement statement
Returns
Type Description
System.Int32
| Improve this Doc View Source

Convert(StringBuilder, String, ConvertType)

Declaration
StringBuilder Convert(StringBuilder sb, string value, ConvertType convertType)
Parameters
Type Name Description
StringBuilder sb
System.String value
ConvertType convertType
Returns
Type Description
StringBuilder
| Improve this Doc View Source

ConvertInline(String, ConvertType)

Declaration
string ConvertInline(string value, ConvertType convertType)
Parameters
Type Name Description
System.String value
ConvertType convertType
Returns
Type Description
System.String
| Improve this Doc View Source

GetIdentityExpression(SqlTable)

Declaration
ISqlExpression GetIdentityExpression(SqlTable table)
Parameters
Type Name Description
SqlTable table
Returns
Type Description
ISqlExpression
| Improve this Doc View Source

GetMaxValueSql(EntityDescriptor, ColumnDescriptor)

Declaration
string GetMaxValueSql(EntityDescriptor entity, ColumnDescriptor column)
Parameters
Type Name Description
EntityDescriptor entity
ColumnDescriptor column
Returns
Type Description
System.String
| Improve this Doc View Source

GetReserveSequenceValuesSql(Int32, String)

Declaration
string GetReserveSequenceValuesSql(int count, string sequenceName)
Parameters
Type Name Description
System.Int32 count
System.String sequenceName
Returns
Type Description
System.String
| Improve this Doc View Source

PrintParameters(IDataContext, StringBuilder, Nullable<IEnumerable<DbParameter>>)

Declaration
StringBuilder PrintParameters(IDataContext dataContext, StringBuilder sb, IEnumerable<DbParameter>? parameters)
Parameters
Type Name Description
IDataContext dataContext
StringBuilder sb
System.Nullable<IEnumerable<DbParameter>> parameters
Returns
Type Description
StringBuilder

Extension Methods