SqlServerDialect.Select Method

SqlServerDialectSelect Method

Creates a select SQL.

Namespace: LiteRepository.SqlServer
Assembly: LiteRepository (in LiteRepository.dll) Version: 2.0.4

Syntax

public override string Select(
	string tableName,
	string fields,
	string where,
	string orderBy,
	Nullable<int> top = null
)

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.

Type: String
A string with a select query.