Dapper Plus - Dapper Plus Context - Instance Context

CSharp · Console

/Program.cs

// Dapper Plus
// Doc: https://dapper-plus.net/dapper-plus-context

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

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()
	{
		// Map your entity
		DapperPlusManager.Entity<Product>()
			.Table("Product")
			.Identity(x => x.ProductID);
		
		var products = new List<Product>();
		products.Add(new Product() { ProductID = 13, Name = "Dapper Plus", Description = @"Use <a href=""https://dapper-plus.net/"" target=""_blank"">Dapper Plus</a> to extend your IDbConnection with high-performance bulk operations." });
		products.Add(new Product() { ProductID = 66, Name = "C# Eval Expression", Description = @"Use <a href=""https://eval-expression.net/"" target=""_blank"">C# Eval Expression</a> to compile and execute C# code at runtime." });
		products.Add(new Product() { ProductID = 99, Name = "Entity Framework Extensions", Description = @"Use <a href=""https://entityframework-extensions.net/"" target=""_blank"">Entity Framework Extensions</a> to extend your DbContext with high-performance bulk operations." });
		
		var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
		connection.CreateTable<Product>();
		
		CustomInsert(products.Take(1), false, new List<string>() { "Name"});
		CustomInsert(products.Skip(1), true, new List<string>() { "Name", "Description"});
		
		// Query data with Dapper
		FiddleHelper.WriteTable(connection.Query<Product>("SELECT * FROM Product"));
	}
	
	public static void CustomInsert(IEnumerable<Product> products, bool keepIdentityValue, List<string> mappingColumnNames)
	{
		var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
		var context = new DapperPlusContext(connection);

		var mapping = context.Entity<Product>().Identity(x => x.ProductID);
		
		mappingColumnNames.ForEach(x => mapping.Map(x));

		if(keepIdentityValue)
		{
			mapping.UseBulkOptions(options => options.InsertKeepIdentity = true);
		}

		context.BulkInsert(products);
	}

	[Table("Product")]
	public class Product
	{
		[Key]
		[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
		public int ProductID { get; set; }
		public string? Name { get; set; }
		public string? Description { get; set; }
		
	}
}