C# (CSharp) DatePartExpression示例

示例#1

文件： SqlCeQuerySqlGenerator.cs 项目： divega/EntityFramework.SqlServerCompact

        public virtual Expression VisitDatePartExpression(DatePartExpression datePartExpression)
        {
            Check.NotNull(datePartExpression, nameof(datePartExpression));

            Sql.Append("DATEPART(")
            .Append(datePartExpression.DatePart)
            .Append(", ");
            Visit(datePartExpression.Argument);
            Sql.Append(")");
            return(datePartExpression);
        }

示例#2

        public Expression VisitDatePart([NotNull] DatePartExpression datePartExpression)
        {
            Check.NotNull(datePartExpression, nameof(datePartExpression));

            Sql.Append($"EXTRACT({datePartExpression.DatePart} FROM ");

            Visit(datePartExpression.Argument);
            Sql.Append(")");

            return(datePartExpression);
        }