C# Extension Method: DbCommand - ExecuteScalarToOrDefault

CSharp · Console

/Program.cs

// C# Extension Method
// Doc: https://csharp-extension.com/en/method/1002752/dbcommand-executescalartoordefault

// @nuget: Z.ExtensionMethods

using System;
using System.Data.SqlClient;
					
public class Program
{
	public static void Main()
	{
        const string sql = @"SELECT 'FizzBuzz' As StringColumn";

        using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
        {
            using (SqlCommand command = conn.CreateCommand())
            {
                conn.Open();
                command.CommandText = sql;
				
				//C# Extension Method: DbCommand - ExecuteScalarToOrDefault
                Console.WriteLine(command.ExecuteScalarToOrDefault<string>());
				Console.WriteLine(command.ExecuteScalarToOrDefault<int>());
                Console.WriteLine(command.ExecuteScalarToOrDefault(-1));
                Console.WriteLine(command.ExecuteScalarToOrDefault(c => -2));
            }
        }
	}
}