internal static void SelectAndFirstSql(AdventureWorks adventureWorks)
{
SelectExpression databaseExpression = SelectAndFirstDatabaseExpressions(adventureWorks);
IRelationalCommand sql = adventureWorks.Generate(databaseExpression: databaseExpression, parameters: null);
sql.CommandText.WriteLine();
// SELECT TOP(1) [product].[Name]
// FROM [Production].[Product] AS [product]
}
internal static void WhereAndSelectSql(AdventureWorks adventureWorks)
{
SelectExpression databaseExpression = WhereAndSelectDatabaseExpressions(adventureWorks);
IRelationalCommand sql = adventureWorks.Generate(databaseExpression: databaseExpression, parameters: null);
sql.CommandText.WriteLine();
// SELECT [product].[Name]
// FROM [Production].[ProductCategory] AS [product]
// WHERE CAST(LEN([product].[Name]) AS int) > 10
}
