ISqlExecutor.Scalar<TValue>(string sqlText, params object[] parameters) Method

.NET Standard 2.x

Executes the SQL SELECT statement and returns the first column of the first row in the result set. All other columns and rows are ignored.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Syntax

  public TValue Scalar<TValue>(string sqlText, params object[] parameters);

Type Parameters

TValue

The datatype of the first column in the result set.

Parameters

sqlText System.String

A raw SQL statement which contains the parameter placeholders.

The proper syntax of a parameter placeholder is specific to the data source (e.g., @newFirstName for SQL Server). To make a parameterized SQL ( e.g, update Person set FirstName = @newFirstName where PersonId = 1), these placeholders are filled in with the actual parameter values when the SQL statement is executed.

parameters System.Object[]

(Optional) One or more ParamValue objects which contain the values corresponding to the SQL parameter identifier names.

You can also pass the arguments directly in the order in which each parameter identifier name appears in sqlText for the first time, without using the ParamValue object.

Returns

TValue

Returns the value of the first column of the first row in the result set. Returns a null, if no data is found in the result set.

Remarks

You can use parameter placeholders in the raw SQL Statement. It is recommended to use the syntax for parameter placeholders that is specific to the data source. e.g., uses @parametername for SQL Server and uses :parametername for Oracle.

Examples

The following code example demonstrates how to use the Scalar(String, params Object[]) method to execute the SQL SELECT statement and return the first column of the first row in the result set.

using SnapObjects.Data;
using System;

namespace Appeon.ApiDoc.ISqlExecutorExamples
{
    public class ScalarExample
    {
        private readonly SchoolContext _context;

        public ScalarExample(SchoolContext dataContext)
        {
            // Sets the data context
            _context = dataContext;
        }

        public void Example1()
        {
            // Defines the SQL statement.
            var sql = "select title from Course where CourseID = 2042";

            // Executes the SQL statement and returns the query result.
            var title = _context.SqlExecutor.Scalar<string>(sql);

            Console.WriteLine("Title: {0} ", title);

            /*This code produces the following output:

            Title: Literature
            */
        }
    }
}

Applies to

.NET Standard

2.x