Interface ISqlBuilder
Assembly: linq2db.dll
Syntax
public interface ISqlBuilder
Properties
|
Improve this Doc
View Source
MappingSchema
Declaration
MappingSchema MappingSchema { get; }
Property Value
|
Improve this Doc
View Source
Name
Declaration
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
|
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
|
Improve this Doc
View Source
BuildSqlID(Sql.SqlID)
Declaration
string? BuildSqlID(Sql.SqlID id)
Parameters
Returns
Type |
Description |
System.Nullable<System.String> |
|
|
Improve this Doc
View Source
CommandCount(SqlStatement)
Declaration
int CommandCount(SqlStatement statement)
Parameters
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
Returns
|
Improve this Doc
View Source
GetMaxValueSql(EntityDescriptor, ColumnDescriptor)
Declaration
string GetMaxValueSql(EntityDescriptor entity, ColumnDescriptor column)
Parameters
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