使用Dapper将默认值插入到表中

using Dapper;
using System.Data.SqlClient;

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; } = "John Doe"; // 设置默认值为"John Doe"
    public int Age { get; set; } = 18; // 设置默认值为18
}

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString"; // 替换为你的数据库连接字符串

        using (var connection = new SqlConnection(connectionString))
        {
            connection.Open();

            var person = new Person();

            // 检查属性是否为默认值，如果是默认值则排除在插入操作之外
            var parameters = new DynamicParameters();
            if (person.Name != "John Doe")
            {
                parameters.Add("Name", person.Name);
            }
            if (person.Age != 18)
            {
                parameters.Add("Age", person.Age);
            }

            // 执行插入操作
            connection.Execute("INSERT INTO Person (Name, Age) VALUES (@Name, @Age)", parameters);
        }
    }
}