namespace: Serenity.Data assembly: Serenity.Net.Data
Sqlite dialect.
public class SqliteDialect : ISqlDialect
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. |
- interface ISqlDialect
- Source: SqliteDialect.cs