Click or drag to resize
SqlDialectSelect Method
Creates a select SQL.

Namespace: LiteRepository
Assembly: LiteRepository (in LiteRepository.dll) Version: 2.0.4
Syntax
C#
Copy
public abstract string Select(
	string tableName,
	string fields,
	string where,
	string orderBy,
	Nullable<int> top = null
)

Parameters

tableName
Type: SystemString
Name of the table.
fields
Type: SystemString
Comma-separated list of columns.
where
Type: SystemString
Where conditions. For example: column1 = 'abc' and column2 < 2.
orderBy
Type: SystemString
Comma-separated list of columns for sorting.
top (Optional)
Type: SystemNullableInt32
Value what represents a limit for row to retrive.

Return Value

Type: String
A string with a select query.
See Also