CodeInsiders.SharpQL.Doc._TSql.GroupByTests.Test1 C# (CSharp) Метод

        public void Test1()
        {
            var q = new SharpQuery();
            var u = new UserTable();
            var p = new PostTable();

            q.Select(u.Id, Sql.Count(1))
                .From(u)
                .InnerJoin(p, p.UserId.IsEqualTo(u.Id))
                .GroupBy(u.Id)
                .EndStatement();
            var query = q.ToString();

            TSqlAssert.ScriptsAreEqual(query, @"
            SELECT
            [dbo].[User].[Id]
              , COUNT( @p0  )
            FROM [dbo].[User]
            INNER JOIN [dbo].[Post] ON [dbo].[Post].[UserId] = [dbo].[User].[Id]
            GROUP BY
            [dbo].[User].[Id]");
        }