C# (CSharp) ISQLTranslator Examples

Example #1

File: AbstractFilterExpressionVisitor.cs Project: rexzh/RexToy

 protected AbstractFilterExpressionVisitor(ISQLTranslator tr, IObjectMapInfoCache cache)
 {
     tr.ThrowIfNullArgument(nameof(tr));
     cache.ThrowIfNullArgument(nameof(cache));
     _tr    = tr;
     _cache = cache;
 }

Example #2

        /// <summary>
        /// Uses QueryTranslator to translate a LINQ Expression to a SQL query.
        /// </summary>
        /// <returns>The sql query.</returns>
        /// <param name="expression">The LINQ Expression to be translated.</param>
        /// <typeparam name="T">The 1st type parameter.</typeparam>
        private SQLPredicate Translate(Expression expression)
        {
            ISQLTranslator sql  = SQLTranslatorFactory.GetTranslator(DbType);
            SQLPredicate   pred = sql.Translate(Evaluator.PartialEval(expression));

            return(pred);
        }

Example #3

        /// <summary>
        /// Uses QueryTranslator to translate a LINQ Expression to a SQL query.
        /// </summary>
        /// <returns>The sql query.</returns>
        /// <param name="expression">The LINQ Expression to be translated.</param>
        /// <typeparam name="T">The 1st type parameter.</typeparam>
        private SQLPredicate Translate(Expression expression, bool ignoreAliases = false)
        {
            ISQLTranslator sql  = SQLTranslatorFactory.GetTranslator(DbType);
            SQLPredicate   pred = sql.Translate(Evaluator.PartialEval(expression), 0, ignoreAliases);

            return(pred);
        }

Example #4

        protected AbstractQueryOrderVisitor(ISQLTranslator tr, IOrderExpressionVisitor oev)
        {
            tr.ThrowIfNullArgument(nameof(tr));
            oev.ThrowIfNullArgument(nameof(oev));

            _tr  = tr;
            _oev = oev;
        }

Example #5

File: AbstractModelColumnsBuilder.cs Project: rexzh/RexToy

        public AbstractModelColumnsBuilder(ISQLTranslator tr, ITypeMap tm)
        {
            tr.ThrowIfNullArgument(nameof(tr));
            tm.ThrowIfNullArgument(nameof(tm));

            this._tr = tr;
            this._tm = tm;
        }

Example #6

File: AbstractQueryCriteriaVisitor.cs Project: rexzh/RexToy

        public AbstractQueryCriteriaVisitor(ISQLTranslator tr, IFilterExpressionVisitor fv)
        {
            tr.ThrowIfNullArgument(nameof(tr));
            fv.ThrowIfNullArgument(nameof(fv));

            _tr = tr;
            _fv = fv;
        }

Example #7

File: AbstractModelColumnsBuilder.cs Project: rexzh/RexToy

        public AbstractModelColumnsBuilder(ISQLTranslator tr, ITypeMap tm)
        {
            tr.ThrowIfNullArgument(nameof(tr));
            tm.ThrowIfNullArgument(nameof(tm));

            this._tr = tr;
            this._tm = tm;
        }

Example #8

File: AbstractQueryOrderVisitor.cs Project: rexzh/RexToy

        protected AbstractQueryOrderVisitor(ISQLTranslator tr, IOrderExpressionVisitor oev)
        {
            tr.ThrowIfNullArgument(nameof(tr));
            oev.ThrowIfNullArgument(nameof(oev));

            _tr = tr;
            _oev = oev;
        }

Example #9

        public AbstractQueryCriteriaVisitor(ISQLTranslator tr, IFilterExpressionVisitor fv)
        {
            tr.ThrowIfNullArgument(nameof(tr));
            fv.ThrowIfNullArgument(nameof(fv));

            _tr = tr;
            _fv = fv;
        }

Example #10

File: AbstractQueryColumnBuilder.cs Project: rexzh/RexToy

        protected AbstractQueryColumnBuilder(ISQLTranslator tr, IObjectMapInfoCache cache)
        {
            cache.ThrowIfNullArgument(nameof(cache));
            tr.ThrowIfNullArgument(nameof(tr));

            _tr    = tr;
            _cache = cache;
            _str   = new StringBuilder();
        }

Example #11

File: AbstractQueryColumnBuilder.cs Project: rexzh/RexToy

        protected AbstractQueryColumnBuilder(ISQLTranslator tr, IObjectMapInfoCache cache)
        {
            cache.ThrowIfNullArgument(nameof(cache));
            tr.ThrowIfNullArgument(nameof(tr));

            _tr = tr;
            _cache = cache;
            _str = new StringBuilder();
        }

Example #12

File: AbstractQueryViewVisitor.cs Project: rexzh/RexToy

        protected AbstractQueryViewVisitor(ISQLTranslator tr, IJoinExpressionVisitor jv, IObjectMapInfoCache cache)
        {
            tr.ThrowIfNullArgument(nameof(tr));
            jv.ThrowIfNullArgument(nameof(jv));
            cache.ThrowIfNullArgument(nameof(cache));

            _cache = cache;
            _tr = tr;
            _jv = jv;
        }

Example #13

        protected AbstractQueryViewVisitor(ISQLTranslator tr, IJoinExpressionVisitor jv, IObjectMapInfoCache cache)
        {
            tr.ThrowIfNullArgument(nameof(tr));
            jv.ThrowIfNullArgument(nameof(jv));
            cache.ThrowIfNullArgument(nameof(cache));

            _cache = cache;
            _tr    = tr;
            _jv    = jv;
        }

Example #14

File: AbstractModelSQLEmit.cs Project: rexzh/RexToy

 protected AbstractModelSQLEmit(IObjectMapInfoCache cache, ISQLTranslator tr, ITypeMap tm, IModelColumnsBuilder cb)
 {
     tr.ThrowIfNullArgument(nameof(tr));
     tm.ThrowIfNullArgument(nameof(tm));
     cb.ThrowIfNullArgument(nameof(cb));
     cache.ThrowIfNullArgument(nameof(cache));
     this._tr    = tr;
     this._tm    = tm;
     this._cb    = cb;
     this._cache = cache;
 }

Example #15

        protected AbstractMappingSQLEmit(IObjectMapInfoCache cache, IMappingColumnsBuilder cb, ISQLTranslator tr, IMappingConditionExpressionVisitor cv, IMappingOrderExpressionVisitor ov)
        {
            cache.ThrowIfNullArgument(nameof(cache));
            cb.ThrowIfNullArgument(nameof(cb));
            tr.ThrowIfNullArgument(nameof(tr));
            cv.ThrowIfNullArgument(nameof(cv));
            ov.ThrowIfNullArgument(nameof(ov));

            _cache = cache;
            _cb    = cb;
            _tr    = tr;
            _cv    = cv;
            _ov    = ov;
        }

Example #16

        public AbstractQuerySQLEmit(IObjectMapInfoCache cache, ISQLTranslator tr, IQueryViewVisitor vv, IQueryColumnBuilder cb, IQueryCriteriaVisitor cv, IQueryOrderVisitor ov)
        {
            cache.ThrowIfNullArgument(nameof(cache));
            tr.ThrowIfNullArgument(nameof(tr));
            vv.ThrowIfNullArgument(nameof(vv));
            cb.ThrowIfNullArgument(nameof(cb));
            cv.ThrowIfNullArgument(nameof(cv));
            ov.ThrowIfNullArgument(nameof(ov));

            _cache = cache;
            _tr    = tr;
            _vv    = vv;
            _cb    = cb;
            _cv    = cv;
            _ov    = ov;
        }

Example #17

File: AbstractQuerySQLEmit.cs Project: rexzh/RexToy

        public AbstractQuerySQLEmit(IObjectMapInfoCache cache, ISQLTranslator tr, IQueryViewVisitor vv, IQueryColumnBuilder cb, IQueryCriteriaVisitor cv, IQueryOrderVisitor ov)
        {
            cache.ThrowIfNullArgument(nameof(cache));
            tr.ThrowIfNullArgument(nameof(tr));
            vv.ThrowIfNullArgument(nameof(vv));
            cb.ThrowIfNullArgument(nameof(cb));
            cv.ThrowIfNullArgument(nameof(cv));
            ov.ThrowIfNullArgument(nameof(ov));

            _cache = cache;
            _tr = tr;
            _vv = vv;
            _cb = cb;
            _cv = cv;
            _ov = ov;
        }

Example #18

File: QueryCriteriaVisitor.cs Project: rexzh/RexToy

 public QueryCriteriaVisitor(ISQLTranslator tr, IFilterExpressionVisitor fv)
     : base(tr, fv)
 {
 }

Example #19

 internal MappingOrderExpressionVisitor(ISQLTranslator tr) : base(tr)
 {
 }

Example #20

File: QueryOrderVisitor.cs Project: rexzh/RexToy

 public QueryOrderVisitor(ISQLTranslator tr, IOrderExpressionVisitor oev)
     : base(tr, oev)
 {
 }

Example #21

File: MappingOrderExpressionVisitor.cs Project: rexzh/RexToy

 internal MappingOrderExpressionVisitor(ISQLTranslator tr)
     : base(tr)
 {
 }

Example #22

File: MappingConditionExpressionVisitor.cs Project: rexzh/RexToy

 internal MappingConditionExpressionVisitor(ISQLTranslator tr)
     : base(tr)
 {
 }

Example #23

File: FilterExpressionVisitor.cs Project: rexzh/RexToy

 public FilterExpressionVisitor(ISQLTranslator tr, IObjectMapInfoCache cache)
     : base(tr, cache)
 {
 }

Example #24

File: AbstractMappingConditionExpressionVisitor.cs Project: rexzh/RexToy

        protected AbstractMappingConditionExpressionVisitor(ISQLTranslator tr)
        {
            tr.ThrowIfNullArgument(nameof(tr));

            _tr = tr;
        }

Example #25

File: ModelColumnsBuilder.cs Project: rexzh/RexToy

 public ModelColumnsBuilder(ISQLTranslator tr, ITypeMap tm)
     : base(tr, tm)
 {
 }

Example #26

 internal MappingColumnsBuilder(ISQLTranslator tr)
     : base(tr)
 {
 }

Example #27

File: MappingColumnsBuilder.cs Project: rexzh/RexToy

 public MappingColumnsBuilder(ISQLTranslator tr)
     : base(tr)
 {
 }

Example #28

File: QueryColumnBuilder.cs Project: rexzh/RexToy

 public QueryColumnBuilder(ISQLTranslator tr, IObjectMapInfoCache cache)
     : base(tr, cache)
 {
 }

Example #29

File: QuerySQLEmit.cs Project: rexzh/RexToy

 public QuerySQLEmit(IObjectMapInfoCache cache, ISQLTranslator tr, IQueryViewVisitor vv, IQueryColumnBuilder cb, IQueryCriteriaVisitor cv, IQueryOrderVisitor ov)
     : base(cache, tr, vv, cb, cv, ov)
 {
 }

Example #30

File: MappingSQLEmit.cs Project: rexzh/RexToy

 public MappingSQLEmit(IObjectMapInfoCache cache, IMappingColumnsBuilder cb, ISQLTranslator tr, IMappingConditionExpressionVisitor cv, IMappingOrderExpressionVisitor ov)
     : base(cache, cb, tr, cv, ov)
 {
 }

Example #31

 internal MappingConditionExpressionVisitor(ISQLTranslator tr)
     : base(tr)
 {
 }

Example #32

File: AbstractMappingConditionExpressionVisitor.cs Project: rexzh/RexToy

        protected AbstractMappingConditionExpressionVisitor(ISQLTranslator tr)
        {
            tr.ThrowIfNullArgument(nameof(tr));

            _tr = tr;
        }

Example #33

 public JoinProvider(DbProvider provider)
 {
     DbProvider      = provider;
     QueryTranslator = SQLTranslatorFactory.GetTranslator(provider.DbType);
 }

Example #34

 public QuerySQLEmit(IObjectMapInfoCache cache, ISQLTranslator tr, IQueryViewVisitor vv, IQueryColumnBuilder cb, IQueryCriteriaVisitor cv, IQueryOrderVisitor ov)
     : base(cache, tr, vv, cb, cv, ov)
 {
 }

Example #35

File: QueryViewVisitor.cs Project: rexzh/RexToy

 public QueryViewVisitor(ISQLTranslator tr, IJoinExpressionVisitor jv, IObjectMapInfoCache cache)
     : base(tr, jv, cache)
 {
 }

Example #36

File: OrderExpressionVisitor.cs Project: rexzh/RexToy

 public OrderExpressionVisitor(ISQLTranslator tr, IObjectMapInfoCache cache)
     : base(tr, cache)
 {
 }

Example #37

File: QueryColumnBuilder.cs Project: rexzh/RexToy

 public QueryColumnBuilder(ISQLTranslator tr, IObjectMapInfoCache cache)
     : base(tr, cache)
 {
 }

Example #38

File: QueryOrderVisitor.cs Project: rexzh/RexToy

 public QueryOrderVisitor(ISQLTranslator tr, IOrderExpressionVisitor oev)
     : base(tr,oev)
 {
 }

Example #39

File: MappingColumnsBuilder.cs Project: rexzh/RexToy

 public MappingColumnsBuilder(ISQLTranslator tr)
     : base(tr)
 {
 }

Example #40

File: MappingColumnsBuilder.cs Project: rexzh/RexToy

 internal MappingColumnsBuilder(ISQLTranslator tr)
     : base(tr)
 {
 }

Example #41

File: ModelSQLEmit.cs Project: rexzh/RexToy

 public ModelSQLEmit(IObjectMapInfoCache cache, ISQLTranslator tr, ITypeMap tm, IModelColumnsBuilder cb)
     : base(cache, tr, tm, cb)
 {
 }

Example #42

File: ModelColumnsBuilder.cs Project: rexzh/RexToy

 public ModelColumnsBuilder(ISQLTranslator tr, ITypeMap tm)
     : base(tr, tm)
 {
 }

Example #43

File: QueryViewVisitor.cs Project: rexzh/RexToy

 public QueryViewVisitor(ISQLTranslator tr, IJoinExpressionVisitor jv, IObjectMapInfoCache cache)
     : base(tr, jv, cache)
 {
 }

Example #44

 protected AbstractMappingColumnsBuilder(ISQLTranslator tr)
 {
     tr.ThrowIfNullArgument(nameof(tr));
     _tr = tr;
 }

Example #45

File: QueryCriteriaVisitor.cs Project: rexzh/RexToy

 public QueryCriteriaVisitor(ISQLTranslator tr, IFilterExpressionVisitor fv)
     : base(tr, fv)
 {
 }

Example #46

File: AbstractMappingColumnsBuilder.cs Project: rexzh/RexToy

 protected AbstractMappingColumnsBuilder(ISQLTranslator tr)
 {
     tr.ThrowIfNullArgument(nameof(tr));
     _tr = tr;
 }