SQLite.SQLiteCommand Class Reference

SQLite basic commands with bindings More...

Public Member Functions
	SQLiteCommand (SQLiteConnection conn)
	The connection with the full parced command and bindings More...
int	ExecuteNonQuery ()
	Perform a prepared SQL-command More...
IEnumerable< T >	ExecuteDeferredQuery< T > ()
	Query deferred items of type, the TableMapping will be fetched according the type More...
List< T >	ExecuteQuery< T > ()
	Query items of type, the TableMapping will be fetched according the type More...
List< T >	ExecuteQuery< T > (TableMapping map)
	Query items of the tablemapping More...
IEnumerable< T >	ExecuteDeferredQuery< T > (TableMapping map)
	Query deferred of items of just one Row More...
T	ExecuteScalar< T > ()
	Query one item of just one Row More...
IEnumerable< T >	ExecuteQueryScalars< T > ()
void	Bind (string name, object val)
	Adds new Binding More...
void	Bind (object val)
	Binding the object More...
override string	ToString ()
	overriding the .Tostring() for the complete CommandText More...

Protected Member Functions
virtual void	OnInstanceCreated (object obj)
	Invoked every time an instance is loaded from the database. More...

Properties
string	CommandText [get, set]
	The SQL_Net CommandText More...

Detailed Description

SQLite basic commands with bindings

Constructor & Destructor Documentation

SQLiteCommand()

SQLite.SQLiteCommand.SQLiteCommand

(

SQLiteConnection

conn

)

The connection with the full parced command and bindings

Parameters

conn

Member Function Documentation

Bind() [1/2]

void SQLite.SQLiteCommand.Bind

(

object

val

)

Binding the object

Parameters

val

Bind() [2/2]

void SQLite.SQLiteCommand.Bind	(	string	name,
		object	val
	)

Adds new Binding

Parameters

name	name of the column
val	value to bind

ExecuteDeferredQuery< T >() [1/2]

IEnumerable<T> SQLite.SQLiteCommand.ExecuteDeferredQuery< T >

(

)

Query deferred items of type, the TableMapping will be fetched according the type

Template Parameters

T

Returns

A List of the query.

ExecuteDeferredQuery< T >() [2/2]

IEnumerable<T> SQLite.SQLiteCommand.ExecuteDeferredQuery< T >

(

TableMapping

map

)

Query deferred of items of just one Row

Template Parameters

T

Returns

A IEnumerable of the query.

ExecuteNonQuery()

int SQLite.SQLiteCommand.ExecuteNonQuery

(

)

Perform a prepared SQL-command

Returns

a numeber of affected records

ExecuteQuery< T >() [1/2]

List<T> SQLite.SQLiteCommand.ExecuteQuery< T >

(

)

Query items of type, the TableMapping will be fetched according the type

Template Parameters

T

Returns

A List of the query.

ExecuteQuery< T >() [2/2]

List<T> SQLite.SQLiteCommand.ExecuteQuery< T >

(

TableMapping

map

)

Query items of the tablemapping

Template Parameters

T

Parameters

map	the map (table) to process

Returns

A List of the query.

ExecuteScalar< T >()

T SQLite.SQLiteCommand.ExecuteScalar< T >

(

)

Query one item of just one Row

Template Parameters

T

Returns

OnInstanceCreated()

virtual void SQLite.SQLiteCommand.OnInstanceCreated ( object  obj )

protectedvirtual

Invoked every time an instance is loaded from the database.

Parameters

obj	The newly created object.

This can be overridden in combination with the SQLiteConnection.NewCommand method to hook into the life-cycle of objects.

ToString()

override string SQLite.SQLiteCommand.ToString

(

)

overriding the .Tostring() for the complete CommandText

Returns

Property Documentation

CommandText

string SQLite.SQLiteCommand.CommandText

getset

The SQL_Net CommandText

---

The documentation for this class was generated from the following file:

• /Users/admin/Unity/SQLite-Extended/Assets/Picon-SQL/Core/SQLite/SQLiteCommand.cs