SQL - Extended  1.0.0
Pi-Con: Small utilities makes the difference
Classes | Public Member Functions | Properties | List of all members
SQLite.TableMapping Class Reference

The basic TableMapping class from SQLite-Net, with added code More...

Classes

class  Column
 the Column information More...
 

Public Member Functions

 TableMapping (Type type, CreateFlags createFlags=CreateFlags.None, object obj=null, SQLiteConnection conn=null)
 Set the complete Mapping of the table with all the options the columns: More...
 
TableMapping SetMapping (Type type, CreateFlags createFlags=CreateFlags.None, object obj=null, SQLiteConnection conn=null)
 Set the complete Mapping of the table with all the options the columns: More...
 
void SetAutoIncPK (object obj, long id)
 Set the value of the local property AutoIncrementPk (_autoPK) More...
 
void ResetValues ()
 Reset All the values of the column, Added for multiple records editing, and foreignKeys More...
 
Column FindColumnWithPropertyName (string propertyName)
 Find the column find the name use in the object More...
 
Column FindColumn (string columnName)
 Find the column with the name used in the database - table More...
 

Properties

Type MappedType [get]
 Type of the object we map More...
 
string TableName [get]
 Name of the mapped Table More...
 
bool WithoutRowId [get]
 True we use the Database -Table without a Rowid() See SQL-Net documentation for more details. Beware that some function can behave different when set to false. More...
 
Column[] Columns [get]
 The columns in the Object / Table More...
 
Column PK [get]
 The Primary Key column More...
 
string GetByPrimaryKeySql [get]
 Full parsed string with the SQL-Command to get the Primary Key Column More...
 
CreateFlags CreateFlags [get]
 Flags used when we create the Primary Key More...
 
bool HasAutoIncPK [get]
 True - the column has a Autoincrementing Primary Key /// More...
 
Column[] InsertColumns [get]
 Public array of all columns for the Insert, that are all columns expect the AutoInc assign column More...
 
Column[] InsertOrReplaceColumns [get]
 Public array of all columns for the InsertOrReplace, that are all columns More...
 

Detailed Description

The basic TableMapping class from SQLite-Net, with added code

Constructor & Destructor Documentation

◆ TableMapping()

SQLite.TableMapping.TableMapping ( Type  type,
CreateFlags  createFlags = CreateFlags.None,
object  obj = null,
SQLiteConnection  conn = null 
)

Set the complete Mapping of the table with all the options the columns:

Parameters
type
createFlags
obj
conn
Returns

Member Function Documentation

◆ FindColumn()

Column SQLite.TableMapping.FindColumn ( string  columnName)

Find the column with the name used in the database - table

Parameters
columnName
Returns

◆ FindColumnWithPropertyName()

Column SQLite.TableMapping.FindColumnWithPropertyName ( string  propertyName)

Find the column find the name use in the object

Parameters
propertyName
Returns

◆ ResetValues()

void SQLite.TableMapping.ResetValues ( )

Reset All the values of the column, Added for multiple records editing, and foreignKeys

◆ SetAutoIncPK()

void SQLite.TableMapping.SetAutoIncPK ( object  obj,
long  id 
)

Set the value of the local property AutoIncrementPk (_autoPK)

Parameters
obj
id

◆ SetMapping()

TableMapping SQLite.TableMapping.SetMapping ( Type  type,
CreateFlags  createFlags = CreateFlags.None,
object  obj = null,
SQLiteConnection  conn = null 
)

Set the complete Mapping of the table with all the options the columns:

Parameters
type
createFlags
obj
conn
Returns

Property Documentation

◆ Columns

Column [] SQLite.TableMapping.Columns
get

The columns in the Object / Table

◆ CreateFlags

CreateFlags SQLite.TableMapping.CreateFlags
get

Flags used when we create the Primary Key

◆ GetByPrimaryKeySql

string SQLite.TableMapping.GetByPrimaryKeySql
get

Full parsed string with the SQL-Command to get the Primary Key Column

◆ HasAutoIncPK

bool SQLite.TableMapping.HasAutoIncPK
get

True - the column has a Autoincrementing Primary Key ///

◆ InsertColumns

Column [] SQLite.TableMapping.InsertColumns
get

Public array of all columns for the Insert, that are all columns expect the AutoInc assign column

◆ InsertOrReplaceColumns

Column [] SQLite.TableMapping.InsertOrReplaceColumns
get

Public array of all columns for the InsertOrReplace, that are all columns

◆ MappedType

Type SQLite.TableMapping.MappedType
get

Type of the object we map

◆ PK

Column SQLite.TableMapping.PK
get

The Primary Key column

◆ TableName

string SQLite.TableMapping.TableName
get

Name of the mapped Table

◆ WithoutRowId

bool SQLite.TableMapping.WithoutRowId
get

True we use the Database -Table without a Rowid() See SQL-Net documentation for more details. Beware that some function can behave different when set to false.


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