SqlStatementExtensionsSqlServer
SQL Server-specific extension methods for SelectStatement
public static class SqlStatementExtensionsSqlServer
Methods
ToSqlServer(LqlStatement)
public static Result<string, SqlError> ToSqlServer(this LqlStatement statement)
Converts a LqlStatement to SQL Server syntax
Parameters:
| Name | Type | Description |
|---|---|---|
statement |
LqlStatement |
The LqlStatement to convert |
Returns: SqlError> - A Result containing either SQL Server SQL string or a SqlError
ConvertPipelineToSqlServer(Pipeline)
public static string ConvertPipelineToSqlServer(Pipeline pipeline)
Converts a pipeline to SQL Server with proper table aliases and column handling
Parameters:
| Name | Type | Description |
|---|---|---|
pipeline |
Pipeline |
The pipeline to convert |
Returns: String - SQL Server SQL string
ToSqlServer(SelectStatement)
public static Result<string, SqlError> ToSqlServer(this SelectStatement statement)
Converts a Nimblesite.Sql.Model.SelectStatement to SQL Server syntax. Implements [DP-SQL-MODEL-DIALECTS].
Parameters:
| Name | Type | Description |
|---|---|---|
statement |
SelectStatement |
The SelectStatement to convert |
Returns: SqlError> - A Result containing either SQL Server SQL string or a SqlError