GPAL - Generally Positive Automation Library v1.0
GPAL The Fluent Automation LIbrary
Loading...
Searching...
No Matches
GenerallyPositive.IAllowDatabaseGridSettings Interface Reference

SaveTo(...) already ran the read (an out parameter forces that), so chaining .Execute() afterward would just re-run the same command as a meaningless non-query. Chain more settings instead, or .ToGPALObject() to get back to the full interface for a new Create/Read/Update/Delete. More...

Inheritance diagram for GenerallyPositive.IAllowDatabaseGridSettings:
GenerallyPositive.IAllowDatabaseSettings GenerallyPositive.IAllowToGPALObject< TResult > GenerallyPositive.GPALDatabase

Public Member Functions

IAllowDatabaseSettings GetRowCount (out List< int > rowCountsPerTable)
 Only SaveTo(out IGPALGrid<string>) returns this - meaningless for SaveTo(DataTable)/SaveTo(DataSet), which already separate results by table. Optional to call: tells you how many of the grid's rows belong to each result set the query returned, in order, since a flat grid otherwise can't signal where one table's rows end and the next begin.
Public Member Functions inherited from GenerallyPositive.IAllowDatabaseSettings
IAllowDatabaseSettings WithConnectionString (string connectionString)
IAllowDatabaseSettings WithCommandTimeout (int timeoutInSeconds)
IAllowDatabaseSettings Close ()
IAllowDatabaseSettings WithUsername (string userName)
IAllowDatabaseSettings WithPassword (string password)
IAllowDatabaseSettings WithServerName (string serverName)
IAllowDatabaseSettings WithDatabaseName (string databaseName)
IAllowDatabaseSettings WithDatabaseType (DatabaseType databaseType)
IAllowDatabaseSettings WithTableName (string tableName)
IAllowDatabaseSettings WithSQLCommand (string sqlCommand)
IAllowDatabaseSettings WithStoredProcedure (string storedProcedure)
IAllowDatabaseSettings WithParameterName (string parameterName)
IAllowDatabaseSettings WithDatetimeParameter (string parameterName)
IAllowDatabaseSettings WithTimeParameter (string parameterName)
IAllowDatabaseSettings WithTimestampParameter (string parameterName)
IAllowPrecsionScaleAndSettings WithDecimalParameter (string parameterName)
IAllowDatabaseSettings WithFloatParameter (string parameterName)
IAllowDatabaseSettings WithImageParameter (string parameterName)
IAllowDatabaseSettings WithIntegerParameter (string parameterName)
IAllowDatabaseSettings WithMoneyParameter (string parameterName)
IAllowParameterLength WithVarCharParameter (string parameterName)
IAllowParameterLength WithNVarCharParameter (string parameterName)
IAllowParameterLength WithCharParameter (string parameterName)
IAllowParameterLength WithNCharParameter (string parameterName)
IAllowParameterLength WithTextParameter (string parameterName)
IAllowParameterLength WithNTextParameter (string parameterName)
IAllowDatabaseSettings WithTableParameter (string parameterName)
IAllowDatabaseSettings WithRowCount (int rowCount)
IAllowDatabaseSettings WithCreateAs (string createSQL)
IAllowDatabaseSettings WithReadAs (string selectSQL)
IAllowDatabaseSettings WithUpdateAs (string updateSQL)
IAllowDatabaseSettings WithDeleteAs (string deleteSQL)
IAllowDatabaseSettings WithErrorCallback (GPALDatabase.CallOnError CallOnError)
IAllowDatabaseSettings WithUDTTName (string typeName)
Public Member Functions inherited from GenerallyPositive.IAllowToGPALObject< TResult >
TResult ToGPALObject ()

Detailed Description

SaveTo(...) already ran the read (an out parameter forces that), so chaining .Execute() afterward would just re-run the same command as a meaningless non-query. Chain more settings instead, or .ToGPALObject() to get back to the full interface for a new Create/Read/Update/Delete.

Definition at line 224 of file Interfaces.cs.

Member Function Documentation

◆ GetRowCount()

IAllowDatabaseSettings GenerallyPositive.IAllowDatabaseGridSettings.GetRowCount ( out List< int > rowCountsPerTable)

Only SaveTo(out IGPALGrid<string>) returns this - meaningless for SaveTo(DataTable)/SaveTo(DataSet), which already separate results by table. Optional to call: tells you how many of the grid's rows belong to each result set the query returned, in order, since a flat grid otherwise can't signal where one table's rows end and the next begin.

Implemented in GenerallyPositive.GPALDatabase.


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