FreeSql学习笔记——2.插入

前言

　　由于还没有表结构，就先从新增开始，插入一些数据后才好做查询、修改、删除操作。

初始化

　　前面注入FreeSql时设置过自动同步表结构，那么就不用管数据库了，只需要在项目中定义实体，就会自动生成表结构，这里创建一个学生类Student

/// 

/// 学生
/// 
[Table(Name = "Student")]
public class Student
{
    /// 

    /// 自增主键
    /// 
    [Column(IsIdentity = true, IsPrimary = true)]
    public long Id { get; set; }

    /// 

    /// 姓名
    /// 
    [Column(IsNullable = false, DbType = "varchar(20)")]
    public string Name { get; set; }

    /// 

    /// 年龄
    /// 
    public int Age { get; set; }

    public StatusEnum Status { get; set; }

    /// 

    /// 添加时间
    /// 
    public DateTime AddTime { get; set; }

    /// 

    /// 说明
    /// 
    [Column(IsNullable =true,DbType = "varchar(100)")]
    public string Remark { get; set; }
}

/// 

/// 状态枚举    1.正常   2.冻结
/// 
public enum StatusEnum
{

    Normal = 1,

    Freeze = 2
}

[HttpGet("AddStudent")]
public async Task AddStudent()
{
    var student = new Student
    {
        Name = "小明",
        Age = 8,
        Status = StatusEnum.Normal,
        AddTime = DateTime.Now
    };

    var res = await _freeSql.Insert().AppendData(student).ExecuteInsertedAsync();

    return Ok();
} 

批量插入

var studentList = new List();

for (int i = 0; i < 10; i++)
{
    studentList.Add(new Student
    {
        Name = "小明" + i,
        Age = i,
        Status = StatusEnum.Normal,
        AddTime = DateTime.Now
    });
}

//await _freeSql.Insert(studentList).ExecuteSqlBulkCopyAsync();
var res = await _freeSql.Insert(studentList).ExecuteAffrowsAsync();

return Ok();

插入指定列、忽略列

_freeSql.Insert(student1).ExecuteAffrowsAsync();//正常插入

_freeSql.Insert(student2)
                .InsertColumns(x => new { x.Name, x.Age, x.Status, x.AddTime })
                .ExecuteAffrowsAsync();//指定列
//等价于
_freeSql.Insert(student2)
                .IgnoreColumns(x => x.Remark)
                .ExecuteAffrowsAsync();//忽略列

字典插入

var dic = new Dictionary();
dic.Add("Name", "Dic");
dic.Add("Age", 1);
dic.Add("Status", StatusEnum.Normal);
dic.Add("AddTime", DateTime.Now);

_freeSql.InsertDict(dic).AsTable(nameof(Student)).ExecuteAffrowsAsync();