ISqlDialect interface
namespace: Serenity.Data assembly: Serenity.Net.Services
Abstraction for SQL dialect, e.g. syntax for different SQL server types and connection settings.
public interface ISqlDialect
Members
| name | description |
|---|---|
| AutoQuotedIdentifiers { get; } | Gets a value indicating whether to automatically quote identifiers. Default is null, e.g. SqlSettings.AutoQuotedIdentifiers is used, which itself is false by default, but usually set to true in applications. |
| CanUseConcat { get; } | Gets a value indicating whether the server supports the CONCAT() function (used by ConcatAttribute to decide between CONCAT(...) and an infix operator). This does not imply ConcatOperator is available: e.g. MySQL supports CONCAT() but has no infix concatenation operator (|| is logical OR there unless PIPES_AS_CONCAT mode is on). |
| 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. |
| Comparer { get; } | Gets the comparer used to compare string field values for this connection, or null to fall back to DefaultComparer. Dialects that support a per-connection comparer override this and WithComparer. |
| 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 the server uses the datetime2 type. |
| UseReturningIdentity { get; } | Gets a value indicating whether to use RETURNING identity. |
| UseReturningIntoVar { get; } | Gets a value indicating whether to use RETURNING INTO variable. |
| UseRowNum { get; } | Gets a value indicating whether the server supports ROWNUM. |
| UseScopeIdentity { get; } | Gets a value indicating whether to use SCOPE IDENTITY. |
| UseTakeAtEnd { get; } | Gets a value indicating whether to use TAKE at the end. |
| IsReservedKeyword(…) | Returns true if the specified identifier is a SQL keyword. |
| QuoteColumnAlias(…) | Quotes the column alias. This usually calls QuoteIdentifier except for Oracle. |
| QuoteIdentifier(…) | Quotes the identifier, escaping embedded occurrences of the dialect's closing quote character. |
| QuoteUnicodeString(…) | Quotes the unicode string. |
| UnionKeyword(…) | Gets the union keyword for the specified union type. |
| WithComparer(…) | Returns a copy of this dialect with the specified comparer set. Dialects that support a per-connection comparer override this method; the default throws. |
See Also
- Source: ISqlDialect.cs