'Declaration Public Overrides Function ExecuteScalar() As Object
public override object ExecuteScalar()
Return Value
The first column of the first row in the result set.
'Declaration Public Overrides Function ExecuteScalar() As Object
public override object ExecuteScalar()
using(DynamicsConnection conn = new DynamicsConnection(connectionString)) { conn.Open(); DynamicsCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions"; Int64 count = Convert.ToInt64(cmd.ExecuteScalar()); }
Dim conn As New DynamicsConnection(connectionString) conn.Open() Dim cmd As DynamicsCommand = conn.CreateCommand() cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions" Dim count As Int64 = Convert.ToInt64(cmd.ExecuteScalar()); conn.Close()