.Net ORM 访问 Firebird 数据库的方法【mysql调优】【.Net框架】

目录

• 前言
• 1、安装环境
• 2、创建项目
• 3、创建实体模型
• 4、初始化 ORM
• 5、插入数据
• 6、更新数据
• 7、查询数据
• 8、删除数据
• 结语

dotnet new console

dotnet add package FreeSql.Provider.Firebird

dotnet add package FreeSql.Repository

using System;
using FreeSql.DataAnnotations;

[Table(Name = "USER_FIREBIRD")]
public class User
{
    [Column(IsIdentity = true)]
    public long Id { get; set; }

    public string UserName { get; set; }

    public string PassWord { get; set; }

    public DateTime CreateTime { get; set; }
}

static IFreeSql fsql = new FreeSql.FreeSqlBuilder()
    .UseConnectionString(FreeSql.DataType.Firebird, 
    @"database=localhost:D:fbdataEXAMPLES.fdb;user=sysdba;password=123456;max pool size=3")
    .UseMonitorCommand(cmd => Trace.WriteLine($"线程：{cmd.CommandText}
"))
    .UseAutoSyncStructure(true) //自动创建、迁移实体表结构
    .UseNameConvert(NameConvertType.ToUpper)
    .Build();

var repo = fsql.GetRepository();

var user = new User { UserName = "gaussdb1", PassWord = "123" };
repo.Insert(user);

var users = new []
{
    new User { UserName = "gaussdb2", PassWord = "1234" },
    new User { UserName = "gaussdb3", PassWord = "12345" },
    new User { UserName = "gaussdb4", PassWord = "123456" }
};
repo.Insert(users);
//批量插入

user.PassWord = "123123";
repo.Update(user);

var One= fsql.Select(1).First(); //查询一条数据
var list = fsql.Select().Where(a => a.UserName.StartsWith("gaussdb")).ToList();

fsql.Delete(1).ExecuteAffrows();

fsql.Delete().Where(a => a.UserName.StartsWith("gaussdb")).ExecuteAffrows();