Defines methods for generating SQL queries and handling query-related operations.

Namespace

Interfaces

IDisposable

Implementing Types

graph BT Type-.->Interface0["IDisposable"] Type["IQueryGenerator"] class Type type-node Implementing0["QueryGenerator"]-.->Type click Implementing0 "/api/DbSyncKit.PostgreSQL/QueryGenerator" Implementing1["QueryGenerator"]-.->Type click Implementing1 "/api/DbSyncKit.MySQL/QueryGenerator" Implementing2["QueryGenerator"]-.->Type click Implementing2 "/api/DbSyncKit.MSSQL/QueryGenerator" Implementing3["QueryGenerator"]-.->Type click Implementing3 "/api/DbSyncKit.SQLite/QueryGenerator" Implementing4["QueryGenerationManager"]-.->Type click Implementing4 "/api/DbSyncKit.Templates/QueryGenerationManager"

Syntax

public interface IQueryGenerator : IDisposable

Methods

Name	Return Value	Summary
EscapeColumn(string)	string	Escapes the input column name to be used safely in SQL queries.
EscapeValue(object)	object	Escapes special characters in the input to make it SQL-safe.
GenerateBatchSeparator()	string	Generates a SQL batch separator ('GO' statement in SQL Server) used to execute batches of SQL statements.
GenerateComment(string)	string	Generates a SQL comment.
GenerateDeleteQuery<T>(T, List<string>)	string	Generates a DELETE query for deleting data from a database table.
GenerateInsertQuery<T>(T, List<string>, List<string>)	string	Generates an INSERT query for inserting data into a database table.
GenerateSelectQuery<T>(string, List<string>, string)	string	Generates a SELECT query for retrieving data from a database table.
GenerateUpdateQuery<T>(T, List<string>, List<string>, (string propName, object propValue)[])	string	Generates an UPDATE query for updating data in a database table.
GetCondition<T>(T, List<string>)	List<string>	Gets a condition for use in a SQL WHERE clause based on the entity and key columns.