ISqlDialect interface

namespace: Serenity.Data   assemblySerenity.Net.Data

Abstraction for SQL dialect, e.g. syntax for different SQL server types and connection settings.

public interface ISqlDialect

Members

name description
CanUseOffsetFetch { get; } Gets a value indicating whether the server supports OFFSET FETCH.
CanUseRowNumber { get; } Gets a value indicating whether the server supports ROWNUMBER.
CanUseSkipKeyword { get; } Gets a value indicating whether the server supports SKIP keyword (or a variation of it).
CloseQuote { get; } Gets the close quote character for quoting identifiers.
ConcatOperator { get; } Gets the CONCAT operator keyword.
DateFormat { get; } Gets the date format.
DateTimeFormat { get; } Gets the date time format.
IsLikeCaseSensitive { get; } Gets a value indicating whether the LIKE operator is case sensitive.
MultipleResultsets { get; } Gets a value indicating whether the server supports multiple resultsets.
NeedsBoolWorkaround { get; } Gets a value indicating whether the server needs a workaround to handle Boolean values false/true.
NeedsExecuteBlockStatement { get; } Gets a value indicating whether the server needs EXECUTE BLOCK statement.
OffsetFetchFormat { get; } Gets the format for OFFSET FETCH statements.
OffsetFormat { get; } Gets the format for OFFSET only statements.
OpenQuote { get; } Gets the open quote character for quoting identifiers.
ParameterPrefix { get; } Gets the parameter prefix character.
ScopeIdentityExpression { get; } Gets the SCOPE IDENTITY expression.
ServerType { get; } Gets the type of the server.
SkipKeyword { get; } Gets the skip keyword.
TakeKeyword { get; } Gets the take keyword.
TimeFormat { get; } Gets the time format.
UseDateTime2 { get; } Gets a value indicating whether use datetime2 type.
UseReturningIdentity { get; } Gets a value indicating whether to use returning identity.
UseReturningIntoVar { get; } Gets a value indicating whether use returning into variable.
UseRowNum { get; } Gets a value indicating whether ROWNUM.
UseScopeIdentity { get; } Gets a value indicating whether to use scope identity.
UseTakeAtEnd { get; } Gets a value indicating whether to use TAKE at end.
QuoteColumnAlias(…) Quotes the column alias. This usually calls QuoteIdentifier except for Oracle.
QuoteIdentifier(…) Quotes the identifier.
QuoteUnicodeString(…) Quotes the unicode string.
UnionKeyword(…) Gets the union keyword for specified union type.

See Also