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 }