Exemplo n.º 1
0
        /// <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);
        }
Exemplo n.º 2
0
        /// <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);
        }
Exemplo n.º 3
0
        /// <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);
        }
Exemplo n.º 4
0
        /// <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);
        }