/// <summary>
/// Initializes the engine options.
/// </summary>
/// <returns>The engine options.</returns>
protected override EngineOptions InitOptions()
{
EngineOptions options = new EngineOptions();
options.EscapeStart = '"';
options.EscapeEnd = '"';
options.LowerCaseNames = true;
options.WithRecursive = true;
options.TopSupported = false;
options.DistinctOnSupported = true;
options.RightJoinSupported = true;
options.FullJoinSupported = true;
options.OffsetStyle = OffsetStyle.Offset;
return(options);
}
/// <summary>
/// Initializes the engine options.
/// </summary>
/// <returns>The engine options.</returns>
protected override EngineOptions InitOptions()
{
EngineOptions options = new EngineOptions();
options.EscapeStart = '[';
options.EscapeEnd = ']';
options.WithRecursive = false;
options.TopSupported = true;
options.DistinctOnSupported = false;
options.RightJoinSupported = true;
options.FullJoinSupported = true;
options.OffsetStyle = OffsetStyle.Offset;
options.UpdateWithFrom = true;
options.DeleteWithAlias = true;
return(options);
}
/// <summary>
/// Initializes the engine options.
/// </summary>
/// <returns>The engine options.</returns>
protected override EngineOptions InitOptions()
{
EngineOptions options = new EngineOptions();
options.Name = EngineName.MySQL;
options.EscapeStart = '`';
options.EscapeEnd = '`';
options.WithRecursive = true;
options.TopSupported = false;
options.DistinctOnSupported = false;
options.RightJoinSupported = true;
options.FullJoinSupported = false;
options.OffsetStyle = OffsetStyle.Limit;
options.UpdateSetWithTableName = true;
options.DeleteWithAlias = true;
return(options);
}
/// <summary>
/// Initializes the engine options.
/// </summary>
/// <returns>The engine options.</returns>
protected override EngineOptions InitOptions()
{
EngineOptions options = new EngineOptions();
options.EscapeStart = '"';
options.EscapeEnd = '"';
options.UpperCaseNames = true;
options.WithRecursive = false;
options.TopSupported = false;
options.DistinctOnSupported = false;
options.RightJoinSupported = true;
options.FullJoinSupported = true;
options.OffsetStyle = OffsetStyle.Offset;
options.TableAs = false;
options.FromDummyName = "DUAL";
options.InsertWithUnion = true;
return(options);
}