ZennoLab.CommandCenter Assembly > ZennoLab.CommandCenter Namespace > ZennoPoster.Db Class : ExecuteScalar Method |
Type: System.String
SQL query.
Type: System.Collections.Specialized
Query parameters .
Type: ZennoLab.InterfacesLibrary.Enums.Db.DbProvider
Data provider type.
Type: System.String
Connection string.
public static string ExecuteScalar( string query, OrderedDictionary param, DbProvider provider, string connectionString )
Type: System.String
SQL query.
Type: System.Collections.Specialized
Query parameters .
Type: ZennoLab.InterfacesLibrary.Enums.Db.DbProvider
Data provider type.
Type: System.String
Connection string.
Type: System.String
The first column of the first row in the result set or empty string
var count = ZennoPoster.Db.ExecuteScalar("SELECT COUNT(*) FROM User", null, ZennoLab.InterfacesLibrary.Enums.Db.DbProvider.SqlClient, "Data Source=SQLSERVER;Initial Catalog=TestDb;Integrated Security=True;max pool size=500");
$count = ZennoLab\CommandCenter\ZennoPoster::Db::ExecuteScalar("SELECT COUNT(*) FROM User", null, ZennoLab\InterfacesLibrary\Enums\Db\DbProvider::SqlClient, "Data Source=SQLSERVER;Initial Catalog=TestDb;Integrated Security=True;max pool size=500");
Target Platforms: Desktop: Windows XP SP3 and older. Server: Windows Server 2003 and older.