Dapper - ExecuteScalar | C# Online Compiler

Dapper - ExecuteScalar by ZZZ Projects

// Learn Dapper
// Doc: https://www.learndapper.com/dapper-query/selecting-scalar-values#dapper-executescalar

// @nuget: Dapper
// @nuget: Microsoft.Data.SqlClient
// @nuget: Z.Dapper.Plus

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using Microsoft.Data.SqlClient;
using Dapper;
using Z.Dapper.Plus;

public class Program
{	
	public static void Main()
	{
		var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
		
		// CREATE database and data seeding
		{
			// CREATE Table (from Dapper Plus)
			connection.CreateTable<Product>();
			
			var seedProducts = new List<Product>();
			seedProducts.Add(new Product() { Name = "Dapper Plus", CategoryID = 1, Description = @"Use <a href=""https://dapper-plus.net/"" target=""_blank"">Dapper Plus</a> to extend your IDbConnection with high-performance bulk operations." });
			seedProducts.Add(new Product() { Name = "C# Eval Expression", CategoryID = 2, Description = @"Use <a href=""https://eval-expression.net/"" target=""_blank"">C# Eval Expression</a> to compile and execute C# code at runtime." });
			seedProducts.Add(new Product() { Name = "Entity Framework Extensions", CategoryID = 1, Description = @"Use <a href=""https://entityframework-extensions.net/"" target=""_blank"">Entity Framework Extensions</a> to extend your DbContext with high-performance bulk operations." });
			
			// BulkInsert data (from Dapper Plus)
			connection.BulkInsert(seedProducts);
		}

		// Query data with Dapper
		var sql = "SELECT COUNT(*) FROM Product";
    	var count = connection.ExecuteScalar(sql);
	
    	Console.WriteLine($"Total products: {count}");
	}
	
	[Table("Product")]
	public class Product
	{
		[Key]
		[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
		public int ProductID { get; set; }
		public int CategoryID { get; set; }
		public string Name { get; set; }
		public string Description { get; set; }		
	}
}

​x
 
// Learn Dapper
// Doc: https://www.learndapper.com/dapper-query/selecting-scalar-values#dapper-executescalar
​
// @nuget: Dapper
// @nuget: Microsoft.Data.SqlClient
// @nuget: Z.Dapper.Plus
​
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using Microsoft.Data.SqlClient;
using Dapper;
using Z.Dapper.Plus;
​
public class Program
{   
    public static void Main()
    {
        var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
        
        // CREATE database and data seeding
        {
            // CREATE Table (from Dapper Plus)
            connection.CreateTable<Product>();
            
            var seedProducts = new List<Product>();
            seedProducts.Add(new Product() { Name = "Dapper Plus", CategoryID = 1, Description = @"Use <a href=""https://dapper-plus.net/"" target=""_blank"">Dapper Plus</a> to extend your IDbConnection with high-performance bulk operations." });
            seedProducts.Add(new Product() { Name = "C# Eval Expression", CategoryID = 2, Description = @"Use <a href=""https://eval-expression.net/"" target=""_blank"">C# Eval Expression</a> to compile and execute C# code at runtime." });
            seedProducts.Add(new Product() { Name = "Entity Framework Extensions", CategoryID = 1, Description = @"Use <a href=""https://entityframework-extensions.net/"" target=""_blank"">Entity Framework Extensions</a> to extend your DbContext with high-performance bulk operations." });
            
            // BulkInsert data (from Dapper Plus)
            connection.BulkInsert(seedProducts);
        }
​
        // Query data with Dapper
        var sql = "SELECT COUNT(*) FROM Product";
        var count = connection.ExecuteScalar(sql);
    
        Console.WriteLine($"Total products: {count}");
    }
    
    [Table("Product")]
    public class Product
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int ProductID { get; set; }
        public int CategoryID { get; set; }
        public string Name { get; set; }
        public string Description { get; set; }     
    }
}

Compilation error (line 4, col 7): The type or namespace name 'Json' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 36, col 21): The type or namespace name 'JsonSchema' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 51, col 28): The type or namespace name 'JsonSchema' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 22, col 26): The name 'JsonSchema' does not exist in the current context
Compilation error (line 36, col 51): The type or namespace name 'JsonSchemaBuilder' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 37, col 25): The type or namespace name 'Dictionary<,>' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 37, col 44): The type or namespace name 'JsonSchema' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 39, col 28): The type or namespace name 'JsonSchemaBuilder' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 40, col 31): The name 'SchemaValueType' does not exist in the current context
Compilation error (line 43, col 28): The type or namespace name 'JsonSchemaBuilder' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 44, col 31): The name 'SchemaValueType' does not exist in the current context
Compilation error (line 51, col 59): The type or namespace name 'JsonSchemaBuilder' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 52, col 15): The name 'SchemaValueType' does not exist in the current context
Compilation error (line 53, col 17): The name 'MetaSchemas' does not exist in the current context
Compilation error (line 56, col 25): The type or namespace name 'Dictionary<,>' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 56, col 44): The type or namespace name 'JsonSchema' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 59, col 30): The type or namespace name 'JsonSchemaBuilder' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 60, col 23): The name 'SchemaValueType' does not exist in the current context
Compilation error (line 67, col 32): The type or namespace name 'JsonSchemaBuilder' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 68, col 23): The name 'SchemaValueType' does not exist in the current context
Compilation error (line 75, col 31): The type or namespace name 'JsonSchemaBuilder' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 76, col 23): The name 'SchemaValueType' does not exist in the current context
Compilation error (line 78, col 28): The type or namespace name 'JsonSchemaBuilder' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 79, col 25): The type or namespace name 'JsonSchemaBuilder' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 83, col 19): The type or namespace name 'Dictionary<,>' could not be found (are you missing a using directive or an assembly reference?)
Compilation error (line 83, col 38): The type or namespace name 'JsonSchema' could not be found (are you missing a using directive or an assembly reference?)

Last Run:	10:18:09 pm
Compile:	0.007s
Execute:	0s
Memory:	0b
CPU:	0s

View IL Code