C# Class Squire.Framework.SqlKihonStructure

Inheritance: BaseDataKihon

Mostra file Open project: roundtable/Squire

Protected Methods

Method	Description
CreateTestData ( SQLiteConnection dbConn ) : void
Insert_PersonId_4_Named_Mike_Johnson_Age_5_To_Person ( ) : string
Select_All_Fields_And_Rows_From_Person ( ) : string
Select_All_Fields_From_Person_Joined_To_Address ( ) : string
Select_All_Fields_From_Person_Left_Outer_Joined_To_Address ( ) : string
Select_FirstName_From_Person_Where_LastName_Equals_Rayburn ( ) : string
Update_All_LastNames_Rayburn_To_Johnson_In_Person ( ) : string

Private Methods

Method	Description
Actual_Insert_PersonId_4_Named_Mike_Johnson_Age_5_To_Person ( ) : void
Actual_Select_All_Fields_And_Rows_From_Person ( ) : void
Actual_Select_All_Fields_From_Person_Joined_To_Address ( ) : void
Actual_Select_All_Fields_From_Person_Left_Outer_Joined_To_Address ( ) : void
Actual_Select_FirstName_From_Person_Where_LastName_Equals_Rayburn ( ) : void
Actual_Update_All_LastNames_Rayburn_To_Johnson_In_Person ( ) : void
CreateAddressTable ( ) : string
CreatePersonTable ( ) : string
Execute ( string cmdText, Action rdrAction ) : void
ExecuteNonQuery ( string cmdText ) : int
ExecuteScalarInt ( string cmdText ) : int
SampleAddress ( ) : string
SamplePersons ( ) : string

Method Details

CreateTestData() protected method

protected CreateTestData ( SQLiteConnection dbConn ) : void
dbConn	System.Data.SQLite.SQLiteConnection
return	void

Insert_PersonId_4_Named_Mike_Johnson_Age_5_To_Person() protected abstract method

protected abstract Insert_PersonId_4_Named_Mike_Johnson_Age_5_To_Person ( ) : string
return	string

Select_All_Fields_And_Rows_From_Person() protected abstract method

protected abstract Select_All_Fields_And_Rows_From_Person ( ) : string
return	string

Select_All_Fields_From_Person_Joined_To_Address() protected abstract method

protected abstract Select_All_Fields_From_Person_Joined_To_Address ( ) : string
return	string

Select_All_Fields_From_Person_Left_Outer_Joined_To_Address() protected abstract method

protected abstract Select_All_Fields_From_Person_Left_Outer_Joined_To_Address ( ) : string
return	string

Select_FirstName_From_Person_Where_LastName_Equals_Rayburn() protected abstract method

protected abstract Select_FirstName_From_Person_Where_LastName_Equals_Rayburn ( ) : string
return	string

Update_All_LastNames_Rayburn_To_Johnson_In_Person() protected abstract method

protected abstract Update_All_LastNames_Rayburn_To_Johnson_In_Person ( ) : string
return	string