C# (CSharp) SqlDbLite MethodCallExpressionModel Examples

Example #1

        public override string ToDouble(MethodCallExpressionModel model)
        {
            var parameter = model.Args[0];

            return(string.Format(" CAST({0} AS DECIMAL(18,4))", parameter.MemberName));
        }

Example #2

        public override string ToBool(MethodCallExpressionModel model)
        {
            var parameter = model.Args[0];

            return(string.Format(" CAST({0} AS SIGNED)", parameter.MemberName));
        }

Example #3

        public override string ToInt64(MethodCallExpressionModel model)
        {
            var parameter = model.Args[0];

            return(string.Format(" CAST({0} AS INTEGER)", parameter.MemberName));
        }

Example #4

 public override string CharIndex(MethodCallExpressionModel model)
 {
     throw new NotSupportedException("Slqite Not Supported CharIndex");
 }

Example #5

        public override string Length(MethodCallExpressionModel model)
        {
            var parameter = model.Args[0];

            return(string.Format("LENGTH({0})", parameter.MemberName));
        }

Example #6

        public override string ToDate(MethodCallExpressionModel model)
        {
            var parameter = model.Args[0];

            return(string.Format(" DATETIME({0})", parameter.MemberName));
        }

Example #7

File: PostgreSQLExpressionContext.cs Project: rockmyid/autumn.boot

        public override string ToDate(MethodCallExpressionModel model)
        {
            var parameter = model.Args[0];

            return(string.Format(" CAST({0} AS timestamp)", parameter.MemberName));
        }