public void OrderBy() { var q = new SharpQuery(); var u = new UserTable(); q.Select(u.AllColumns).From(u).EndStatement(); q.OrderByAsc(u.Id, u.FirstName).OrderByDesc(u.Email).EndStatement(); TSqlAssert.ScriptsAreEqual(q.ToString(), @" SELECT [dbo].[User].[Id] , [dbo].[User].[Name] , [dbo].[User].[Email] FROM [dbo].[User] ORDER BY [dbo].[User].[Id] ASC , [dbo].[User].[Name] ASC , [dbo].[User].[Email] DESC "); }
public void OrderBy2() { var q = new SharpQuery(); var u = new UserTable(); q.Select(u.AllColumns).From(u).EndStatement(); q.OrderByAsc(u.Id).OrderByDesc(u.FirstName).OrderByAsc(u.Email).EndStatement(); TSqlAssert.ScriptsAreEqual(q.ToString(), @" SELECT [dbo].[User].[Id] , [dbo].[User].[Name] , [dbo].[User].[Email] FROM [dbo].[User] ORDER BY [dbo].[User].[Id] ASC , [dbo].[User].[Name] DESC , [dbo].[User].[Email] ASC "); }