C# Класс Griffin.Data.Sqlite.SqliteCommandBuilder

Наследование: Griffin.Data.Mapper.CommandBuilders.CommandBuilder
Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
InsertCommand ( IDbCommand command, object entity ) : void

Generate an insert command, should end with a command that returns the insert identity.

Last statement will return @@identity.

Paging ( IDbCommand command, int pageNumber, int pageSize ) : void

Uses the SQLite - LIMIT [pageSize] OFFSET [pageNumber] LIMIT [no of rows] OFFSET [row num]

SqliteCommandBuilder ( ICrudEntityMapper mapper ) : System.Data

Initializes a new instance of the SqliteCommandBuilder class.

TruncateCommand ( IDbCommand command ) : void

Truncate all rows in a table

Will do a DELETE statement and reset the identity sequence generator.

Описание методов

InsertCommand() публичный Метод

Generate an insert command, should end with a command that returns the insert identity.
Last statement will return @@identity.
public InsertCommand ( IDbCommand command, object entity ) : void
command IDbCommand Command to add the query to
entity object Entity to store
Результат void

Paging() публичный Метод

Uses the SQLite - LIMIT [pageSize] OFFSET [pageNumber] LIMIT [no of rows] OFFSET [row num]
public Paging ( IDbCommand command, int pageNumber, int pageSize ) : void
command IDbCommand command to modify
pageNumber int One based index
pageSize int Items per page.
Результат void

SqliteCommandBuilder() публичный Метод

Initializes a new instance of the SqliteCommandBuilder class.
public SqliteCommandBuilder ( ICrudEntityMapper mapper ) : System.Data
mapper ICrudEntityMapper The mapper.
Результат System.Data

TruncateCommand() публичный Метод

Truncate all rows in a table
Will do a DELETE statement and reset the identity sequence generator.
public TruncateCommand ( IDbCommand command ) : void
command IDbCommand Command that will be executed after this method call
Результат void