C#中使用嵌入式firebird数据库

使用Firebird创建数据库及数据操作示例

最新推荐文章于 2022-11-07 11:49:58 发布

最新推荐文章于 2022-11-07 11:49:58 发布 · 262 阅读

文章标签：

#数据库 #嵌入式

本文介绍如何使用Firebird SQL创建数据库、创建表、插入数据的基本步骤，并展示了通过C#实现这些操作的代码示例。

using System; using System.Collections.Generic; using System.Text; using FirebirdSql.Data.FirebirdClient; namespace CreateDB { class Program { static void Main(string[] args) { FbConnection.CreateDatabase(GetConnectionString()); using (FbConnection conn = new FbConnection(GetConnectionString())) { conn.Open(); using (FbCommand createTable = conn.CreateCommand()) { createTable.CommandText = "create table test (id int, word varchar(20) character set win1250)"; createTable.ExecuteNonQuery(); } using (FbCommand insertData = conn.CreateCommand()) { insertData.CommandText = "insert into test values (@id, @word)"; for (int i = 0; i < 10; i++) { insertData.Parameters.Clear(); insertData.Parameters.Add("@id", FbDbType.Integer).Value = i; insertData.Parameters.Add("@word", FbDbType.VarChar, 20).Value = GetWord(i); insertData.ExecuteNonQuery(); } } } } static string GetConnectionString() { FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.Database = "test.fdb"; cs.UserID = "SYSDBA"; cs.Password = "masterkey"; cs.Charset = "UTF8"; cs.ServerType = FbServerType.Embedded; return cs.ToString(); } static string GetWord(int i) { StringBuilder sb = new StringBuilder(i); for (int j = 0; j < i; j++) { sb.Append(i); } return sb.ToString(); } } }