SQLiteContext
Context for building SQLite queries with proper table aliases and structure
public sealed class SQLiteContext : SelectContextBase, ISqlContext
Constructors
SQLiteContext
public SQLiteContext()
Initializes a new instance of the SQLiteContext class
Methods
SetBaseTable(string)
public override void SetBaseTable(string tableName)
Sets the base table for the query
Parameters:
| Name | Type | Description |
|---|---|---|
tableName |
String |
The base table name |
AddJoin(string, string, string?)
public override void AddJoin(string joinType, string tableName, string? condition)
Adds a JOIN to the query
Parameters:
| Name | Type | Description |
|---|---|---|
joinType |
String |
The type of join (INNER JOIN, LEFT JOIN, etc.) |
tableName |
String |
The table to join |
condition |
String |
The join condition |
GenerateSQL()
public override string GenerateSQL()
Generates the final SQL query
Returns: String - The SQL query string
ProcessPipeline(Pipeline)
public string ProcessPipeline(Pipeline pipeline)
Processes a pipeline and returns the generated SQL
Parameters:
| Name | Type | Description |
|---|---|---|
pipeline |
Pipeline |
The pipeline to process |
Returns: String - The generated SQLite SQL
ToSQLiteSql(SelectStatement)
public static string ToSQLiteSql(SelectStatement statement)
Public helper to generate SQLite SQL from an existing SelectStatement
Parameters:
| Name | Type | Description |
|---|---|---|
statement |
SelectStatement |
The statement to generate SQL for |
Returns: String - SQLite SQL string