Appropriate C# command for ADO.NET SQlite when implementing COUNT() query

Question

Hi All,

Consider this command, as written here:

Command.CommandText = "SELECT COUNT(ASSET) AS POSEXISTS FROM POSITIONS WHERE ASSET = @ASSET";
        Command.Parameters.Add("@ASSET",DbType.String).Value = Symbol;

So here, how should I execute this query so that, I can receive the POSEXISTS variable in the C# environment.

Soham

Answer 1

int posExists = (int)Command.ExecuteScalar();