namespace: Serenity.Data assembly: Serenity.Net.Data
Abstraction for SQL dialect, e.g. syntax for different SQL server types and connection settings.
public interface ISqlDialect| name | description |
|---|---|
| CanUseConcat { get; } | Gets a value indicating whether the server supports CONCAT. |
| 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. |
- Source: ISqlDialect.cs