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
");
}
