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