Dapper - Execute - Update | C# Online Compiler

Dapper - Execute - Update by ZZZ Projects

// Learn Dapper
// Doc: https://www.learndapper.com/execute-reader

// @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);
		}
		
		// Insert data with Dapper
		var sql1 = "UPDATE Product SET Name = Name + @suffix WHERE CategoryID = @categoryID";		
		connection.Execute(sql1, new { categoryID = 1, suffix = " (Updated)" });

		// Query data with Dapper
		var sql2 = "SELECT * FROM Product WHERE CategoryID = @categoryID";
		var products = connection.Query<Product>(sql2, new { categoryID = 1 }).ToList();
		FiddleHelper.WriteTable(products);
	}
	
	[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/execute-reader
​
// @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);
        }
        
        // Insert data with Dapper
        var sql1 = "UPDATE Product SET Name = Name + @suffix WHERE CategoryID = @categoryID";       
        connection.Execute(sql1, new { categoryID = 1, suffix = " (Updated)" });
​
        // Query data with Dapper
        var sql2 = "SELECT * FROM Product WHERE CategoryID = @categoryID";
        var products = connection.Query<Product>(sql2, new { categoryID = 1 }).ToList();
        FiddleHelper.WriteTable(products);
    }
    
    [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; }     
    }
}

end paragrahph = Skip to Content
Get VIP Access: Political Hack, Canada’s best-read political newsletter, now
for just $5/month.
end paragrahph = SUBSCRIBE >> Get VIP Access: Political Hack, Canada’s
best-read political newsletter, now for just $5/month.
end paragrahph = Breadcrumb Trail Links

1 Home
2 NP Comment

*
Share via email
*
Reddit
*
X
*
Share on Linkedin
*
Open more share options
Close
Share this Story : Mark Johnson: TDSB goes out of its way to cancel Canadian
history

* SVG Image SVG Image Copy Link
*
*
Email
*
*
X
*
*
Reddit
*
*
Pinterest
*
*
LinkedIn
*
*
Tumblr

Mark Johnson: TDSB goes out of its way to cancel Canadian
history

The board failed to consult historians and then arguably violated its own bylaws in its
quest to scrub the names of historical figures from school buildings

Author of the article:
By Mark Johnson, Special to National Post
Published Apr 11, 2025
Last updated 1 day ago
3 minute read
SVG Image
Join the conversation
Submit

You can save this article by registering for free here.
end paragrahph = SVG Image
Sir John A.
end paragrahph = Macdonald Collegiate Institute
The Sir John A.
end paragrahph = Macdonald Collegiate Institute in Toronto.
end paragrahph = * Exclusive articles by Conrad Black, Barbara Kay and others.
end paragrahph = * Exclusive articles by Conrad Black, Barbara Kay and others.
end paragrahph = * Access articles from across Canada with one account
* Share your thoughts and join the conversation in the comments
* Enjoy additional articles per month
* Get email updates from your favourite authors

Sign In or Create an Account

Email Address
Continue

or

View more offers
If you are a Home delivery print subscriber, online access is included in your
subscription.
end paragrahph = Article content

Their decision was outrageous on many grounds, one of which is that it may be in
violation of the bylaw requirement that financial and budgeting information be
publicly presented.
end paragrahph = Article content
Article content

To be clear, the issue is not about denying the injustice of Canada’s residential
schools, nor the admirable goal of making our schools welcoming for all.
end paragrahph = Article content
NP Platformed Banner
Platformed

This newsletter tackles hot topics with boldness, verve and wit.
end paragrahph = A welcome email is on its way.
end paragrahph = We encountered an issue signing you up.
end paragrahph = Please try again

Interested in more newsletters?
end paragrahph = Article content

In addition to the bylaw breaches, the school board admitted that it did not consult a
single historian as part of its renaming review.
end paragrahph = Article content

How can the TDSB determine and judge 19th-century events without the benefit of
historical research?
end paragrahph = Article content

It’s time to speak out.
end paragrahph = Save Our History has been formed to do just that.
end paragrahph = We’re a
newly created, non-partisan, grassroots movement dedicated to preserving and
celebrating our rich Canadian history by protecting the historical names of our
schools.
end paragrahph = Article content
Article content

To dismissively erase Macdonald, Canada’s founding prime minister, from schools
dishonours our history.
end paragrahph = Article content
Stories You May Like

1
School classroom with blackboard.
end paragrahph = Christopher Dummitt: The TDSB should read the room on renaming schools
2
Dundas Junior Public School in Toronto.
end paragrahph = Article content

All three men were ahead of their times.
end paragrahph = Were they perfect men?
end paragrahph = No.
end paragrahph = Were they
great men?
end paragrahph = Yes.
end paragrahph = Should they be honoured?
end paragrahph = Article content

Sadly, the TDSB doesn’t plan to stop at these three schools.
end paragrahph = Article content

Nor is this only a Toronto issue.
end paragrahph = At least 10 other Ontario schools are named after
Macdonald in various cities.
end paragrahph = Trending

1 Subscriber only.
end paragrahph = Conrad Black: A Mark Carney win would be a disaster for Canada

Subscriber only
Carney
NP Comment
2 NP View: What Pierre Poilievre's massive rallies tell us about the election

poilievre
NP Comment
3 Kenney warns against letting 'small minority' of Alberta separatists dominate
political agenda

Jason Kenney.
end paragrahph = Federal Election
4 Liberals are already dreaming of a majority — and more seats in Calgary might be
key

George Chahal and Mark Carney.
end paragrahph = Article content

Our schools are falling apart.
end paragrahph = Precious money is needed to carry out urgent repairs,
which is surely a more pressing need and appropriate use of scarce resources than
name changes.
end paragrahph = Article content

At a time when our country’s very existence is threatened by U.S.
end paragrahph = Article content

If the Toronto school board were truly interested in correcting the mistakes of the
past, it would start with its own.
end paragrahph = Article content

Right-minded citizens must stand up and our leaders must act.
end paragrahph = If you care about our
national heritage, you must speak out.
end paragrahph = Article content

National Post

Article content

Mark Johnson is the founder of SaveOurHistory.ca.
end paragrahph = Create an AccountSign in
SVG ImageJoin the Conversation

Postmedia is committed to maintaining a lively but civil forum for discussion.
end paragrahph = Please
keep comments relevant and respectful.
end paragrahph = Comments may take up to an hour to
appear on the site.
end paragrahph = You will receive an email if there is a reply to your comment, an
update to a thread you follow or if a user you follow comments.
end paragrahph = -----------------------------------------------------------------------------------------------------------------------------------------
Postmedia logo

365 Bloor Street East, Toronto, Ontario, M4W 3L4

© 2025 National Post, a division of Postmedia Network Inc.
end paragrahph = Bottom links
Privacy PolicyTerms of UseCopyrightDigital Ad RegistryFAQSitemapContact us

Notice for the Postmedia Network

This website uses cookies to personalize your content (including ads), and allows us
to analyze our traffic.
end paragrahph = Read more about cookies here.
Found paragraphs ending with punctuation:

Cached Result
Last Run:	12:00:53 pm
Compile:	0.11s
Execute:	0s
Memory:	128.58kb
CPU:	0s

View IL Code