C# Class HacmeBank_v2_WS.SqlServerEngine

Summary description for DataFactory_SqlServer.
Mostrar archivo Open project: o2platform/Demos_Files Class Usage Examples

Public Methods

Method Description
SqlServerEngine ( ) : System
executeSQLCommand ( string sqlQueryToExecute ) : int
executeSQLCommand_onLocalSQLServer ( string sqlQueryToExecute ) : int
executeSQLCommand_returnSqldataReader ( string sqlQueryToExecute ) : System.Data.SqlClient.SqlDataReader
returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows ( string sqlQuery ) : ArrayList
returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows_andResultingSchema ( string sqlQuery ) : ArrayList
returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows ( string sqlQuery ) : ArrayList
returnArrayListFromSQLQuery_containing_FirstRow ( string sqlQuery ) : ArrayList
returnObjectFromSQLQuery_containing_FirstFieldFromFirstRow ( string sqlQuery ) : object

Method Details

SqlServerEngine() public method

public SqlServerEngine ( ) : System
return System

executeSQLCommand() public static method

public static executeSQLCommand ( string sqlQueryToExecute ) : int
sqlQueryToExecute string
return int

executeSQLCommand_onLocalSQLServer() public static method

public static executeSQLCommand_onLocalSQLServer ( string sqlQueryToExecute ) : int
sqlQueryToExecute string
return int

executeSQLCommand_returnSqldataReader() public static method

public static executeSQLCommand_returnSqldataReader ( string sqlQueryToExecute ) : System.Data.SqlClient.SqlDataReader
sqlQueryToExecute string
return System.Data.SqlClient.SqlDataReader

returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows() public static method

public static returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows ( string sqlQuery ) : ArrayList
sqlQuery string
return System.Collections.ArrayList

returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows_andResultingSchema() public static method

public static returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows_andResultingSchema ( string sqlQuery ) : ArrayList
sqlQuery string
return System.Collections.ArrayList

returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows() public static method

public static returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows ( string sqlQuery ) : ArrayList
sqlQuery string
return System.Collections.ArrayList

returnArrayListFromSQLQuery_containing_FirstRow() public static method

public static returnArrayListFromSQLQuery_containing_FirstRow ( string sqlQuery ) : ArrayList
sqlQuery string
return System.Collections.ArrayList

returnObjectFromSQLQuery_containing_FirstFieldFromFirstRow() public static method

public static returnObjectFromSQLQuery_containing_FirstFieldFromFirstRow ( string sqlQuery ) : object
sqlQuery string
return object