public string GenerateSql() { return($@"IF {predicate.GenerateSql()} {trueValue.GenerateSql()} ELSE {falseValue.GenerateSql()}"); }
public string GenerateSql() { var alias = string.IsNullOrEmpty(Alias) ? string.Empty : $" {Alias}"; return($@"( {Format.IndentLines(source.GenerateSql())} ){alias}"); }
public string GenerateSql() { return($@"CREATE PROCEDURE [{schemaName}].[{procedureName}] ( {Format.IndentLines(string.Join("\r\n", parameters.Select(ParameterSql)))} ) AS BEGIN ( {Format.IndentLines(select.GenerateSql())} ) END"); }
public string GenerateSql() { return($@"CREATE FUNCTION dbo.[{functionName}] ( {Format.IndentLines(string.Join("\r\n", parameters.Select(ParameterSql)))} ) RETURNS TABLE AS RETURN ( {Format.IndentLines(select.GenerateSql())} )"); }
public string GenerateSql() { return($@"CREATE VIEW dbo.[{viewName}] AS {Format.IndentLines(select.GenerateSql())}"); }
public string GenerateSql() { return($"EXISTS({conditionSelect.GenerateSql()})"); }