Firebird数据库安装及.NET快速开始

最新推荐文章于 2025-05-06 09:22:36 发布

Denuin多啦咧梦

最新推荐文章于 2025-05-06 09:22:36 发布

阅读量383

点赞数 3

CC 4.0 BY-SA版权

文章标签：数据库 .net

本文链接：https://blog.youkuaiyun.com/Denuin/article/details/144460820

一、安装

Windows环境

firebirdsql.org/en/firebird-5-0#windows-x64
安装选SuperServer版本

Debian/Ubuntu环境

sudo apt-get install firebird3.0-server firebird3.0-utils

# 启动Firebird服务
sudo systemctl start firebird
# 查看服务状态
sudo systemctl status firebird

CentOS

sudo yum install firebird-superserver

二、端口配置

Windows防火墙，添加入站规则，允许端口3050
sud ufw allow 3050/tcp

三、工具

Firebird ISQL Tool (自带)
github.com/mariuz/flamerobin/releases

四、快速开始

<PackageReference Include="FreeSql.Provider.Firebird" Version="3.5.102" />

public sealed class DB
{
    private static Lazy<IFreeSql> firebirdLazy = new Lazy<IFreeSql>(() =>
    {
		string dbfile = "..."; // 数据库文件
        var fsql = new FreeSql.FreeSqlBuilder()
                   .UseConnectionString(FreeSql.DataType.Firebird, $"database=localhost:{dbfile};user=sysdba;password=123456")
                   .UseMonitorCommand(cmd => Console.WriteLine($"Sql：{cmd.CommandText}"))
                   .UseAutoSyncStructure(true) //自动创建表
                   .Build();

        return fsql;
    }
   );

    public static IFreeSql Firebird => firebirdLazy.Value;
}