Exemplos de SnowflakeClient.ExecuteScalarAsync em C# (CSharp)

Exemplo n.º 1

        private async Task <string> CreateSimpleDatatypesTableIfNotExist()
        {
            var query = "CREATE TABLE DEMO_DB.PUBLIC.DATATYPES_SIMPLE IF NOT EXIST " +
                        "(ID INT, SomeInt INT, SomeFloat FLOAT, SomeVarchar VARCHAR, SomeBoolean BOOLEAN, SomeBinary BINARY);";

            var result = await _snowflakeClient.ExecuteScalarAsync(query);

            return(result);
        }

Exemplo n.º 2

        public async Task ExecuteScalar_WithResult()
        {
            string result = await _snowflakeClient.ExecuteScalarAsync("SELECT CURRENT_USER();");

            Assert.IsTrue(!string.IsNullOrWhiteSpace(result));
        }