Dapper Plus - CreateTable with Data Annotation | C# Online Compiler

Dapper Plus - CreateTable with Data Annotation by ZZZ Projects

// Dapper Plus
// Doc: https://dapper-plus.net/create-table

// @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 Microsoft.Data.SqlClient;
using Dapper;
using Z.Dapper.Plus;

public class Program
{	
	public static void Main()
	{
		var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
		
		connection.CreateTable<Customer>();
		
		FiddleHelper.WriteTable("CustomCustomer:", connection.Query<Customer>("SELECT CustomerID, FullName as Name, Email, Version FROM CustomerWithAnnotation"));
	}
	
	[Table("CustomerWithAnnotation")]
	public class Customer 
	{
		[Key]
		[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
		public int CustomerID { get; set; }
		[Column("FullName", TypeName="nvarchar(50)")]
		public string Name { get; set; }
		public string Email { get; set; }
		
		[Timestamp]
		public byte[] Version { get; set; }
		
		[NotMapped]
		public string NotMapped { get; set; }
	}
}

​x
 
// Dapper Plus
// Doc: https://dapper-plus.net/create-table
​
// @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 Microsoft.Data.SqlClient;
using Dapper;
using Z.Dapper.Plus;
​
public class Program
{   
    public static void Main()
    {
        var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
        
        connection.CreateTable<Customer>();
        
        FiddleHelper.WriteTable("CustomCustomer:", connection.Query<Customer>("SELECT CustomerID, FullName as Name, Email, Version FROM CustomerWithAnnotation"));
    }
    
    [Table("CustomerWithAnnotation")]
    public class Customer 
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int CustomerID { get; set; }
        [Column("FullName", TypeName="nvarchar(50)")]
        public string Name { get; set; }
        public string Email { get; set; }
        
        [Timestamp]
        public byte[] Version { get; set; }
        
        [NotMapped]
        public string NotMapped { 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