C# (CSharp) QueryBuilder.AddFromSubSelect示例

示例#1

        public Task <int> CountTracks(TrackFilterDo filter = null)
        {
            QueryBuilder baseQuery  = GetTrackQuery(filter);
            var          countQuery = new QueryBuilder();

            countQuery.AddSelectStatement("COUNT(*)");
            countQuery.AddFromSubSelect(baseQuery, "base");

            var sql = countQuery.BuildStatement();

            return(ExecuteScalar <int>(sql, baseQuery.Parameters));
        }